# 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 delivery percentage. In the production meeting everyone sees which order is late, by how many days and how much is left, on one screen.

- Type: Report, Custom development, ALV report
- Module: PP
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/overdue-production-orders-report/


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

### Closest standard alternatives

- COOIS: Lists dates and received quantity; days late, remaining quantity and delivery percentage are not calculated.
- COHV: Selects orders for mass processing; it is not designed for delay analysis.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| AUFK | Order type, plant and object number (driving table) | Read | - | ECC + S/4 |
| AFKO | Planned start, basic finish, actual start and responsible persons | Read | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFPO | Header material, order quantity and quantity received | Read | AFPO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| JEST | Active system statuses (REL, TECO, DLV) | Read | JEST-OBJNR = AUFK-OBJNR | ECC + S/4 |
| TJ02T | System status texts | Read | TJ02T-ISTAT = JEST-STAT AND TJ02T-SPRAS = SY-LANGU | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = AFPO-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AUFK-WERKS | Yes |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No |
| S_DISPO | MRP controller | Range / multiple | AFKO-DISPO | No |
| S_FEVOR | Production supervisor | Range / multiple | AFKO-FEVOR | No |
| S_MATNR | Material | Range / multiple | AFPO-MATNR | No |
| S_GLTRP | Basic finish date range | Range / multiple | AFKO-GLTRP | No |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes |
| P_MINDAY | Minimum days late | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Production order | AFKO-AUFNR |
| Order type | AUFK-AUART |
| Material | AFPO-MATNR |
| Description | MAKT-MAKTX |
| Supervisor | AFKO-FEVOR |
| Planned start | AFKO-GSTRP |
| Basic finish | AFKO-GLTRP |
| Actual start | AFKO-GSTRI |
| Order qty | AFPO-PSMNG |
| Received qty | AFPO-WEMNG |
| Remaining qty | Calculated: AFPO-PSMNG − AFPO-WEMNG |
| Unit | AFPO-MEINS |
| Delivered % | Calculated: AFPO-WEMNG ÷ AFPO-PSMNG × 100 |
| System status | Calculated: TJ02T texts of the active statuses in JEST |
| Days late | Calculated: Key date − AFKO-GLTRP |

## How does the report work?

1. 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.
2. 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.
3. Remaining quantity = PSMNG − WEMNG; delivery percentage = WEMNG ÷ PSMNG × 100. Items flagged as delivery completed (AFPO-ELIKZ) are skipped.
4. 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.
5. ALV shows subtotals per production supervisor (FEVOR); delays over 7 days are shown in red.

## Authorization objects

- C_AFKO_AWK: Display production orders by plant and order type
- C_AFKO_AWA: Production 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=pp-overdue-production-orders
