Project Material Procurement Status Report (Component to Goods Receipt)
Short answer: A custom ALV report that tracks network material components on one line through purchase requisition, purchase order, goods receipt and goods issue. It shows which project material has no requisition yet, whose order will be late, or which has arrived but has not been issued to the site.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
CN52 shows network components with requirement and withdrawn quantity, ME5A shows requisitions and ME2N shows orders separately. No standard list shows the chain from component to requisition, order and goods receipt on one line together with how late the order is against the requirement date. Project teams keep this tracking in Excel.
Who uses it? Project managers, project buyers and site managers.
Closest standard alternatives
- CN52 Overview: Components. Lists network components with requirement and withdrawn quantity; does not give the requisition, order and delay chain on the same line.
- ME5A Purchase Requisitions: List Display. Lists requisitions; does not combine them with the component requirement date and order status.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| RESBReservation/Dependent Requirements | Network material component: requirement quantity, date, withdrawn quantity and requisition reference (driving table) | — | ECC + S/4 |
| PRPSWBS Element Master Data | WBS element | PRPS-PSPNR = RESB-PSPEL | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| EBANPurchase Requisition | Purchase requisition: quantity, quantity ordered and release indicator | EBAN-BANFN = RESB-BANFN AND EBAN-BNFPO = RESB-BNFPO | ECC + S/4 |
| EKPOPurchasing Document Item | Purchase order item created from the requisition | EKPO-BANFN = EBAN-BANFN AND EKPO-BNFPO = EBAN-BNFPO | ECC + S/4 |
| EKETPurchasing Schedule Lines | Delivery date and open quantity | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| EKBEPurchasing Document History | Goods receipt quantity | EKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELP | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No | P-26-0012-* |
| S_AUFNR | Network | Range / multiple | RESB-AUFNR | No | 4000123 |
| S_WERKS | Plant | Range / multiple | RESB-WERKS | Yes | 1000 |
| S_MATNR | Material | Range / multiple | RESB-MATNR | No | EQ-3300 |
| S_BDTER | Requirement date | Range / multiple | RESB-BDTER | No | 01.11.2026 – 31.03.2027 |
| P_OPEN | Open components only | Checkbox | — | No | X |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | WBS element | PRPS-POSID |
| 2 | Network | RESB-AUFNR |
| 3 | Activity | RESB-VORNR |
| 4 | Material | RESB-MATNR |
| 5 | Description | MAKT-MAKTX |
| 6 | Requirement qty | RESB-BDMNG |
| 7 | Unit | RESB-MEINS |
| 8 | Requirement date | RESB-BDTER |
| 9 | Purchase requisition | RESB-BANFN |
| 10 | Purchase order | EKPO-EBELN |
| 11 | Delivery date | EKET-EINDT |
| 12 | Received qty | Calculated Σ EKBE-MENGE (VGABE = 1, SHKZG = H negative) |
| 13 | Withdrawn qty | RESB-ENMNG |
| 14 | Delay (days) | Calculated EKET-EINDT − RESB-BDTER; without an order, key date − RESB-BDTER |
| 15 | Status | Calculated No PR / PR not released / no PO / PO open / received, not issued / completed |
Sample output
| WBS element | Network | Activity | Material | Description | Requirement qty | Unit | Requirement date | Purchase requisition | Purchase order | Delivery date | Received qty | Withdrawn qty | Delay (days) | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-26-0012-02 | 4000124 | 0010 | EQ-3300 | Transformer 1600 kVA | 2 | PC | 12/01/2026 | 0010004602 | 4500013255 | 01/10/2027 | 0 | 0 | 40 | PO open |
| P-26-0012-02 | 4000124 | 0020 | EQ-3410 | MV switchgear panel | 6 | PC | 12/15/2026 | 0010004603 | 0 | 0 | 28 | No PO | ||
| P-26-0012-03 | 4000131 | 0010 | RM-4410 | Copper cable 4 mm² | 3,000 | M | 11/10/2026 | 0010004588 | 4500013190 | 11/05/2026 | 3,000 | 1,200 | -5 | Received, not issued |
| P-26-0012-03 | 4000131 | 0030 | EQ-5120 | Cable tray 300 mm | 400 | M | 12/20/2026 | 0 | 0 | -33 | No PR |
How does the report work?
- Network components are read from RESB by WBS element (PSPEL), network, plant and requirement date (BDTER); deleted components (XLOEK) are skipped. The WBS number is added from PRPS.
- The component’s purchase requisition is read from EBAN through RESB-BANFN / BNFPO: requested quantity, quantity ordered and release status.
- Order items for the requisition are found through EKPO-BANFN / BNFPO; the earliest open delivery date comes from EKET and the received quantity from EKBE (VGABE = 1).
- The withdrawn quantity is RESB-ENMNG. Delay = EKET-EINDT − RESB-BDTER (a positive value means the order arrives after the requirement).
- Status: no requisition / requisition not released / no order / order open / received, not issued / completed. With “open only” selected, completed lines are skipped.
Performance notes
Always read RESB with a WBS or network list, and fetch EBAN, EKPO, EKET and EKBE for the keys found with FOR ALL ENTRIES. For large projects run the report as a weekly background job and send it to the project buying team.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The requisition opens ME53N, the order ME23N and the network CN23.
- Export to Excel
- Runs as a background job
- Send the result by email Late components can be sent weekly to the project buying team.
Authorization objects
- C_AFKO_AWKNetwork authorization by plant and order type
- M_BANF_WRKRequisition display authorization by plant
- M_BEST_WRKPurchase order display authorization by plant
Frequently asked questions
What if the requisition was later converted to a different order by hand?
The order is found through the requisition reference (EKPO-BANFN / BNFPO). Orders created without a requisition reference can be matched with an extra rule through the WBS account assignment (EKKN-PS_PSP_PNR).
Does it work in scenarios with project stock (Q stock)?
Yes. Even when the component special stock indicator (RESB-SOBKZ) is Q, the requisition, order and issue chain is tracked in the same way.
Does this report work on S/4HANA?
Yes. RESB, EBAN, EKPO, EKET and EKBE keep the same structure in S/4HANA.
Packages that include this solution
Project Budget and Schedule Controlling Pack
A pack that combines five reports for the project review meeting with one project definition and WBS selection: budget vs actual vs commitment, …
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 …
Released Purchase Requisitions Not Yet Converted to Purchase Orders Report
A custom ALV report that lists released purchase requisition items not yet converted to a purchase order, with open quantity, open value and days …
WBS Budget vs Actual vs Commitment Report with Remaining Budget
A custom report that shows, for each WBS element, the current budget, plan, actual cost, requisition and order commitments, remaining budget and …
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.