PM Report Custom development ALV report

Overdue Maintenance Orders and Backlog by Work Center Report

Short answer: A custom ALV report that lists open maintenance orders past their basic finish date with days late and remaining work hours, and calculates how many weeks of backlog each work center carries. The maintenance manager sees which team is behind and which high-priority job is waiting, on one screen.

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

Why is the standard not enough?

The IW38 and IW39 order lists show basic dates, but they do not calculate days late since the finish date, remaining work hours or how many weeks of backlog each work center carries. The IW37N operation list shows remaining work but not the delay or the ratio to capacity. The backlog indicator is usually built every week by merging two lists in Excel.

Who uses it? Maintenance managers, maintenance planners, team leads and site managers.

Closest standard alternatives

  • IW38 Change PM Orders (List). The order list has the dates; no days late, remaining work or backlog weeks.
  • IW37N Change Orders and Operations. Shows remaining work per operation; no delay and no ratio to capacity.

Tables used

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

TableRoleJoinSystem
AUFKOrder Master DataOrder type, short text and object number (driving table)—ECC + S/4
AFIHMaintenance Order HeaderPlanning plant, planner group, priority, equipment and main work centerAFIH-AUFNR = AUFK-AUFNRECC + S/4
AFKOOrder Header Data for PP OrdersBasic start and finish dates, routing numberAFKO-AUFNR = AUFK-AUFNRECC + S/4
AFVCOperation within an OrderOrder operationsAFVC-AUFPL = AFKO-AUFPLECC + S/4
AFVVQuantities, Dates and Values of Order OperationsPlanned and actual work hoursAFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZLECC + S/4
CRHDWork Center HeaderMain work center codeCRHD-OBJTY = 'A' AND CRHD-OBJID = AFIH-GEWRKECC + S/4
JESTIndividual Object StatusActive system statusesJEST-OBJNR = AUFK-OBJNRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_IWERKMaintenance planning plantRange / multipleAFIH-IWERKYes1000
S_INGPRPlanner groupRange / multipleAFIH-INGPRNoM01
S_ARBPLMain work centerRange / multipleCRHD-ARBPLNoMEK-01
S_AUARTOrder typeRange / multipleAUFK-AUARTNoPM01
S_PRIOKPriorityRange / multipleAFIH-PRIOKNo1
S_ILARTMaintenance activity typeRange / multipleAFIH-ILARTNo001
P_KEYDTKey date (default: today)Single valueSY-DATUMYes17.11.2026
P_WKHRSDefault weekly capacity (hours per work center)Single value—No40
P_OVERDUOverdue onlyCheckbox—NoX

Output columns

#ColumnSource
1Maintenance orderAUFK-AUFNR
2Order typeAUFK-AUART
3Short textAUFK-KTEXT
4EquipmentAFIH-EQUNR
5PriorityAFIH-PRIOK
6Main work centerCRHD-ARBPL
7Basic startAFKO-GSTRP
8Basic finishAFKO-GLTRP
9Days lateCalculated Key date − AFKO-GLTRP
10Planned work (h)Calculated Σ AFVV-ARBEI, converted to hours
11Actual work (h)Calculated Σ AFVV-ISMNW, converted to hours
12Remaining work (h)Calculated Planned work − actual work (at least 0)
13Work center backlog (weeks)Calculated Total remaining work of the work center ÷ weekly available hours
14System statusCalculated Texts of the active statuses in JEST

Sample output

Maintenance orderOrder typeShort textEquipmentPriorityMain work centerBasic startBasic finishDays latePlanned work (h)Actual work (h)Remaining work (h)Work center backlog (weeks)System status
4000123PM01Press hydraulic leak100000452MEK-0111/03/202611/05/202612166102.40Released, partially confirmed
4000131PM02Compressor 2000-hour service100000783MEK-0111/08/202611/10/20267240242.40Released
4000140PM01Conveyor motor failure100001021ELK-0111/12/202611/13/202648351.10Released, partially confirmed
4000152PM03Panel thermal camera check100001103ELK-0111/14/202611/15/202624041.10Released
A view built with fictional sample data; not real system data.

How does the report work?

  1. Maintenance orders (AUTYP = 30) are read from AUFK, and planning plant (IWERK), planner group (INGPR), priority (PRIOK), maintenance activity type (ILART), equipment and main work center (GEWRK) from AFIH. Orders with CRTD or REL and without active TECO (I0045), CLSD (I0046) or deletion flag (I0076) in JEST remain.
  2. Days late = key date − AFKO-GLTRP. With overdue only selected, only positive values remain.
  3. Operations are read from AFVC and AFVV through AFKO-AUFPL. Planned work AFVV-ARBEI, actual work AFVV-ISMNW; the unit AFVV-ARBEH is converted to hours. Remaining work = ARBEI − ISMNW, at least zero.
  4. The main work center code is found with AFIH-GEWRK = CRHD-OBJID. Backlog (weeks) = total remaining work of all open orders of the work center ÷ weekly available hours (from the work center capacity; the default on the selection screen when not defined).
  5. ALV shows subtotals per work center and priority; overdue priority 1 orders are highlighted.

Performance notes

Narrow AFIH by planning plant and planner group; read operations once with FOR ALL ENTRIES on AFKO-AUFPL. The report can run in the background before the morning meeting and be distributed by email.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the order number opens IW33.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Each planner group can receive its own overdue orders weekly.

Authorization objects

  • I_IWERKDisplay orders by maintenance planning plant
  • I_AUARTAuthorization by maintenance order type

Frequently asked questions

How should backlog weeks be read?

The value shows how many weeks the work center needs to finish its open work without taking new jobs. In maintenance management 2–4 weeks is usually seen as healthy; a very low value means idle capacity, a very high value means accumulated risk.

Can orders waiting for material be separated?

Yes. Orders waiting for material can be flagged in a separate column through a user status or an open reservation check; for detailed tracking, the Maintenance Orders Waiting for Material report is used.

Does it work on S/4HANA?

Yes. AUFK, AFIH, AFKO, AFVC and AFVV keep the same structure in S/4HANA. For a clean core approach, CDS views such as I_MaintOrderOperationData can be used.

Packages that include this solution

PM Package Custom

Maintenance KPI Pack

A pack that delivers the four core indicators of the monthly maintenance review with one plant, work center and equipment selection: maintenance …

4 components · v1.0

Related reports

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 Maintenance Orders and Backlog by Work Center Report