Overdue Production Orders and Remaining Quantity Report
Short answer: 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 delivery percentage. In the production meeting everyone sees which order is late, by how many days and how much is left, on one screen.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
The COOIS order header view has the basic finish date and the quantity received, but it does not calculate days late, remaining quantity or delivery percentage; to find late orders users set up date and status selections every time and process the result in Excel. Start delay (actual start versus planned start) is not visible either. The weekly list of late orders per production supervisor is usually built by hand.
Who uses it? Production planners, production supervisors, plant managers and customer service teams.
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 |
|---|---|---|---|
| AUFKOrder Master Data | Order type, plant and object number (driving table) | — | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Planned start, basic finish, actual start and responsible persons | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFPOOrder Item | Header material, order quantity and quantity received | AFPO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| JESTIndividual Object Status | Active system statuses (REL, TECO, DLV) | JEST-OBJNR = AUFK-OBJNR | ECC + S/4 |
| TJ02TSystem Status Texts | System status texts | TJ02T-ISTAT = JEST-STAT AND TJ02T-SPRAS = SY-LANGU | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = AFPO-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AUFK-WERKS | Yes | 1000 |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No | PP01 |
| S_DISPO | MRP controller | Range / multiple | AFKO-DISPO | No | 001 |
| S_FEVOR | Production supervisor | Range / multiple | AFKO-FEVOR | No | 101 |
| S_MATNR | Material | Range / multiple | AFPO-MATNR | No | FG-5003 |
| S_GLTRP | Basic finish date range | Range / multiple | AFKO-GLTRP | No | 01.10.2026 – 16.11.2026 |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_MINDAY | Minimum days late | Single value | — | No | 1 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Production order | AFKO-AUFNR |
| 2 | Order type | AUFK-AUART |
| 3 | Material | AFPO-MATNR |
| 4 | Description | MAKT-MAKTX |
| 5 | Supervisor | AFKO-FEVOR |
| 6 | Planned start | AFKO-GSTRP |
| 7 | Basic finish | AFKO-GLTRP |
| 8 | Actual start | AFKO-GSTRI |
| 9 | Order qty | AFPO-PSMNG |
| 10 | Received qty | AFPO-WEMNG |
| 11 | Remaining qty | Calculated AFPO-PSMNG − AFPO-WEMNG |
| 12 | Unit | AFPO-MEINS |
| 13 | Delivered % | Calculated AFPO-WEMNG ÷ AFPO-PSMNG × 100 |
| 14 | System status | Calculated TJ02T texts of the active statuses in JEST |
| 15 | Days late | Calculated Key date − AFKO-GLTRP |
Sample output
| Production order | Order type | Material | Description | Supervisor | Planned start | Basic finish | Actual start | Order qty | Received qty | Remaining qty | Unit | Delivered % | System status | Days late |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000431 | PP01 | FG-5003 | Packed product C | 101 | 11/02/2026 | 11/06/2026 | 11/03/2026 | 2,000 | 1,200 | 800 | PC | 60 | Released, partially confirmed | 11 |
| 1000438 | PP01 | FG-6100 | Painted panel 120 cm | 102 | 11/05/2026 | 11/10/2026 | 11/07/2026 | 500 | 0 | 500 | PC | 0 | Released, partially confirmed | 7 |
| 1000444 | PP02 | SF-2210 | Welded chassis | 103 | 11/09/2026 | 11/12/2026 | 150 | 0 | 150 | PC | 0 | Released | 5 | |
| 1000450 | PP01 | FG-5003 | Packed product C | 101 | 11/12/2026 | 11/14/2026 | 11/12/2026 | 1,000 | 950 | 50 | PC | 95 | Released, partially delivered | 3 |
How does the report work?
- Production orders (AUTYP = 10) of the selected plant are read from AUFK. Active statuses (INACT blank) in JEST are checked: REL (I0002) must be set; orders with TECO (I0045), DLV (I0012) or the deletion flag (I0076) are skipped. Status texts are read from TJ02T in the logon language.
- Planned start (GSTRP), basic finish (GLTRP) and actual start (GSTRI) come from AFKO; header material, item quantity (PSMNG), quantity received (WEMNG) and unit come from AFPO.
- Remaining quantity = PSMNG − WEMNG; delivery percentage = WEMNG ÷ PSMNG × 100. Items flagged as delivery completed (AFPO-ELIKZ) are skipped.
- Days late = key date − GLTRP. Orders below the minimum days late are skipped. Start delay = GSTRI − GSTRP; when the actual start is blank, key date − GSTRP is used.
- ALV shows subtotals per production supervisor (FEVOR); delays over 7 days are shown in red.
Performance notes
Narrow the AUFK selection by plant and order type and read JEST with FOR ALL ENTRIES only for the selected object numbers. The report usually runs in seconds; a nightly background job is enough for email distribution.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the order number opens CO03.
- Export to Excel
- Runs as a background job
- Send the result by email Each production supervisor can receive their own late orders weekly.
Authorization objects
- C_AFKO_AWKDisplay production orders by plant and order type
- C_AFKO_AWAProduction order authorization by order type
Frequently asked questions
Which date is the delay based on?
By default the basic finish date (AFKO-GLTRP) is used. A scheduled finish date (AFKO-GLTRS) option can be added; in companies that use detailed scheduling it gives a more realistic result.
Is the customer visible for make-to-order production?
Yes. The sales order and customer name can be added as columns through AFPO-KDAUF and KDPOS, so customer service sees deliveries at risk early.
Does it work on S/4HANA?
Yes. AUFK, AFKO, AFPO and JEST keep the same structure in S/4HANA. For a clean core approach, the I_ManufacturingOrder CDS view 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
Production Order Missing Parts with Covering Purchase Order Report
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 …
Scrap and Yield Analysis by Work Center Report
A custom ALV report that totals yield, scrap and rework from production confirmations per work center and operation, and compares the actual scrap …
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.