PP Report Custom development ALV report

Production Order Missing Parts with Covering Purchase Order Report

Short answer: A custom ALV report that shows the missing components of production orders, the shortage quantity and the open purchase order that will cover it, with vendor and delivery date, on the same line. Planners see which order waits for which component, and for how many days, without switching to MD04.

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

Why is the standard not enough?

The CO24 missing parts info system and the COOIS component view list missing components, but they do not put the open purchase order that will cover the shortage, its vendor and its delivery date on the same line. Planners open MD04 for every component and look for the open order one by one. Stock is also not allocated by requirement date across several orders that need the same component, so every order seems able to use the whole stock. The custom report combines these three steps in one run.

Who uses it? Production planners, MRP controllers, buyers and production managers.

Closest standard alternatives

  • CO24 Missing Parts Information System. Lists missing components; the covering purchase order, vendor and delivery date are not on the same line.
  • MD04 Display Stock/Requirements Situation. Shows open orders per material, but it has to be opened separately for every component.

Tables used

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

TableRoleJoinSystem
RESBReservation/Dependent RequirementsOrder components, requirement date, required and withdrawn quantity (driving table)—ECC + S/4
AFKOOrder Header Data for PP OrdersHeader material, planned start, MRP controller and production supervisorAFKO-AUFNR = RESB-AUFNRECC + S/4
JESTIndividual Object StatusOrder system status; TECO and deleted orders are excludedJEST-OBJNR = 'OR' + RESB-AUFNRECC + S/4
MARDStorage Location Data for MaterialUnrestricted-use stock of the componentMARD-MATNR = RESB-MATNR AND MARD-WERKS = RESB-WERKSECC + S/4
EKPOPurchasing Document ItemOpen purchase order items for the same material and plantEKPO-MATNR = RESB-MATNR AND EKPO-WERKS = RESB-WERKSECC + S/4
EKETPurchasing Schedule LinesDelivery date, scheduled and received quantityEKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELPECC + S/4
EKKOPurchasing Document HeaderVendor of the purchase orderEKKO-EBELN = EKPO-EBELNECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
MAKTMaterial DescriptionsComponent description (logon language)MAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

S/4HANA notes

  • MARD → MATDOC: In S/4HANA stock quantities are no longer stored physically; reading MARD returns values calculated on the fly from MATDOC through a compatibility view. Reads still work, but test performance on very large selections.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleRESB-WERKSYes1000
S_AUFNRProduction orderRange / multipleRESB-AUFNRNo1000452
S_DISPOMRP controllerRange / multipleAFKO-DISPONo001
S_FEVORProduction supervisorRange / multipleAFKO-FEVORNo101
S_MATNRComponentRange / multipleRESB-MATNRNoRM-2040
S_BDTERRequirement date rangeRange / multipleRESB-BDTERYes17.11.2026 – 15.12.2026
P_LGORTCount stock only in the component's storage locationCheckbox—No—
P_ONLYSHMissing components onlyCheckbox—NoX

Output columns

#ColumnSource
1Production orderRESB-AUFNR
2Header materialAFKO-PLNBEZ
3Order startAFKO-GSTRP
4ComponentRESB-MATNR
5Component descriptionMAKT-MAKTX
6Requirement dateRESB-BDTER
7Open requirementCalculated RESB-BDMNG − RESB-ENMNG
8UnitRESB-MEINS
9Allocated stockCalculated From MARD-LABST, the quantity left for this line after earlier requirements
10ShortageCalculated Open requirement − allocated stock
11Covering purchase orderEKET-EBELN
12Vendor nameLFA1-NAME1
13Delivery dateEKET-EINDT
14Coverage gap (days)Calculated EKET-EINDT − RESB-BDTER (positive: the order waits)

Sample output

Production orderHeader materialOrder startComponentComponent descriptionRequirement dateOpen requirementUnitAllocated stockShortageCovering purchase orderVendor nameDelivery dateCoverage gap (days)
1000452FG-500311/18/2026RM-2040Steel sheet 2 mm11/18/2026400KG1502504500012398Delta Metal11/28/202610
1000467FG-610011/20/2026RM-3105Solvent-based paint11/20/202690L40504500012410Ege Kimya11/19/2026-1
1000471FG-610011/24/2026RM-3220Gasket set 12 pcs11/24/2026300PC0300No open order
1000478FG-500311/26/2026RM-2040Steel sheet 2 mm11/26/2026350KG03504500012398Delta Metal11/28/20262
A view built with fictional sample data; not real system data.

How does the report work?

  1. Production order reservations (AUFNR filled) are read from RESB with the plant and requirement date range on the selection screen; deleted items (XLOEK), items with final issue (KZEAR) and bulk materials (SCHGT) are skipped.
  2. Header material (PLNBEZ), planned start (GSTRP), MRP controller (DISPO) and production supervisor (FEVOR) are added from AFKO; orders with TECO (I0045) or the deletion flag (I0076) active in JEST are skipped.
  3. Open requirement = RESB-BDMNG − RESB-ENMNG.
  4. Available stock is read from MARD-LABST (plant total or, by selection, the component’s storage location). Requirements are sorted by requirement date (BDTER) and consumed from stock in turn, so orders that need the same component share the stock first come, first served. Shortage = open requirement − remaining stock (at least zero).
  5. For components with a shortage, open schedule lines of the same material and plant are read from EKPO and EKET (EKET-MENGE − EKET-WEMNG > 0; EKPO-LOEKZ and EKPO-ELIKZ blank) by delivery date. The first line that covers the shortage cumulatively becomes the covering order; the vendor name comes from LFA1 through EKKO-LIFNR.
  6. Coverage gap = EKET-EINDT − RESB-BDTER. A positive value shows how many days the order will wait for the component. Lines without a covering order are flagged separately.

Performance notes

Narrow RESB by plant and requirement date; make sure a suitable index exists on RESB-WERKS and RESB-BDTER. Read MARD and EKET once with FOR ALL ENTRIES, only for materials with a shortage. In large plants, run the report as a background job before the morning shift.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order number opens CO03, the purchase order opens ME23N.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Each MRP controller can receive their own shortage list every morning.

Authorization objects

  • C_AFKO_AWKDisplay production orders by plant and order type
  • M_BEST_WRKDisplay purchase orders by plant

Frequently asked questions

How is stock shared between several orders?

Reservations for the same component are sorted by requirement date and unrestricted stock is consumed in that order. The order that starts first gets the stock first, so the shortage of later orders is shown correctly.

Can purchase requisitions also be shown as covering documents?

Yes. Optionally, open purchase requisitions (EBAN) are evaluated as a second priority and the requisition number is shown in a separate column. This extension adds about one day to the effort range.

Does this report work on S/4HANA?

Yes. RESB, AFKO, EKPO and EKET keep the same structure in S/4HANA; reading MARD is served from material documents through a compatibility view. For a clean core approach, released CDS views for production order components can be used.

Packages that include this solution

PP Package Custom

Production Order Control Pack

A pack that combines four reports and one background program for the daily production meeting with one plant and MRP controller selection: overdue …

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: Production Order Missing Parts with Covering Purchase Order Report