PP Report Custom development ALV report

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

  • COOIS Production Order Information System. Lists dates and received quantity; days late, remaining quantity and delivery percentage are not calculated.
  • COHV Mass Processing of Production Orders. Selects orders for mass processing; it is not designed for delay analysis.

Tables used

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

TableRoleJoinSystem
AUFKOrder Master DataOrder type, plant and object number (driving table)—ECC + S/4
AFKOOrder Header Data for PP OrdersPlanned start, basic finish, actual start and responsible personsAFKO-AUFNR = AUFK-AUFNRECC + S/4
AFPOOrder ItemHeader material, order quantity and quantity receivedAFPO-AUFNR = AUFK-AUFNRECC + S/4
JESTIndividual Object StatusActive system statuses (REL, TECO, DLV)JEST-OBJNR = AUFK-OBJNRECC + S/4
TJ02TSystem Status TextsSystem status textsTJ02T-ISTAT = JEST-STAT AND TJ02T-SPRAS = SY-LANGUECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = AFPO-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleAUFK-WERKSYes1000
S_AUARTOrder typeRange / multipleAUFK-AUARTNoPP01
S_DISPOMRP controllerRange / multipleAFKO-DISPONo001
S_FEVORProduction supervisorRange / multipleAFKO-FEVORNo101
S_MATNRMaterialRange / multipleAFPO-MATNRNoFG-5003
S_GLTRPBasic finish date rangeRange / multipleAFKO-GLTRPNo01.10.2026 – 16.11.2026
P_KEYDTKey date (default: today)Single valueSY-DATUMYes17.11.2026
P_MINDAYMinimum days lateSingle value—No1

Output columns

#ColumnSource
1Production orderAFKO-AUFNR
2Order typeAUFK-AUART
3MaterialAFPO-MATNR
4DescriptionMAKT-MAKTX
5SupervisorAFKO-FEVOR
6Planned startAFKO-GSTRP
7Basic finishAFKO-GLTRP
8Actual startAFKO-GSTRI
9Order qtyAFPO-PSMNG
10Received qtyAFPO-WEMNG
11Remaining qtyCalculated AFPO-PSMNG − AFPO-WEMNG
12UnitAFPO-MEINS
13Delivered %Calculated AFPO-WEMNG ÷ AFPO-PSMNG × 100
14System statusCalculated TJ02T texts of the active statuses in JEST
15Days lateCalculated Key date − AFKO-GLTRP

Sample output

Production orderOrder typeMaterialDescriptionSupervisorPlanned startBasic finishActual startOrder qtyReceived qtyRemaining qtyUnitDelivered %System statusDays late
1000431PP01FG-5003Packed product C10111/02/202611/06/202611/03/20262,0001,200800PC60Released, partially confirmed11
1000438PP01FG-6100Painted panel 120 cm10211/05/202611/10/202611/07/20265000500PC0Released, partially confirmed7
1000444PP02SF-2210Welded chassis10311/09/202611/12/20261500150PC0Released5
1000450PP01FG-5003Packed product C10111/12/202611/14/202611/12/20261,00095050PC95Released, partially delivered3
A view built with fictional sample data; not real system data.

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.

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

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

PP Report Custom ALV report

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 …

AFRU · AFVC · AFVV · CRHD

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: Overdue Production Orders and Remaining Quantity Report