Maintenance Cost and Downtime by Equipment Report
Short answer: A custom ALV report that splits the actual cost of maintenance orders per equipment in a period into labor, material, external services and other, and shows the number of breakdowns, downtime and cost per downtime hour on the same line. The most expensive equipment for replace-or-repair decisions appears in one list.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
IW39 and KOB1 give cost per order; they do not split the cost of several orders per equipment into labor, material and external services and show it on the same line as downtime. Maintenance information system reports depend on statistics updates and do not allow flexible cost element groups. Equipment cost is usually calculated by merging the order list and cost line items in Excel.
Who uses it? Maintenance managers, reliability engineers, plant controllers and managers who plan investments.
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, equipment and location (driving table) | — | ECC + S/4 |
| AUFKOrder Master Data | Order type and cost object number | AUFK-AUFNR = AFIH-AUFNR | ECC + S/4 |
| COEPCO Object: Line Items (by Period) | Actual cost line items: cost element and amount | COEP-OBJNR = AUFK-OBJNR | ECC + S/4 |
| QMIHNotification Maintenance Data | Breakdown notifications and downtime | QMIH-EQUNR = AFIH-EQUNR | ECC + S/4 |
| EQKTEquipment Short Texts | Equipment description | EQKT-EQUNR = AFIH-EQUNR AND EQKT-SPRAS = SY-LANGU | ECC + S/4 |
| ILOAPM Object Location and Account Assignment | Functional location and cost center | ILOA-ILOAN = AFIH-ILOAN | ECC + S/4 |
S/4HANA notes
- COEP → ACDOCA: In S/4HANA actual CO line items are stored in ACDOCA; reads on COEP go through the compatibility view V_COEP.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_IWERK | Maintenance planning plant | Range / multiple | AFIH-IWERK | Yes | 1000 |
| S_EQUNR | Equipment | Range / multiple | AFIH-EQUNR | No | 10000045 |
| S_TPLNR | Functional location | Range / multiple | ILOA-TPLNR | No | TR01-URT-* |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No | PM01 |
| S_GJAHR | Fiscal year | Range / multiple | COEP-GJAHR | Yes | 2026 |
| S_PERIO | Period | Range / multiple | COEP-PERIO | No | 008 – 010 |
| S_KSTLAB | Labor cost elements | Range / multiple | COEP-KSTAR | No | 943000 – 943999 |
| S_KSTMAT | Material cost elements | Range / multiple | COEP-KSTAR | No | 620000 – 629999 |
| S_KSTEXT | External service cost elements | Range / multiple | COEP-KSTAR | No | 632000 – 632999 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Equipment | AFIH-EQUNR |
| 2 | Description | EQKT-EQKTX |
| 3 | Functional location | ILOA-TPLNR |
| 4 | Orders | Calculated Number of orders with cost in the period |
| 5 | Labor | Calculated Σ COEP-WKGBTR for labor cost elements |
| 6 | Material | Calculated Σ COEP-WKGBTR for material cost elements |
| 7 | External services | Calculated Σ COEP-WKGBTR for external service cost elements |
| 8 | Other | Calculated Σ COEP-WKGBTR for the remaining cost elements (excluding settlement) |
| 9 | Total cost | Calculated Labor + material + external services + other |
| 10 | Currency | Calculated Controlling area currency (currency of COEP-WKGBTR) |
| 11 | Breakdowns | Calculated Number of notifications with QMIH-MSAUS set |
| 12 | Downtime (h) | Calculated Σ QMIH-AUSZT, converted to hours |
| 13 | Cost per downtime hour | Calculated Total cost ÷ downtime (h) |
Sample output
| Equipment | Description | Functional location | Orders | Labor | Material | External services | Other | Total cost | Currency | Breakdowns | Downtime (h) | Cost per downtime hour |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10000045 | Hydraulic press 400 t | TR01-URT-PRS | 14 | 186,400 | 242,300 | 95,000 | 12,300 | 536,000 | TRY | 6 | 38.50 | 13,922 |
| 10000102 | Belt conveyor line 2 | TR01-URT-KNV | 9 | 71,500 | 38,900 | 22,000 | 0 | 132,400 | TRY | 4 | 14.50 | 9,131 |
| 10000078 | Screw compressor 75 kW | TR01-YRD-KMP | 6 | 48,200 | 61,800 | 0 | 3,100 | 113,100 | TRY | 2 | 9 | 12,567 |
How does the report work?
- Maintenance orders and their equipment of the selected planning plant are read from AFIH, order type and object number (OBJNR) from AUFK. The functional location is added through AFIH-ILOAN → ILOA-TPLNR and the equipment description from EQKT.
- Actual cost line items of the orders are read from COEP: COEP-OBJNR = AUFK-OBJNR, value type WRTTP = 04 (actual), the selected fiscal year (GJAHR) and period (PERIO). The amount is WKGBTR (controlling area currency). Settlement lines (VRGNG = KOAO) are excluded from the total; otherwise the cost shows zero after settlement.
- The cost element (KSTAR) is classified as labor, material, external services or other by the ranges on the selection screen.
- Breakdowns and downtime: QMIH notifications with the same equipment, the breakdown flag (MSAUS) set and the malfunction start (AUSVN) in the period are counted; downtime AUSZT is converted to hours with unit MAUEH and totalled.
- Cost per downtime hour = total cost ÷ downtime hours. The list is sorted by total cost, highest first; double-clicking an equipment opens the breakdown by order.
Performance notes
COEP is a large table; read it only with the object numbers of the selected orders, controlling area, fiscal year and value type. Run full-year analyses in the background.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document An equipment line opens the cost breakdown by order, an order line opens IW33.
- Export to Excel
- Runs as a background job
Authorization objects
- I_IWERKDisplay orders by maintenance planning plant
- I_BEGRPDisplay equipment by technical object authorization group
Frequently asked questions
Is the cost of settled orders visible?
Yes. Settlement lines (business transaction KOAO) are excluded from the total, so the maintenance cost on the equipment stays visible even after the order is settled to a cost center or asset.
How are cost classes defined?
Cost element ranges for labor, material and external services are given on the selection screen and saved as a variant. CO cost element groups can be used instead if preferred.
Does it work on S/4HANA?
Yes. In S/4HANA actual cost line items are in ACDOCA and COEP can be read as a compatibility view; for a clean core approach ACDOCA or released CDS views can be used directly.
Packages that include this solution
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 …
Related reports
MTBF and MTTR Reliability Report by Equipment
A custom ALV report that calculates, from breakdown notifications, the number of breakdowns, total downtime, mean time to repair (MTTR), mean time …
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 …
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.