# Maintenance Order Planned vs Actual Work Hours Report

> 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.

- Type: Report, Custom development, ALV report
- Module: PM
- Estimated effort: S (3–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/maintenance-order-planned-vs-actual-work-hours-report/


## 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.

### Closest standard alternatives

- IW37N: Lists operations with planned and actual work; there is no variance percentage, unit conversion or tolerance filter.
- IW47: Lists confirmations; does not compare with planned work.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| AFIH | Maintenance order header: planning plant, planner group, activity type, equipment (driving table) | Read | - | ECC + S/4 |
| AUFK | Order type, short text, object number | Read | AUFK-AUFNR = AFIH-AUFNR | ECC + S/4 |
| AFKO | Routing number of operations | Read | AFKO-AUFNR = AFIH-AUFNR | ECC + S/4 |
| AFVC | Operation: work center, text, confirmation number | Read | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| AFVV | Planned, actual and remaining work | Read | AFVV-AUFPL = AFVC-AUFPL AND AFVV-APLZL = AFVC-APLZL | ECC + S/4 |
| AFRU | Confirmations: count and technicians | Read | AFRU-RUECK = AFVC-RUECK AND AFRU-STOKZ = ' ' | ECC + S/4 |
| CRHD | Work center of the operation | Read | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBID | ECC + S/4 |
| JEST | TECO status | Read | JEST-OBJNR = AUFK-OBJNR AND JEST-INACT = ' ' | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_IWERK | Planning plant | Range / multiple | AFIH-IWERK | Yes |
| S_INGPR | Planner group | Range / multiple | AFIH-INGPR | No |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No |
| S_ILART | Maintenance activity type | Range / multiple | AFIH-ILART | No |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No |
| S_BUDAT | Confirmation date | Range / multiple | AFRU-BUDAT | Yes |
| P_TOL | Tolerance (%) | Single value | - | No |
| P_DONE | Only TECO orders | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Order | AUFK-AUFNR |
| Short text | AUFK-KTEXT |
| Order type | AUFK-AUART |
| Activity type | AFIH-ILART |
| Equipment | AFIH-EQUNR |
| Operation | AFVC-VORNR |
| Operation text | AFVC-LTXA1 |
| Work center | CRHD-ARBPL |
| Planned work | AFVV-ARBEI |
| Actual work | AFVV-ISMNW |
| Unit | AFVV-ARBEH |
| Remaining work | AFVV-OFMNW |
| Variance (hours) | Calculated: ISMNW − ARBEI converted to hours |
| Variance (%) | Calculated: Variance ÷ planned work × 100 |
| Confirmations | Calculated: Number of valid AFRU records |
| Technicians | Calculated: Number of distinct AFRU-PERNR |

## 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.

## Authorization objects

- I_IWERK: Display maintenance orders by planning plant
- I_AUART: Maintenance 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=pm-planned-vs-actual-work-hours
