Repeat Breakdowns by Equipment Report
Short answer: A custom ALV report that shows breakdown notifications repeating on the same equipment within a selected window of days, with the previous notification, the days in between, and the damage and cause codes on the same line. Repeats with the same cause are flagged, so equipment that needs a permanent fix is visible at a glance.
- 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?
IW29 lists notifications by equipment and date, but it does not cluster them per equipment and compare each with the previous one; the days between two breakdowns, the previous cause code and a 'repeat with the same cause' flag are missing. For reliability analysis the list is exported to Excel, sorted and compared with formulas. The existing MTBF report gives averages; this report shows the individual repeat events and their causes.
Who uses it? Maintenance planners, reliability engineers, maintenance managers and teams that run root cause analysis.
Closest standard alternatives
- IW29 Display Notifications (List). Lists notifications; does not cluster repeats on the same equipment or compare them with the previous cause code.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| QMELNotification Header | Notification header: type, date, short text, linked order (driving table) | — | ECC + S/4 |
| QMIHNotification Maintenance Data | Equipment, maintenance plant, malfunction start and downtime | QMIH-QMNUM = QMEL-QMNUM | ECC + S/4 |
| QMFENotification Items | Damage code and object part | QMFE-QMNUM = QMEL-QMNUM | ECC + S/4 |
| QMURNotification Causes | Cause code | QMUR-QMNUM = QMFE-QMNUM AND QMUR-FENUM = QMFE-FENUM | ECC + S/4 |
| ILOAPM Object Location and Account Assignment | Functional location | ILOA-ILOAN = QMIH-ILOAN | ECC + S/4 |
| EQKTEquipment Short Texts | Equipment description | EQKT-EQUNR = QMIH-EQUNR AND EQKT-SPRAS = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_IWERK | Maintenance planning plant | Range / multiple | QMIH-IWERK | Yes | 1000 |
| S_QMART | Notification type | Range / multiple | QMEL-QMART | No | M2 |
| S_EQUNR | Equipment | Range / multiple | QMIH-EQUNR | No | 10004512 |
| S_TPLNR | Functional location | Range / multiple | ILOA-TPLNR | No | TR01-URT-HAT1 |
| S_QMDAT | Notification date range | Range / multiple | QMEL-QMDAT | Yes | 01.01.2026 – 17.11.2026 |
| P_DAYS | Repeat window (days) | Single value | — | Yes | 90 |
| P_BRKDN | Breakdowns only | Checkbox | — | No | X |
| P_SAMEDM | Only repeats with the same damage code | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Equipment | QMIH-EQUNR |
| 2 | Equipment description | EQKT-EQKTX |
| 3 | Functional location | ILOA-TPLNR |
| 4 | Notification | QMEL-QMNUM |
| 5 | Malfunction start | QMIH-AUSVN |
| 6 | Short text | QMEL-QMTXT |
| 7 | Damage code | QMFE-FECOD |
| 8 | Cause code | QMUR-URCOD |
| 9 | Downtime (hours) | Calculated QMIH-AUSZT converted to hours from the QMIH-MAUEH unit |
| 10 | Previous notification | Calculated QMEL-QMNUM of the previous notification on the same equipment |
| 11 | Previous cause | Calculated QMUR-URCOD of the previous notification |
| 12 | Days since previous | Calculated QMIH-AUSVN − QMIH-AUSVN of the previous notification |
| 13 | Same cause | Calculated X when the cause code equals the previous one |
| 14 | Repeats in window | Calculated Number of notifications on the equipment flagged as repeats within the window |
Sample output
| Equipment | Equipment description | Functional location | Notification | Malfunction start | Short text | Damage code | Cause code | Downtime (hours) | Previous notification | Previous cause | Days since previous | Same cause | Repeats in window |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10004512 | Compressor K-12 | TR01-URT-HAT1 | 10027781 | 10/28/2026 | Compressor overheating | HT01 | NE03 | 6.50 | 10027215 | NE03 | 34 | X | 3 |
| 10004512 | Compressor K-12 | TR01-URT-HAT1 | 10028140 | 11/12/2026 | Compressor stopped again | HT01 | NE03 | 4 | 10027781 | NE03 | 15 | X | 3 |
| 10004630 | Conveyor belt B2 | TR01-URT-HAT2 | 10027902 | 11/03/2026 | Belt slipping | HT07 | NE11 | 1.50 | 10026877 | NE05 | 61 | 1 | |
| 10004718 | Hydraulic press P-3 | TR01-PRS-01 | 10028011 | 11/07/2026 | Hydraulic leak | HT04 | NE02 | 8 | 10027650 | NE02 | 22 | X | 2 |
How does the report work?
- Notifications with equipment are read from QMEL and QMIH by maintenance plant (IWERK), notification type and notification date range on the selection screen; with ‘breakdowns only’ selected, those with QMIH-MSAUS set are taken. To catch the first repeats at the start of the range, reading starts the window length before the range start.
- The first damage item (FEGRP, FECOD, OTEIL) is added from QMFE and the first cause (URGRP, URCOD) from QMUR; the functional location comes through ILOA.
- Notifications are sorted by equipment and malfunction start (AUSVN, AUZTV; QMDAT when blank). Each notification is compared with the previous one on the same equipment: when the days in between are within the window, the line is flagged as a repeat.
- When the cause code equals the previous one, a ‘same cause’ flag is set; with ‘same damage code only’ selected, repeats with a different damage code are removed.
- Downtime is converted to hours from QMIH-AUSZT and its unit MAUEH. Per equipment the number of repeats in the window and the total downtime are calculated; the list is sorted by repeat count, descending.
Performance notes
Narrow QMEL by notification date and type, QMIH by maintenance plant. Read QMFE and QMUR once with the list of notification numbers. Even for a year of history the report finishes within minutes; it can run in the background before the monthly reliability meeting.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The notification and the previous notification open IW23, the equipment opens IE03.
- Export to Excel
- Runs as a background job
- Send the result by email Equipment above a repeat threshold can be sent weekly to the reliability team.
Authorization objects
- I_QMELDisplay maintenance notifications by notification type
- I_SWERKTechnical object and notification authorization by maintenance plant
Frequently asked questions
How should the repeat window be chosen?
Most plants start with 30, 60 or 90 days. For critical equipment a shorter window highlights 'the repair did not hold' cases, a longer window highlights chronic failures. The window can be changed on the selection screen and saved in different variants.
Does it work by functional location as well?
Yes. For notifications without equipment but on a functional location, the functional location can be chosen as the clustering key; this option is within the base effort range.
Does it work on S/4HANA?
Yes. QMEL, QMIH, QMFE and QMUR keep the same structure in S/4HANA. The report runs without changes.
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 …
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 …
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.