PP Report Custom development ALV report

Production Order Schedule Adherence Report (Planned vs Actual Start and Finish)

Short answer: A custom ALV report that compares the planned and actual start and finish dates of completed production orders and calculates the days of delay and the schedule adherence rate. The result is available per order or as a summary by MRP controller, production supervisor and order type.

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

Why is the standard not enough?

COOIS can show planned and actual dates as columns, but it does not calculate the days of delay, an on-time / early / late classification by tolerance or an adherence percentage. To get a KPI by MRP controller or production supervisor at summary level, the list is exported to Excel and formulas are built by hand. The existing overdue orders report looks at open orders; here the goal is to measure the past performance of finished orders.

Who uses it? Production managers, planning teams, and operational excellence or KPI reporting teams.

Closest standard alternatives

  • COOIS Production Order Information System. Lists planned and actual dates; does not calculate delay days, adherence class or a summary KPI.

Tables used

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

TableRoleJoinSystem
AFKOOrder Header Data for PP OrdersPlanned and actual start/finish dates, MRP controller and production supervisor (driving table)—ECC + S/4
AUFKOrder Master DataOrder type, plant and object numberAUFK-AUFNR = AFKO-AUFNRECC + S/4
AFPOOrder ItemMaterial, order and received quantity, last goods receipt dateAFPO-AUFNR = AFKO-AUFNRECC + S/4
JESTIndividual Object StatusDelivered, TECO and deletion statusJEST-OBJNR = AUFK-OBJNRECC + 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_GLTRPBasic finish date rangeRange / multipleAFKO-GLTRPYes01.10.2026 – 31.10.2026
P_TOLTolerance (days)Single value—No1
P_DLVPCTUnder-delivery threshold (%)Single value—No95
P_DETAILList per orderRadio button—NoX
P_SUMMSummary by MRP controller / supervisorRadio button—No—

Output columns

#ColumnSource
1Production orderAFKO-AUFNR
2Order typeAUFK-AUART
3MaterialAFPO-MATNR
4DescriptionMAKT-MAKTX
5MRP controllerAFKO-DISPO
6Production supervisorAFKO-FEVOR
7Planned startAFKO-GSTRP
8Actual startAFKO-GSTRI
9Start delay (days)Calculated AFKO-GSTRI − AFKO-GSTRP
10Planned finishAFKO-GLTRP
11Last goods receiptAFPO-LTRMI
12Finish delay (days)Calculated AFPO-LTRMI − AFKO-GLTRP
13Order quantityAFPO-PSMNG
14Received quantityAFPO-WEMNG
15Delivery rate %Calculated AFPO-WEMNG ÷ AFPO-PSMNG × 100
16Adherence classCalculated On time, early or late by tolerance; under-delivered when below the delivery threshold

Sample output

Production orderOrder typeMaterialDescriptionMRP controllerProduction supervisorPlanned startActual startStart delay (days)Planned finishLast goods receiptFinish delay (days)Order quantityReceived quantityDelivery rate %Adherence class
1000352PP01FG-5003Packed product C00110110/02/202610/02/2026010/06/202610/06/202601,0001,000100On time
1000361PP01FG-6100Panel cabinet 80 cm00110210/07/202610/09/2026210/13/202610/17/20264150150100Late
1000370PP02FG-7200Compressor unit K200220110/14/202610/13/2026-110/20/202610/19/2026-1605490Under-delivered
1000384PP01FG-5003Packed product C00110110/21/202610/21/2026010/24/202610/22/2026-2800800100Early
A view built with fictional sample data; not real system data.

How does the report work?

  1. Production orders are read from AUFK and AFKO by the plant, order type and basic finish date range on the selection screen; orders with delivery completed (AFPO-ELIKZ) or with delivered (I0012) or TECO (I0045) active in JEST are taken, deleted orders (I0076) are skipped.
  2. Start delay = AFKO-GSTRI − AFKO-GSTRP (days); finish delay = AFPO-LTRMI (last goods receipt date) − AFKO-GLTRP. When an actual date is blank the line is flagged as ‘date missing’.
  3. A finish delay within the tolerance days is classified as ‘on time’, below it as ’early’ and above it as ’late’.
  4. Delivery rate = AFPO-WEMNG ÷ AFPO-PSMNG × 100; when it is below the selected threshold the order is flagged as ‘under-delivered’ even if it finished on time.
  5. In the summary view, the number of orders, the on-time rate and the average delay are calculated for the selected grouping (MRP controller, production supervisor or order type).

Performance notes

Narrow AFKO by the basic finish date range and read the status check from JEST once with the order object numbers. For a monthly KPI the report can run in the background at month end and the summary view can be emailed.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order number opens CO03.
  • Export to Excel
  • Runs as a background job
  • Send the result by email The monthly summary can be sent automatically to production management.

Authorization objects

  • C_AFKO_AWKDisplay production orders by plant and order type

Frequently asked questions

Why is the last goods receipt date used for the finish?

From the customer's and the warehouse's point of view an order is finished when the product enters stock; that date is held in AFPO-LTRMI. If required, the last confirmation date (AFKO-GETRI) can be shown as a second finish measure in a separate column.

Which planned date is used for rescheduled orders?

The report uses the current basic dates of the order. If measurement against the order's first planned date is required, the original value can be read from change documents; this extension adds about one day.

Does this report work on S/4HANA?

Yes. AFKO, AFPO and AUFK keep the same structure in S/4HANA; the report runs without changes.

Related reports

PP Report Custom ALV report

Weekly Capacity Load by Work Center Report

A custom ALV report that shows, for every work center of the selected plant, the available capacity, the production order and planned order load and …

KBED · CRHD · CRCA · KAKO

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 Schedule Adherence Report (Planned vs Actual Start and Finish)