Unaccepted Service Entry Sheets for Maintenance Orders Aging Report
Short answer: A custom ALV report that lists service entry sheets entered but not yet accepted on external service purchase orders linked to maintenance orders, by contractor, maintenance order and equipment, with the number of days waiting. Lines whose order is already technically completed are flagged separately.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
Service entry sheets are opened and accepted one by one per purchase order; the standard purchasing lists do not show them together with the maintenance order and equipment, sorted by waiting time. IW38 does not show the external service sheets of the order either. Sheets waiting for acceptance delay the contractor's invoice and make the order cost look incomplete at month end.
Who uses it? Maintenance planners, maintenance supervisors who accept services, purchasing and invoice verification teams.
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 |
|---|---|---|---|
| ESSRService Entry Sheet Header Data | Service entry sheet header: acceptance status, value, date (driving table) | — | ECC + S/4 |
| EKKNAccount Assignment in Purchasing Document | Account assignment of the purchase order item: maintenance order | EKKN-EBELN = ESSR-EBELN AND EKKN-EBELP = ESSR-EBELP | ECC + S/4 |
| AUFKOrder Master Data | Order type, short text and object number | AUFK-AUFNR = EKKN-AUFNR | ECC + S/4 |
| AFIHMaintenance Order Header | Equipment and maintenance planning plant | AFIH-AUFNR = EKKN-AUFNR | ECC + S/4 |
| EKKOPurchasing Document Header | Contractor (vendor) number | EKKO-EBELN = ESSR-EBELN | ECC + S/4 |
| LFA1Vendor Master (General Section) | Contractor name | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| JESTIndividual Object Status | TECO status of the maintenance order | JEST-OBJNR = AUFK-OBJNR | ECC + S/4 |
| EQKTEquipment Short Texts | Equipment description | EQKT-EQUNR = AFIH-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 | AFIH-IWERK | Yes | 1000 |
| S_LIFNR | Contractor | Range / multiple | EKKO-LIFNR | No | 300120 |
| S_AUFNR | Maintenance order | Range / multiple | EKKN-AUFNR | No | 4000123 |
| S_ERDAT | Sheet creation date | Range / multiple | ESSR-ERDAT | Yes | 01.01.2026 – 17.11.2026 |
| P_BUCKET | Age buckets (days) | Single value | — | No | 7,30,60 |
| P_TECO | Only sheets whose order is TECO | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Service entry sheet | ESSR-LBLNI |
| 2 | Purchase order | ESSR-EBELN |
| 3 | Item | ESSR-EBELP |
| 4 | Contractor | EKKO-LIFNR |
| 5 | Contractor name | LFA1-NAME1 |
| 6 | Maintenance order | EKKN-AUFNR |
| 7 | Order short text | AUFK-KTEXT |
| 8 | Equipment | AFIH-EQUNR |
| 9 | Sheet short text | ESSR-TXZ01 |
| 10 | Service period end | ESSR-LZBIS |
| 11 | Created on | ESSR-ERDAT |
| 12 | Sheet value | ESSR-LWERT |
| 13 | Currency | ESSR-WAERS |
| 14 | Days waiting | Calculated Today − ESSR-ERDAT |
| 15 | Age class | Calculated By the selected age buckets |
| 16 | Order TECO | Calculated X when I0045 is active in JEST |
Sample output
| Service entry sheet | Purchase order | Item | Contractor | Contractor name | Maintenance order | Order short text | Equipment | Sheet short text | Service period end | Created on | Sheet value | Currency | Days waiting | Age class | Order TECO |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000004521 | 4500013120 | 00010 | 300120 | Anadolu Endüstriyel Bakım | 4000123 | Compressor K-12 overhaul | 10004512 | Overhaul labor October | 10/31/2026 | 11/03/2026 | 86,500 | TRY | 14 | 8–30 days | X |
| 1000004538 | 4500013144 | 00010 | 300155 | Marmara Vinç Servis | 4000131 | Overhead crane periodic check | 10004801 | Periodic inspection service | 11/10/2026 | 11/12/2026 | 12,400 | TRY | 5 | 0–7 days | |
| 1000004410 | 4500012987 | 00020 | 300171 | Kuzey Elektrik Taahhüt | 4000098 | Panel maintenance line 2 | 10004630 | Electrical panel service | 09/15/2026 | 09/18/2026 | 31,200 | TRY | 60 | 30+ days | X |
How does the report work?
- Service entry sheets with the acceptance indicator (KZABN) blank and no deletion flag (LOEKZ) are read from ESSR by the creation date range on the selection screen.
- The account assignment of the sheet’s purchase order item is read from EKKN; those with an order number (AUFNR) are taken. The order type and maintenance order check are done through AUFK.
- Equipment and maintenance planning plant come from AFIH, the equipment description from EQKT; contractor number and name come from EKKO and LFA1.
- Days waiting = today − ESSR-ERDAT. An age class is assigned by the selected age buckets (for example 0–7, 8–30, 30+ days).
- When TECO (I0045) is active in JEST for the maintenance order, the line is flagged as ‘order closed, waiting for acceptance’.
- The list is grouped by contractor; for each group the total sheet value (ESSR-LWERT) and the number of sheets are shown as subtotals.
Performance notes
Narrow ESSR by creation date and acceptance indicator; read EKKN only for the purchase order items found. Running it as a weekly background job and emailing each planner group its own list is the common use.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The service entry sheet opens ML81N, the maintenance order opens IW33.
- Export to Excel
- Runs as a background job
- Send the result by email Each maintenance planner group can receive its own sheets waiting for acceptance every week.
Authorization objects
- M_BEST_WRKDisplay purchase orders by plant
- I_IWERKDisplay maintenance orders by maintenance planning plant
Frequently asked questions
Can the report accept the sheets?
The base version only reads. If required, a mass acceptance button with an authorization check can be added for selected lines; this extension is planned separately depending on acceptance authorization and approval workflow.
How are purchase order items with multiple account assignment handled?
When an item is split across several maintenance orders, each EKKN line is shown separately, and the sheet value can be split by the distribution ratio in a separate column.
Does it work on S/4HANA?
Yes, on S/4HANA systems that use the classic service entry sheet (ESSR) it works the same way. On systems that use the new service entry app, reading is adapted to the related document tables.
Related reports
Maintenance Orders Waiting for Material with Purchase Tracking Report
A custom ALV report that shows, for every component of open maintenance orders, stock status, purchase requisition, purchase order, vendor and …
Overdue Maintenance Orders and Backlog by Work Center Report
A custom ALV report that lists open maintenance orders past their basic finish date with days late and remaining work hours, and calculates how many …
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.