MM Report Custom development ALV report

Released Purchase Requisitions Not Yet Converted to Purchase Orders Report

Short answer: A custom ALV report that lists released purchase requisition items not yet converted to a purchase order, with open quantity, open value and days waiting since release. It shows the workload per purchasing group and requisitions whose need date is close, on one screen.

Estimated effort
S · 2–3 working days
System
ECC and S/4HANA
Tables
4
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

ME5A lists open requisitions with their release status, but it does not show the days since release, the open value or the number of waiting requisitions per purchasing group. ME57 focuses on source assignment and gives no ageing. Managers process the list in Excel to see which group has kept how many requisitions waiting, and for how long.

Who uses it? Purchasing managers, buyers and requesters who follow up on their requisitions.

Closest standard alternatives

  • ME5A Purchase Requisitions: List Display. Lists open requisitions with release status; no days waiting and no workload summary per group.
  • ME57 Assign and Process Requisitions. Assigns sources to requisitions and converts them; gives no ageing or management summary.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
EBANPurchase RequisitionRequisition item: quantity, quantity ordered, release indicator and dates (driving table)—ECC + S/4
T024Purchasing GroupsPurchasing group name and email addressT024-EKGRP = EBAN-EKGRPECC + S/4
MAKTMaterial DescriptionsMaterial description (logon language)MAKT-MATNR = EBAN-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
I_PurchaseRequisitionItemAPI01Purchase Requisition Item (API)In S/4HANA it can replace EBAN with a clean core approachPurchaseRequisition = EBAN-BANFN AND PurchaseRequisitionItem = EBAN-BNFPOS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleEBAN-WERKSYes1000
S_EKGRPPurchasing groupRange / multipleEBAN-EKGRPNo001
S_BSARTRequisition document typeRange / multipleEBAN-BSARTNoNB
S_AFNAMRequisitionerRange / multipleEBAN-AFNAMNoBAKIM
S_MATKLMaterial groupRange / multipleEBAN-MATKLNo01
S_FRGDTRelease date rangeRange / multipleEBAN-FRGDTNo01.09.2026 – 17.11.2026
P_MINAGEMinimum days waitingSingle value—No5
P_KEYDTKey date (default: today)Single valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1Purchase requisitionEBAN-BANFN
2ItemEBAN-BNFPO
3Document typeEBAN-BSART
4Purchasing groupEBAN-EKGRP
5Group nameT024-EKNAM
6RequisitionerEBAN-AFNAM
7MaterialEBAN-MATNR
8Short textEBAN-TXZ01
9PlantEBAN-WERKS
10Open qtyCalculated EBAN-MENGE − EBAN-BSMNG
11UnitEBAN-MEINS
12Open valueCalculated Open qty × EBAN-PREIS ÷ EBAN-PEINH
13CurrencyEBAN-WAERS
14Release dateEBAN-FRGDT
15Delivery dateEBAN-LFDAT
16Days waitingCalculated Key date − EBAN-FRGDT (EBAN-BADAT if empty)

Sample output

Purchase requisitionItemDocument typePurchasing groupGroup nameRequisitionerMaterialShort textPlantOpen qtyUnitOpen valueCurrencyRelease dateDelivery dateDays waiting
001000452100010NB001Raw Material BuyingURETIMRM-1001Carton box 40x3010002,000PC3,400TRY10/30/202611/25/202618
001000453300020NB002Spare PartsBAKIMSP-7720Bearing 6205100040PC6,800TRY11/04/202611/20/202613
001000456000010NB003Indirect SpendIDARIOffice chair200012PC42,000TRY11/10/202612/15/20267
001000457100030NB001Raw Material BuyingURETIMRM-2040Steel sheet 2 mm20001,500KG91,800TRY10/12/202611/18/202636
A view built with fictional sample data; not real system data.

How does the report work?

  1. EBAN is read with the selection criteria; deleted (LOEKZ) and closed (EBAKZ) items are skipped.
  2. For items with a release strategy, only those whose release indicator (FRGKZ) allows conversion to a purchase order remain; the valid values are parameterized according to the customer’s release strategy setup. Items without a release strategy are included directly.
  3. Open quantity = requested quantity (MENGE) − quantity ordered (BSMNG); items with zero open quantity are skipped.
  4. Open value = open quantity × valuation price (PREIS) ÷ price unit (PEINH).
  5. Days waiting = key date − release date (FRGDT); if the release date is empty, the requisition date (BADAT) is used. The purchasing group name comes from T024, the material description from MAKT; the ALV shows count and value totals per purchasing group.

Performance notes

Narrow the EBAN selection by plant and purchasing group and put the LOEKZ and EBAKZ conditions directly into SQL. The report is light and runs online on most systems; use a background job with email for a weekly management summary.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the requisition number opens ME53N.
  • Export to Excel
  • Runs as a background job
  • Send the result by email A weekly summary of waiting requisitions can be sent to the purchasing manager.

Authorization objects

  • M_BANF_WRKPurchase requisition display authorization by plant
  • M_BANF_EKGPurchase requisition display authorization by purchasing group
  • M_BANF_BSAPurchase requisition display authorization by document type

Frequently asked questions

Do partly ordered requisitions appear in the list?

Yes. Because open quantity is EBAN-MENGE minus EBAN-BSMNG, partly ordered items are listed with the remaining quantity.

How does it work for companies with different release strategies?

The release indicator values that count as convertible are stored in a parameter table during installation, so each company filters according to its own release strategy.

Does this report work on S/4HANA?

Yes. EBAN keeps the same structure in S/4HANA; flexible workflow approvals in Fiori fill the same release indicator. For clean core, I_PurchaseRequisitionItemAPI01 can be used.

Packages that include this solution

MM Package Custom

Purchasing Approval and Cycle Time Pack

A four-component pack that shows where purchasing waits between requisition and payment: released requisitions not yet ordered, purchase orders …

4 components · v1.0

Related reports

MM Report Custom ALV report

Open Purchase Orders by Vendor Report

A custom ALV report that shows, per vendor, the quantity not yet received, the open order value and the days of delay since the delivery date in a …

EKKO · EKPO · EKET · LFA1

MM Program Custom Mass upload

Mass Purchase Order Creation from Excel Program

A custom program that creates purchase orders in bulk from Excel or CSV rows, grouping them by vendor, purchasing organization and group number. It …

EKKO · EKPO · EKET · EKKN

Let us build this report for your system

Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.

Related report: Released Purchase Requisitions Not Yet Converted to Purchase Orders Report