PM Report Custom development ALV report

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

  • IW39 Display PM Orders (List). Shows planned and actual cost per order; no combination of cost class and downtime per equipment.
  • KOB1 Orders: Actual Line Items. Lists actual cost line items of orders; it does not total by equipment.

Tables used

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

TableRoleJoinSystem
AFIHMaintenance Order HeaderMaintenance order, equipment and location (driving table)—ECC + S/4
AUFKOrder Master DataOrder type and cost object numberAUFK-AUFNR = AFIH-AUFNRECC + S/4
COEPCO Object: Line Items (by Period)Actual cost line items: cost element and amountCOEP-OBJNR = AUFK-OBJNRECC + S/4
QMIHNotification Maintenance DataBreakdown notifications and downtimeQMIH-EQUNR = AFIH-EQUNRECC + S/4
EQKTEquipment Short TextsEquipment descriptionEQKT-EQUNR = AFIH-EQUNR AND EQKT-SPRAS = SY-LANGUECC + S/4
ILOAPM Object Location and Account AssignmentFunctional location and cost centerILOA-ILOAN = AFIH-ILOANECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_IWERKMaintenance planning plantRange / multipleAFIH-IWERKYes1000
S_EQUNREquipmentRange / multipleAFIH-EQUNRNo10000045
S_TPLNRFunctional locationRange / multipleILOA-TPLNRNoTR01-URT-*
S_AUARTOrder typeRange / multipleAUFK-AUARTNoPM01
S_GJAHRFiscal yearRange / multipleCOEP-GJAHRYes2026
S_PERIOPeriodRange / multipleCOEP-PERIONo008 – 010
S_KSTLABLabor cost elementsRange / multipleCOEP-KSTARNo943000 – 943999
S_KSTMATMaterial cost elementsRange / multipleCOEP-KSTARNo620000 – 629999
S_KSTEXTExternal service cost elementsRange / multipleCOEP-KSTARNo632000 – 632999

Output columns

#ColumnSource
1EquipmentAFIH-EQUNR
2DescriptionEQKT-EQKTX
3Functional locationILOA-TPLNR
4OrdersCalculated Number of orders with cost in the period
5LaborCalculated Σ COEP-WKGBTR for labor cost elements
6MaterialCalculated Σ COEP-WKGBTR for material cost elements
7External servicesCalculated Σ COEP-WKGBTR for external service cost elements
8OtherCalculated Σ COEP-WKGBTR for the remaining cost elements (excluding settlement)
9Total costCalculated Labor + material + external services + other
10CurrencyCalculated Controlling area currency (currency of COEP-WKGBTR)
11BreakdownsCalculated Number of notifications with QMIH-MSAUS set
12Downtime (h)Calculated Σ QMIH-AUSZT, converted to hours
13Cost per downtime hourCalculated Total cost ÷ downtime (h)

Sample output

EquipmentDescriptionFunctional locationOrdersLaborMaterialExternal servicesOtherTotal costCurrencyBreakdownsDowntime (h)Cost per downtime hour
10000045Hydraulic press 400 tTR01-URT-PRS14186,400242,30095,00012,300536,000TRY638.5013,922
10000102Belt conveyor line 2TR01-URT-KNV971,50038,90022,0000132,400TRY414.509,131
10000078Screw compressor 75 kWTR01-YRD-KMP648,20061,80003,100113,100TRY2912,567
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. The cost element (KSTAR) is classified as labor, material, external services or other by the ranges on the selection screen.
  4. 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.
  5. 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

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

PM Report Custom ALV report

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 …

QMIH · QMEL · QMFE · QMUR

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 Cost and Downtime by Equipment Report