PS Report Custom development ALV report

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.

TableRoleJoinSystem
RESBReservation/Dependent RequirementsNetwork material component: requirement quantity, date, withdrawn quantity and requisition reference (driving table)—ECC + S/4
PRPSWBS Element Master DataWBS elementPRPS-PSPNR = RESB-PSPELECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
EBANPurchase RequisitionPurchase requisition: quantity, quantity ordered and release indicatorEBAN-BANFN = RESB-BANFN AND EBAN-BNFPO = RESB-BNFPOECC + S/4
EKPOPurchasing Document ItemPurchase order item created from the requisitionEKPO-BANFN = EBAN-BANFN AND EKPO-BNFPO = EBAN-BNFPOECC + S/4
EKETPurchasing Schedule LinesDelivery date and open quantityEKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELPECC + S/4
EKBEPurchasing Document HistoryGoods receipt quantityEKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELPECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26-0012-*
S_AUFNRNetworkRange / multipleRESB-AUFNRNo4000123
S_WERKSPlantRange / multipleRESB-WERKSYes1000
S_MATNRMaterialRange / multipleRESB-MATNRNoEQ-3300
S_BDTERRequirement dateRange / multipleRESB-BDTERNo01.11.2026 – 31.03.2027
P_OPENOpen components onlyCheckbox—NoX
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1WBS elementPRPS-POSID
2NetworkRESB-AUFNR
3ActivityRESB-VORNR
4MaterialRESB-MATNR
5DescriptionMAKT-MAKTX
6Requirement qtyRESB-BDMNG
7UnitRESB-MEINS
8Requirement dateRESB-BDTER
9Purchase requisitionRESB-BANFN
10Purchase orderEKPO-EBELN
11Delivery dateEKET-EINDT
12Received qtyCalculated Σ EKBE-MENGE (VGABE = 1, SHKZG = H negative)
13Withdrawn qtyRESB-ENMNG
14Delay (days)Calculated EKET-EINDT − RESB-BDTER; without an order, key date − RESB-BDTER
15StatusCalculated No PR / PR not released / no PO / PO open / received, not issued / completed

Sample output

WBS elementNetworkActivityMaterialDescriptionRequirement qtyUnitRequirement datePurchase requisitionPurchase orderDelivery dateReceived qtyWithdrawn qtyDelay (days)Status
P-26-0012-0240001240010EQ-3300Transformer 1600 kVA2PC12/01/20260010004602450001325501/10/20270040PO open
P-26-0012-0240001240020EQ-3410MV switchgear panel6PC12/15/202600100046030028No PO
P-26-0012-0340001310010RM-4410Copper cable 4 mm²3,000M11/10/20260010004588450001319011/05/20263,0001,200-5Received, not issued
P-26-0012-0340001310030EQ-5120Cable tray 300 mm400M12/20/202600-33No PR
A view built with fictional sample data; not real system data.

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.

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

PS Package Custom

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, …

5 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

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: Project Material Procurement Status Report (Component to Goods Receipt)