Spare Parts Consumption and Cost by Equipment Report
Short answer: A custom ALV report that totals goods issues to maintenance orders by equipment and functional location, showing which equipment consumes which spare part, how often and at what cost. Returns are netted off; the last issue date and the average interval between issues per part are calculated as well.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MB51 lists goods issues to maintenance orders with the order number, but it does not show the equipment or functional location the order belongs to; for part consumption by equipment the list is merged with the IW39 output in Excel. IW39 and order cost reports give total cost, not frequency or last issue date per part. This information is needed for minimum stock levels, critical spare decisions and repeat failure analysis.
Who uses it? Maintenance managers, spare parts and MRO storeroom owners, reliability engineers and controllers who follow the maintenance budget.
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 |
|---|---|---|---|
| MSEGMaterial Document Item | Goods issues and returns to maintenance orders (driving table) | — | ECC + S/4 |
| AUFKOrder Master Data | Order type and maintenance order check | AUFK-AUFNR = MSEG-AUFNR | ECC + S/4 |
| AFIHMaintenance Order Header | Equipment, location and maintenance activity type of the order | AFIH-AUFNR = MSEG-AUFNR | ECC + S/4 |
| ILOAPM Object Location and Account Assignment | Functional location | ILOA-ILOAN = AFIH-ILOAN | ECC + S/4 |
| EQKTEquipment Short Texts | Equipment description | EQKT-EQUNR = AFIH-EQUNR AND EQKT-SPRAS = SY-LANGU | ECC + S/4 |
| MAKTMaterial Descriptions | Spare part description | MAKT-MATNR = MSEG-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
S/4HANA notes
- MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MSEG-WERKS | Yes | 1000 |
| S_BUDAT | Posting date range | Range / multiple | MSEG-BUDAT_MKPF | Yes | 01.01.2026 – 31.10.2026 |
| S_EQUNR | Equipment | Range / multiple | AFIH-EQUNR | No | 10004512 |
| S_TPLNR | Functional location | Range / multiple | ILOA-TPLNR | No | TR01-URT-* |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No | PM01 |
| S_ILART | Maintenance activity type | Range / multiple | AFIH-ILART | No | 002 |
| S_MATNR | Spare part | Range / multiple | MSEG-MATNR | No | SP-1020 |
| P_TOPN | Top N parts per equipment (0 = all) | Single value | — | No | 10 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Equipment | AFIH-EQUNR |
| 2 | Equipment description | EQKT-EQKTX |
| 3 | Functional location | ILOA-TPLNR |
| 4 | Spare part | MSEG-MATNR |
| 5 | Part description | MAKT-MAKTX |
| 6 | Issues | Calculated Number of MSEG lines with movement type 261 |
| 7 | Net quantity | Calculated Σ MSEG-MENGE (261 positive, 262 negative) |
| 8 | Unit | MSEG-MEINS |
| 9 | Net value | Calculated Σ MSEG-DMBTR (261 positive, 262 negative) |
| 10 | Currency | MSEG-WAERS |
| 11 | Orders | Calculated Number of distinct MSEG-AUFNR values |
| 12 | Last issue | Calculated MAX(MSEG-BUDAT_MKPF) |
| 13 | Average interval (days) | Calculated (Last issue − first issue) ÷ (issues − 1) |
| 14 | Share of equipment % | Calculated Part net value ÷ total part value of the equipment × 100 |
Sample output
| Equipment | Equipment description | Functional location | Spare part | Part description | Issues | Net quantity | Unit | Net value | Currency | Orders | Last issue | Average interval (days) | Share of equipment % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10004512 | Compressor K-12 | TR01-URT-HAT1 | SP-1020 | Compressor valve kit | 5 | 5 | SET | 42,500 | TRY | 5 | 10/28/2026 | 59 | 46.20 |
| 10004512 | Compressor K-12 | TR01-URT-HAT1 | SP-1188 | Oil filter | 9 | 16 | PC | 7,360 | TRY | 8 | 11/04/2026 | 34 | 8 |
| 10004718 | Hydraulic press P-3 | TR01-PRS-01 | SP-2210 | Hydraulic seal kit | 4 | 3 | SET | 18,900 | TRY | 4 | 11/07/2026 | 72 | 61.50 |
| 10004630 | Conveyor belt B2 | TR01-URT-HAT2 | SP-3305 | Drive bearing 6208 | 6 | 12 | PC | 9,840 | TRY | 5 | 10/19/2026 | 48 | 37.80 |
How does the report work?
- Goods issues to maintenance orders (BWART 261) and their returns (262) are read from MSEG for the plant and posting date range on the selection screen; lines without an order number (AUFNR) are skipped.
- The order type is checked through AUFK and only maintenance orders are taken; equipment (EQUNR), location (ILOAN) and maintenance activity type (ILART) are added from AFIH, the functional location comes from ILOA.
- Quantity and value are netted using SHKZG: 261 issues count positive, 262 returns negative.
- Per equipment + material the number of issues, net quantity, net value (MSEG-DMBTR), number of distinct orders and the last issue date (BUDAT_MKPF) are summed. Average issue interval = (last issue − first issue) ÷ (number of issues − 1).
- Share within the equipment = part net value ÷ total part value of the equipment × 100. With ’top N parts’ selected, only the N highest-value parts are shown per equipment.
Performance notes
Read MSEG by movement type, plant and BUDAT_MKPF; make sure a suitable index exists for these fields. Read AFIH with FOR ALL ENTRIES only for the order numbers found. For a one-year analysis run the report in the background.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The equipment opens IE03, the part line opens the MB51 list of the related material documents.
- Export to Excel
- Runs as a background job
Authorization objects
- M_MSEG_WWADisplay material documents by plant
- I_SWERKTechnical object authorization by maintenance plant
Frequently asked questions
Are issues to a cost center without an order included?
The base version evaluates only issues to maintenance orders, because the equipment link comes from the order. Issues to cost centers (201) can be shown in a separate 'consumption without equipment' section.
Does it suggest stock levels?
The report gives consumption history; it does not suggest a minimum stock. Optionally the reorder point from MARC and the current stock can be shown side by side to flag parts that are low compared with consumption.
Does it work on S/4HANA?
Yes. In S/4HANA reading MSEG is served from the material document table through a compatibility view; for a clean core approach the material document CDS views can be used.
Related reports
Maintenance Cost and Downtime by Equipment Report
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 …
Repeat Breakdowns by Equipment Report
A custom ALV report that shows breakdown notifications repeating on the same equipment within a selected window of days, with the previous …
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.