PM Report Custom development ALV report

Maintenance Order Planned vs Actual Work Hours Report

Short answer: A custom ALV report that compares planned work with confirmed actual work on maintenance order operations and shows the variance in hours and percent by work center, maintenance activity type and equipment. The number of confirmations and technicians is on the same line, so the accuracy of planning estimates and task list durations is measured in one list.

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

Why is the standard not enough?

IW37N lists operations with planned and actual work and IW47 shows confirmations; but there is no variance percentage, no tolerance filter, no conversion of different work units to hours and no summary by work center or activity type. The number of technicians who confirmed is not visible on the operation line either. For a planning accuracy KPI, users combine the two lists in Excel. The custom report does this calculation.

Who uses it? Maintenance planners, maintenance managers, work center leads and reliability engineers who update task list durations.

Closest standard alternatives

  • IW37N Change Orders and Operations. Lists operations with planned and actual work; there is no variance percentage, unit conversion or tolerance filter.
  • IW47 Confirmation List. Lists confirmations; does not compare with planned work.

Tables used

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

TableRoleJoinSystem
AFIHMaintenance Order HeaderMaintenance order header: planning plant, planner group, activity type, equipment (driving table)—ECC + S/4
AUFKOrder Master DataOrder type, short text, object numberAUFK-AUFNR = AFIH-AUFNRECC + S/4
AFKOOrder Header Data for PP OrdersRouting number of operationsAFKO-AUFNR = AFIH-AUFNRECC + S/4
AFVCOperation within an OrderOperation: work center, text, confirmation numberAFVC-AUFPL = AFKO-AUFPLECC + S/4
AFVVQuantities, Dates and Values of Order OperationsPlanned, actual and remaining workAFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZLECC + S/4
AFRUOrder ConfirmationsConfirmations: count and techniciansAFRU-RUECK = AFVC-RUECK AND AFRU-STOKZ = ' 'ECC + S/4
CRHDWork Center HeaderWork center of the operationCRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBIDECC + S/4
JESTIndividual Object StatusTECO statusJEST-OBJNR = AUFK-OBJNR AND JEST-INACT = ' 'ECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_IWERKPlanning plantRange / multipleAFIH-IWERKYes1000
S_INGPRPlanner groupRange / multipleAFIH-INGPRNoM01
S_AUARTOrder typeRange / multipleAUFK-AUARTNoPM01, PM02
S_ILARTMaintenance activity typeRange / multipleAFIH-ILARTNo002
S_ARBPLWork centerRange / multipleCRHD-ARBPLNoMEKANIK
S_BUDATConfirmation dateRange / multipleAFRU-BUDATYes01.10.2026 – 31.10.2026
P_TOLTolerance (%)Single value—No20
P_DONEOnly TECO ordersCheckbox—NoX

Output columns

#ColumnSource
1OrderAUFK-AUFNR
2Short textAUFK-KTEXT
3Order typeAUFK-AUART
4Activity typeAFIH-ILART
5EquipmentAFIH-EQUNR
6OperationAFVC-VORNR
7Operation textAFVC-LTXA1
8Work centerCRHD-ARBPL
9Planned workAFVV-ARBEI
10Actual workAFVV-ISMNW
11UnitAFVV-ARBEH
12Remaining workAFVV-OFMNW
13Variance (hours)Calculated ISMNW − ARBEI converted to hours
14Variance (%)Calculated Variance ÷ planned work × 100
15ConfirmationsCalculated Number of valid AFRU records
16TechniciansCalculated Number of distinct AFRU-PERNR

Sample output

OrderShort textOrder typeActivity typeEquipmentOperationOperation textWork centerPlanned workActual workUnitRemaining workVariance (hours)Variance (%)ConfirmationsTechnicians
4001205P-101 seal replacementPM01001100045120010Dismantle pump and replace sealMEKANIK46.50H02.5062.5032
4001211K-02 periodic maintenancePM02002100045300010Filter and oil changeMEKANIK21.80H0-0.20-1011
4001211K-02 periodic maintenancePM02002100045300020Motor connection checkELEKTRIK11H00011
4001230Conveyor motor failurePM01001100046010010Motor replacementELEKTRIK180300MIN0266.7022
A view built with fictional sample data; not real system data.

How does the report work?

  1. Maintenance orders of the selected planning plant, planner group and activity type are read from AFIH, with order type, short text and object number from AUFK; with ‘only completed’ selected, orders with TECO (I0045) active in JEST are kept.
  2. Through AFKO-AUFPL the AFVC operations (work center, control key, text) are read, and AFVV gives planned work (ARBEI), actual work (ISMNW), remaining work (OFMNW) and the work unit (ARBEH).
  3. Non-reversed confirmations (STOKZ blank, STZHL = 0) within the confirmation date range are read from AFRU by the operation’s confirmation number; the number of confirmations and of distinct personnel numbers (PERNR) is counted.
  4. Different work units (minutes, days) are converted to hours; variance = actual − planned, variance percentage = variance ÷ planned × 100.
  5. The work center is read from CRHD-ARBPL; lines with an absolute variance percentage below the tolerance can be hidden.
  6. The list is per operation; ALV subtotals give the planning accuracy per work center, activity type and order type.

Performance notes

Fetch AFIH and AUFK with one joined read, and AFVC/AFVV with FOR ALL ENTRIES on the AUFPL list. Restrict the AFRU read by the confirmation date range. For yearly analyses, run the report in the background.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order opens IW33; the confirmation count opens the operation's confirmations in the IW47 list.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • I_IWERKDisplay maintenance orders by planning plant
  • I_AUARTMaintenance order authorization by order type

Frequently asked questions

Are external service operations included?

By default only internal labor operations (control key for internal processing) are evaluated. External service operations are excluded because they are tracked through service entry sheets; they can be listed with a separate option if needed.

Can the result be used to update task list durations?

Yes. The average actual work of operations from the same task list can be shown in a separate summary view; operations that deviate consistently are flagged as candidates for updating the planned work in the task list.

Does the report work on S/4HANA?

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

Packages that include this solution

PM Package Custom

Maintenance Notification-to-Confirmation Pack

A five-component pack that speeds up maintenance work from notification to confirmation: open notifications without an order, mass maintenance order …

5 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: Maintenance Order Planned vs Actual Work Hours Report