# Project Material Procurement Status Report (Component to Goods Receipt)

> 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.

- Type: Report, Custom development, ALV report
- Module: PS
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/project-material-procurement-status-report/


## 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.

### Closest standard alternatives

- CN52: Lists network components with requirement and withdrawn quantity; does not give the requisition, order and delay chain on the same line.
- ME5A: Lists requisitions; does not combine them with the component requirement date and order status.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| RESB | Network material component: requirement quantity, date, withdrawn quantity and requisition reference (driving table) | Read | - | ECC + S/4 |
| PRPS | WBS element | Read | PRPS-PSPNR = RESB-PSPEL | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| EBAN | Purchase requisition: quantity, quantity ordered and release indicator | Read | EBAN-BANFN = RESB-BANFN AND EBAN-BNFPO = RESB-BNFPO | ECC + S/4 |
| EKPO | Purchase order item created from the requisition | Read | EKPO-BANFN = EBAN-BANFN AND EKPO-BNFPO = EBAN-BNFPO | ECC + S/4 |
| EKET | Delivery date and open quantity | Read | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| EKBE | Goods receipt quantity | Read | EKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELP | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No |
| S_AUFNR | Network | Range / multiple | RESB-AUFNR | No |
| S_WERKS | Plant | Range / multiple | RESB-WERKS | Yes |
| S_MATNR | Material | Range / multiple | RESB-MATNR | No |
| S_BDTER | Requirement date | Range / multiple | RESB-BDTER | No |
| P_OPEN | Open components only | Checkbox | - | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |

## Output columns

| Column | Source |
|---|---|
| WBS element | PRPS-POSID |
| Network | RESB-AUFNR |
| Activity | RESB-VORNR |
| Material | RESB-MATNR |
| Description | MAKT-MAKTX |
| Requirement qty | RESB-BDMNG |
| Unit | RESB-MEINS |
| Requirement date | RESB-BDTER |
| Purchase requisition | RESB-BANFN |
| Purchase order | EKPO-EBELN |
| Delivery date | EKET-EINDT |
| Received qty | Calculated: Σ EKBE-MENGE (VGABE = 1, SHKZG = H negative) |
| Withdrawn qty | RESB-ENMNG |
| Delay (days) | Calculated: EKET-EINDT − RESB-BDTER; without an order, key date − RESB-BDTER |
| Status | Calculated: No PR / PR not released / no PO / PO open / received, not issued / completed |

## How does the report work?

1. 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.
2. The component's purchase requisition is read from EBAN through RESB-BANFN / BNFPO: requested quantity, quantity ordered and release status.
3. 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).
4. The withdrawn quantity is RESB-ENMNG. Delay = EKET-EINDT − RESB-BDTER (a positive value means the order arrives after the requirement).
5. Status: no requisition / requisition not released / no order / order open / received, not issued / completed. With "open only" selected, completed lines are skipped.

## Authorization objects

- C_AFKO_AWK: Network authorization by plant and order type
- M_BANF_WRK: Requisition display authorization by plant
- M_BEST_WRK: Purchase 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ps-project-material-procurement-status
