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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| AFIHMaintenance Order Header | Maintenance order header: planning plant, planner group, activity type, equipment (driving table) | — | ECC + S/4 |
| AUFKOrder Master Data | Order type, short text, object number | AUFK-AUFNR = AFIH-AUFNR | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Routing number of operations | AFKO-AUFNR = AFIH-AUFNR | ECC + S/4 |
| AFVCOperation within an Order | Operation: work center, text, confirmation number | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| AFVVQuantities, Dates and Values of Order Operations | Planned, actual and remaining work | AFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZL | ECC + S/4 |
| AFRUOrder Confirmations | Confirmations: count and technicians | AFRU-RUECK = AFVC-RUECK AND AFRU-STOKZ = ' ' | ECC + S/4 |
| CRHDWork Center Header | Work center of the operation | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBID | ECC + S/4 |
| JESTIndividual Object Status | TECO status | JEST-OBJNR = AUFK-OBJNR AND JEST-INACT = ' ' | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_IWERK | Planning plant | Range / multiple | AFIH-IWERK | Yes | 1000 |
| S_INGPR | Planner group | Range / multiple | AFIH-INGPR | No | M01 |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No | PM01, PM02 |
| S_ILART | Maintenance activity type | Range / multiple | AFIH-ILART | No | 002 |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No | MEKANIK |
| S_BUDAT | Confirmation date | Range / multiple | AFRU-BUDAT | Yes | 01.10.2026 – 31.10.2026 |
| P_TOL | Tolerance (%) | Single value | — | No | 20 |
| P_DONE | Only TECO orders | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Order | AUFK-AUFNR |
| 2 | Short text | AUFK-KTEXT |
| 3 | Order type | AUFK-AUART |
| 4 | Activity type | AFIH-ILART |
| 5 | Equipment | AFIH-EQUNR |
| 6 | Operation | AFVC-VORNR |
| 7 | Operation text | AFVC-LTXA1 |
| 8 | Work center | CRHD-ARBPL |
| 9 | Planned work | AFVV-ARBEI |
| 10 | Actual work | AFVV-ISMNW |
| 11 | Unit | AFVV-ARBEH |
| 12 | Remaining work | AFVV-OFMNW |
| 13 | Variance (hours) | Calculated ISMNW − ARBEI converted to hours |
| 14 | Variance (%) | Calculated Variance ÷ planned work × 100 |
| 15 | Confirmations | Calculated Number of valid AFRU records |
| 16 | Technicians | Calculated Number of distinct AFRU-PERNR |
Sample output
| Order | Short text | Order type | Activity type | Equipment | Operation | Operation text | Work center | Planned work | Actual work | Unit | Remaining work | Variance (hours) | Variance (%) | Confirmations | Technicians |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4001205 | P-101 seal replacement | PM01 | 001 | 10004512 | 0010 | Dismantle pump and replace seal | MEKANIK | 4 | 6.50 | H | 0 | 2.50 | 62.50 | 3 | 2 |
| 4001211 | K-02 periodic maintenance | PM02 | 002 | 10004530 | 0010 | Filter and oil change | MEKANIK | 2 | 1.80 | H | 0 | -0.20 | -10 | 1 | 1 |
| 4001211 | K-02 periodic maintenance | PM02 | 002 | 10004530 | 0020 | Motor connection check | ELEKTRIK | 1 | 1 | H | 0 | 0 | 0 | 1 | 1 |
| 4001230 | Conveyor motor failure | PM01 | 001 | 10004601 | 0010 | Motor replacement | ELEKTRIK | 180 | 300 | MIN | 0 | 2 | 66.70 | 2 | 2 |
How does the report work?
- 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.
- 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).
- 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.
- Different work units (minutes, days) are converted to hours; variance = actual − planned, variance percentage = variance ÷ planned × 100.
- The work center is read from CRHD-ARBPL; lines with an absolute variance percentage below the tolerance can be hidden.
- 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
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 …
Related reports
Overdue Maintenance Orders and Backlog by Work Center Report
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 …
Mass Time Confirmation Upload for Maintenance Orders Program
A custom program that reads technicians' working hours from mobile forms, timesheets or Excel and posts them in bulk as confirmations on maintenance …
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.