# Mass Breakdown Notification Creation from Shift Downtime File Program

> A custom program that reads the downtime list kept at the end of a shift, or a file from a production monitoring system, and creates a maintenance breakdown notification for every row with equipment, malfunction start and end time, damage and cause code. In test mode every row is checked and duplicates are filtered out.

- Type: Program, Custom development, Mass upload
- Module: PM
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/programs/mass-breakdown-notification-upload-program/


## Why is the standard not enough?

IW21 creates one notification at a time; on lines with dozens of short stops per shift, operators do not enter these records and the downtime stays only in Excel. As a result MTBF, MTTR and downtime analyses run on incomplete data. The standard has no mass entry that reads a downtime file and creates notifications with start/end time, damage and cause code.

### Closest standard alternatives

- IW21: Creates one notification at a time; there is no mass entry from a file and no duplicate check.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| QMEL | Notification header: type, short text, priority | Write | QMEL-QMNUM = yeni bildirim | ECC + S/4 |
| QMIH | Equipment, malfunction start/end and breakdown indicator; duplicate check | Write | QMIH-QMNUM = QMEL-QMNUM | ECC + S/4 |
| QMFE | Damage code group and code | Write | QMFE-QMNUM = QMEL-QMNUM | ECC + S/4 |
| QMUR | Cause code group and code | Write | QMUR-QMNUM = QMFE-QMNUM AND QMUR-FENUM = QMFE-FENUM | ECC + S/4 |
| EQUI | Existence check of the equipment | Read | EQUI-EQUNR = dosya ekipman | ECC + S/4 |
| EQUZ | Current location link of the equipment | Read | EQUZ-EQUNR = EQUI-EQUNR AND EQUZ-DATBI = '99991231' | ECC + S/4 |
| ILOA | Installation location when no functional location is given | Read | ILOA-ILOAN = EQUZ-ILOAN | ECC + S/4 |

## BAPIs and functions used

- BAPI_ALM_NOTIF_CREATE: Creates the breakdown notification with damage and cause for each row
- BAPI_ALM_NOTIF_SAVE: Saves the created notification and assigns the final number
- BAPI_TRANSACTION_COMMIT: Saves successful rows permanently
- BAPI_TRANSACTION_ROLLBACK: Rolls back in test mode and for failed rows

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_FILE | Downtime file (XLSX or CSV) | Single value | - | Yes |
| P_QMART | Default notification type | Single value | QMEL-QMART | No |
| P_MINDUR | Minimum downtime (minutes, shorter rows skipped) | Single value | - | No |
| P_TEST | Test mode (check without posting) | Checkbox | - | No |

## Input file columns

| Column | Target field | Required |
|---|---|---|
| Notification type | QMEL-QMART | No |
| Equipment | QMIH-EQUNR | Yes |
| Functional location | ILOA-TPLNR | No |
| Short text | QMEL-QMTXT | Yes |
| Malfunction start date | QMIH-AUSVN | Yes |
| Start time | QMIH-AUZTV | Yes |
| Malfunction end date | QMIH-AUSBS | No |
| End time | QMIH-AUZTB | No |
| Breakdown | QMIH-MSAUS | No |
| Damage code group | QMFE-FEGRP | No |
| Damage code | QMFE-FECOD | No |
| Cause code group | QMUR-URGRP | No |
| Cause code | QMUR-URCOD | No |
| Priority | QMEL-PRIOK | No |

## Result list columns

| Column | Source |
|---|---|
| Row | Calculated: Row number in the file |
| Equipment | QMIH-EQUNR |
| Functional location | ILOA-TPLNR |
| Short text | QMEL-QMTXT |
| Malfunction start | QMIH-AUSVN |
| Notification | QMEL-QMNUM |
| Downtime (minutes) | Calculated: (AUSBS + AUZTB) − (AUSVN + AUZTV) |
| Status | Calculated: Created, test passed, already exists, skipped or error |
| Message | Calculated: BAPI return message or check error |

## How does the program work?

1. The file (XLSX or CSV) is read from the user's PC or, in a background job, from a folder on the application server; the first row is skipped as the header.
2. For every row the notification type, equipment or functional location, start and end time are checked: the equipment must exist in EQUI; when no functional location is given, the equipment's installation location is taken through EQUZ and ILOA; the end cannot be before the start.
3. Duplicate check: when a notification with the same malfunction start date and time already exists on the same equipment in QMIH, the row is skipped as 'already exists', so loading the same file twice does not create duplicates.
4. The row is mapped to the BAPI_ALM_NOTIF_CREATE structures: equipment, functional location, short text, malfunction start/end and breakdown indicator in the header; damage code group and code in the item; cause code group and code in the cause table.
5. In test mode the BAPI is called and the change is rolled back. In a real run BAPI_ALM_NOTIF_SAVE and BAPI_TRANSACTION_COMMIT are called; the new notification number and the downtime are written on the row, and failed rows can be downloaded as a separate file.

## Authorization objects

- I_QMEL: Create maintenance notifications by notification type
- I_SWERK: Technical object authorization by maintenance plant

## Frequently asked questions

### What happens if the same file is loaded twice?

For every row the program looks for a notification with the same malfunction start date and time on the same equipment. When it finds one, it skips the row as 'already exists' and shows the existing notification number in the message.

### Can a maintenance order be created from the notification automatically?

The base version only creates notifications. If required, a step that creates an order from the notification for certain priorities or damage codes can be added; this extension is planned according to order type and work center rules.

### Can the file template be changed?

Yes. Column order and headers are adapted to the output of the production monitoring system; when code groups are missing from the file, defaults can be taken from the equipment's catalog profile.

---
Let us build this program for your system: https://nekuhub.com/en/request-a-quote/?report=pm-breakdown-notification-upload
