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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| EBANPurchase Requisition | Requisition item: quantity, quantity ordered, release indicator and dates (driving table) | — | ECC + S/4 |
| T024Purchasing Groups | Purchasing group name and email address | T024-EKGRP = EBAN-EKGRP | ECC + S/4 |
| MAKTMaterial Descriptions | Material description (logon language) | MAKT-MATNR = EBAN-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| I_PurchaseRequisitionItemAPI01Purchase Requisition Item (API) | In S/4HANA it can replace EBAN with a clean core approach | PurchaseRequisition = EBAN-BANFN AND PurchaseRequisitionItem = EBAN-BNFPO | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | EBAN-WERKS | Yes | 1000 |
| S_EKGRP | Purchasing group | Range / multiple | EBAN-EKGRP | No | 001 |
| S_BSART | Requisition document type | Range / multiple | EBAN-BSART | No | NB |
| S_AFNAM | Requisitioner | Range / multiple | EBAN-AFNAM | No | BAKIM |
| S_MATKL | Material group | Range / multiple | EBAN-MATKL | No | 01 |
| S_FRGDT | Release date range | Range / multiple | EBAN-FRGDT | No | 01.09.2026 – 17.11.2026 |
| P_MINAGE | Minimum days waiting | Single value | — | No | 5 |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Purchase requisition | EBAN-BANFN |
| 2 | Item | EBAN-BNFPO |
| 3 | Document type | EBAN-BSART |
| 4 | Purchasing group | EBAN-EKGRP |
| 5 | Group name | T024-EKNAM |
| 6 | Requisitioner | EBAN-AFNAM |
| 7 | Material | EBAN-MATNR |
| 8 | Short text | EBAN-TXZ01 |
| 9 | Plant | EBAN-WERKS |
| 10 | Open qty | Calculated EBAN-MENGE − EBAN-BSMNG |
| 11 | Unit | EBAN-MEINS |
| 12 | Open value | Calculated Open qty × EBAN-PREIS ÷ EBAN-PEINH |
| 13 | Currency | EBAN-WAERS |
| 14 | Release date | EBAN-FRGDT |
| 15 | Delivery date | EBAN-LFDAT |
| 16 | Days waiting | Calculated Key date − EBAN-FRGDT (EBAN-BADAT if empty) |
Sample output
| Purchase requisition | Item | Document type | Purchasing group | Group name | Requisitioner | Material | Short text | Plant | Open qty | Unit | Open value | Currency | Release date | Delivery date | Days waiting |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0010004521 | 00010 | NB | 001 | Raw Material Buying | URETIM | RM-1001 | Carton box 40x30 | 1000 | 2,000 | PC | 3,400 | TRY | 10/30/2026 | 11/25/2026 | 18 |
| 0010004533 | 00020 | NB | 002 | Spare Parts | BAKIM | SP-7720 | Bearing 6205 | 1000 | 40 | PC | 6,800 | TRY | 11/04/2026 | 11/20/2026 | 13 |
| 0010004560 | 00010 | NB | 003 | Indirect Spend | IDARI | Office chair | 2000 | 12 | PC | 42,000 | TRY | 11/10/2026 | 12/15/2026 | 7 | |
| 0010004571 | 00030 | NB | 001 | Raw Material Buying | URETIM | RM-2040 | Steel sheet 2 mm | 2000 | 1,500 | KG | 91,800 | TRY | 10/12/2026 | 11/18/2026 | 36 |
How does the report work?
- EBAN is read with the selection criteria; deleted (LOEKZ) and closed (EBAKZ) items are skipped.
- 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.
- Open quantity = requested quantity (MENGE) − quantity ordered (BSMNG); items with zero open quantity are skipped.
- Open value = open quantity × valuation price (PREIS) ÷ price unit (PEINH).
- 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
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 …
Related reports
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 …
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 …
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.