Failed IDocs Aging Report by Partner and Message Type
Short answer: A custom ALV report that lists inbound and outbound IDocs in an error status or waiting too long for processing, with partner, message type, last status message and age in hours, and counts the IDocs failing with the same error. In the morning the integration team sees on one screen which error is piling up at which partner and starts with the oldest IDoc.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 4
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
WE02/WE05 list IDocs by status and date and BD87 offers reprocessing; but neither calculates the age of an IDoc in hours, groups and counts IDocs with the same error message for the same partner and message type, or flags IDocs stuck in status 30 or 64 for too long. Emailing the error summary to the partner owner is not available either.
Who uses it? Integration and EDI teams, BASIS support and business units exchanging orders, invoices or delivery notes by IDoc.
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 |
|---|---|---|---|
| EDIDCIDoc Control Record | IDoc control record: status, direction, message type, partners, creation time (driving table) | — | ECC + S/4 |
| EDIDSIDoc Status Records | IDoc status records: last error message and date | EDIDS-DOCNUM = EDIDC-DOCNUM | ECC + S/4 |
| EDP21Partner Profile: Inbound | Inbound partner profile: process code | EDP21-SNDPRN = EDIDC-SNDPRN AND EDP21-SNDPRT = EDIDC-SNDPRT AND EDP21-MESTYP = EDIDC-MESTYP | ECC + S/4 |
| EDP13Partner Profile: Outbound (Technical Parameters) | Outbound partner profile: receiver port and basic type | EDP13-RCVPRN = EDIDC-RCVPRN AND EDP13-RCVPRT = EDIDC-RCVPRT AND EDP13-MESTYP = EDIDC-MESTYP | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_CREDT | Creation date | Range / multiple | EDIDC-CREDAT | Yes | 10.11.2026 – 17.11.2026 |
| S_STAT | IDoc status (blank = error list) | Range / multiple | EDIDC-STATUS | No | 51, 56, 02, 29 |
| S_MESTY | Message type | Range / multiple | EDIDC-MESTYP | No | ORDERS, INVOIC, DESADV |
| S_SNDPRN | Sender partner | Range / multiple | EDIDC-SNDPRN | No | — |
| S_RCVPRN | Receiver partner | Range / multiple | EDIDC-RCVPRN | No | — |
| P_STUCK | Add IDocs stuck in status 30 and 64 | Checkbox | — | No | X |
| P_MINAGE | Stuck threshold (hours) | Single value | — | No | 2 |
| P_SUMM | Show partner + message type + error summary | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | IDoc number | EDIDC-DOCNUM |
| 2 | Direction | EDIDC-DIRECT |
| 3 | Status | EDIDC-STATUS |
| 4 | Message type | EDIDC-MESTYP |
| 5 | Basic type | EDIDC-IDOCTP |
| 6 | Sender partner | EDIDC-SNDPRN |
| 7 | Receiver partner | EDIDC-RCVPRN |
| 8 | Created on | EDIDC-CREDAT |
| 9 | Created at | EDIDC-CRETIM |
| 10 | Last status date | EDIDS-LOGDAT |
| 11 | Message class | EDIDS-STAMID |
| 12 | Message number | EDIDS-STAMNO |
| 13 | Status text | EDIDS-STATXT |
| 14 | Age (hours) | Calculated Now − EDIDC-CREDAT/CRETIM |
| 15 | IDocs with same error | Calculated Number of IDocs in the same partner + message type + STAMID/STAMNO group |
Sample output
| IDoc number | Direction | Status | Message type | Basic type | Sender partner | Receiver partner | Created on | Created at | Last status date | Message class | Message number | Status text | Age (hours) | IDocs with same error |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0000000004812345 | 2 | 51 | ORDERS | ORDERS05 | EDI_ANADOLU | NKDCLNT100 | 11/15/2026 | 08:14:22 | 11/15/2026 | V1 | 382 | Material FG-5003 is not defined for the sales organization | 49 | 14 |
| 0000000004812402 | 2 | 51 | INVOIC | INVOIC02 | TEDARIK_DELTA | NKDCLNT100 | 11/16/2026 | 22:40:10 | 11/16/2026 | M8 | 321 | Invoice amount out of tolerance; item blocked | 11 | 3 |
| 0000000004812450 | 1 | 02 | DESADV | DELVRY07 | NKDCLNT100 | LOJ_MARMARA | 11/17/2026 | 01:05:00 | 11/17/2026 | E0 | 028 | Error passing to port; RFC destination not reachable | 8 | 27 |
| 0000000004812471 | 2 | 56 | DEBMAS | DEBMAS07 | CRM_SISTEM | NKDCLNT100 | 11/17/2026 | 06:30:45 | 11/17/2026 | E0 | 400 | Inbound partner profile not found | 3 | 1 |
How does the report work?
- IDocs in error statuses within the selected creation date range are read from EDIDC: outbound 02, 04, 05, 25, 26, 29; inbound 51, 56, 60, 61, 63, 65 (the list is configurable).
- Depending on the selection, stuck IDocs are added: status 30 (outbound, ready for dispatch) and 64 (inbound, ready to be processed) older than the hour threshold.
- The status record with the highest counter (COUNTR) of each IDoc is read from EDIDS: message class (STAMID), message number (STAMNO), first variable (STAPA1), status text and date.
- Age (hours) = now − CREDAT/CRETIM. The number of IDocs in the same partner + message type + STAMID/STAMNO group is calculated.
- The process code is added from EDP21 for inbound IDocs and the port from EDP13 for outbound IDocs; IDocs without a partner profile are flagged separately.
- In summary mode one row = partner + message type + error; in detail mode one row = IDoc. Double-clicking the IDoc number opens WE02, an action button opens BD87 for the selected IDocs.
Performance notes
Narrow EDIDC by status and creation date and use the index on the status field. Read EDIDS only for the selected IDocs with FOR ALL ENTRIES and pick the latest record in ABAP. Data segments (EDID4) are not read. On systems with heavy EDI traffic, limit the date range to 7 days.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the IDoc number opens WE02; selected IDocs are passed to BD87.
- Export to Excel
- Runs as a background job
- Send the result by email The error summary per partner is sent to the partner owner defined in the settings table.
Authorization objects
- S_IDOCMONIIDoc monitoring: display by message type and partner
- S_IDOCCTRLAccess to the IDoc control record and partner profiles
Frequently asked questions
Does the report reprocess IDocs automatically?
No, the report only lists and passes the selected IDocs to BD87. Reprocessing should be a deliberate decision, for example after master data has been corrected. If needed, a scheduled automatic retry for specific error messages can be added as a separate job.
Is the business data inside the IDoc shown?
The basic version reads only control and status records; order or invoice segments are not read. This keeps the report fast and only monitoring authorization is needed.
Can it be used on S/4HANA as well?
Yes. EDIDC, EDIDS and the partner profile tables are the same in S/4HANA. Even when integration comes through middleware (e.g. SAP Integration Suite), the report covers it as long as it is processed as an IDoc.
Packages that include this solution
Basis Daily System Check Pack
A five-component pack that turns the Basis team's morning check into one list: cancelled and long-running background jobs, scheduled jobs running …
Related reports
Cancelled and Long-Running Background Jobs Report
A custom ALV report that lists background jobs that were cancelled, are still running or finished far above their usual runtime, with the step …
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.