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
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 | Order components, requirement date, required and withdrawn quantity (driving table) | — | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Header material, planned start, MRP controller and production supervisor | AFKO-AUFNR = RESB-AUFNR | ECC + S/4 |
| JESTIndividual Object Status | Order system status; TECO and deleted orders are excluded | JEST-OBJNR = 'OR' + RESB-AUFNR | ECC + S/4 |
| MARDStorage Location Data for Material | Unrestricted-use stock of the component | MARD-MATNR = RESB-MATNR AND MARD-WERKS = RESB-WERKS | ECC + S/4 |
| EKPOPurchasing Document Item | Open purchase order items for the same material and plant | EKPO-MATNR = RESB-MATNR AND EKPO-WERKS = RESB-WERKS | ECC + S/4 |
| EKETPurchasing Schedule Lines | Delivery date, scheduled and received quantity | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| EKKOPurchasing Document Header | Vendor of the purchase order | EKKO-EBELN = EKPO-EBELN | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| MAKTMaterial Descriptions | Component description (logon language) | MAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | RESB-WERKS | Yes | 1000 |
| S_AUFNR | Production order | Range / multiple | RESB-AUFNR | No | 1000452 |
| S_DISPO | MRP controller | Range / multiple | AFKO-DISPO | No | 001 |
| S_FEVOR | Production supervisor | Range / multiple | AFKO-FEVOR | No | 101 |
| S_MATNR | Component | Range / multiple | RESB-MATNR | No | RM-2040 |
| S_BDTER | Requirement date range | Range / multiple | RESB-BDTER | Yes | 17.11.2026 – 15.12.2026 |
| P_LGORT | Count stock only in the component's storage location | Checkbox | — | No | — |
| P_ONLYSH | Missing components only | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Production order | RESB-AUFNR |
| 2 | Header material | AFKO-PLNBEZ |
| 3 | Order start | AFKO-GSTRP |
| 4 | Component | RESB-MATNR |
| 5 | Component description | MAKT-MAKTX |
| 6 | Requirement date | RESB-BDTER |
| 7 | Open requirement | Calculated RESB-BDMNG − RESB-ENMNG |
| 8 | Unit | RESB-MEINS |
| 9 | Allocated stock | Calculated From MARD-LABST, the quantity left for this line after earlier requirements |
| 10 | Shortage | Calculated Open requirement − allocated stock |
| 11 | Covering purchase order | EKET-EBELN |
| 12 | Vendor name | LFA1-NAME1 |
| 13 | Delivery date | EKET-EINDT |
| 14 | Coverage gap (days) | Calculated EKET-EINDT − RESB-BDTER (positive: the order waits) |
Sample output
| Production order | Header material | Order start | Component | Component description | Requirement date | Open requirement | Unit | Allocated stock | Shortage | Covering purchase order | Vendor name | Delivery date | Coverage gap (days) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000452 | FG-5003 | 11/18/2026 | RM-2040 | Steel sheet 2 mm | 11/18/2026 | 400 | KG | 150 | 250 | 4500012398 | Delta Metal | 11/28/2026 | 10 |
| 1000467 | FG-6100 | 11/20/2026 | RM-3105 | Solvent-based paint | 11/20/2026 | 90 | L | 40 | 50 | 4500012410 | Ege Kimya | 11/19/2026 | -1 |
| 1000471 | FG-6100 | 11/24/2026 | RM-3220 | Gasket set 12 pcs | 11/24/2026 | 300 | PC | 0 | 300 | No open order | |||
| 1000478 | FG-5003 | 11/26/2026 | RM-2040 | Steel sheet 2 mm | 11/26/2026 | 350 | KG | 0 | 350 | 4500012398 | Delta Metal | 11/28/2026 | 2 |
How does the report work?
- 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.
- 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.
- Open requirement = RESB-BDMNG − RESB-ENMNG.
- 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).
- 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.
- 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
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 …
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 …
Overdue Production Orders and Remaining Quantity Report
A custom ALV report that lists production orders past their basic finish date that are not yet fully received, with days late, remaining quantity 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.