# Unaccepted Service Entry Sheets for Maintenance Orders Aging Report

> 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.

- Type: Report, Custom development, ALV report
- Module: PM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/unaccepted-service-entry-sheets-for-maintenance-orders-report/


## 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.

### Closest standard alternatives

- IW38: Lists maintenance orders; does not show the linked service entry sheets or their acceptance status.
- ME23N: Shows the sheets in the purchase order history, but each order has to be opened separately.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| ESSR | Service entry sheet header: acceptance status, value, date (driving table) | Read | - | ECC + S/4 |
| EKKN | Account assignment of the purchase order item: maintenance order | Read | EKKN-EBELN = ESSR-EBELN AND EKKN-EBELP = ESSR-EBELP | ECC + S/4 |
| AUFK | Order type, short text and object number | Read | AUFK-AUFNR = EKKN-AUFNR | ECC + S/4 |
| AFIH | Equipment and maintenance planning plant | Read | AFIH-AUFNR = EKKN-AUFNR | ECC + S/4 |
| EKKO | Contractor (vendor) number | Read | EKKO-EBELN = ESSR-EBELN | ECC + S/4 |
| LFA1 | Contractor name | Read | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| JEST | TECO status of the maintenance order | Read | JEST-OBJNR = AUFK-OBJNR | ECC + S/4 |
| EQKT | Equipment description | Read | EQKT-EQUNR = AFIH-EQUNR AND EQKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_IWERK | Maintenance planning plant | Range / multiple | AFIH-IWERK | Yes |
| S_LIFNR | Contractor | Range / multiple | EKKO-LIFNR | No |
| S_AUFNR | Maintenance order | Range / multiple | EKKN-AUFNR | No |
| S_ERDAT | Sheet creation date | Range / multiple | ESSR-ERDAT | Yes |
| P_BUCKET | Age buckets (days) | Single value | - | No |
| P_TECO | Only sheets whose order is TECO | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Service entry sheet | ESSR-LBLNI |
| Purchase order | ESSR-EBELN |
| Item | ESSR-EBELP |
| Contractor | EKKO-LIFNR |
| Contractor name | LFA1-NAME1 |
| Maintenance order | EKKN-AUFNR |
| Order short text | AUFK-KTEXT |
| Equipment | AFIH-EQUNR |
| Sheet short text | ESSR-TXZ01 |
| Service period end | ESSR-LZBIS |
| Created on | ESSR-ERDAT |
| Sheet value | ESSR-LWERT |
| Currency | ESSR-WAERS |
| Days waiting | Calculated: Today − ESSR-ERDAT |
| Age class | Calculated: By the selected age buckets |
| Order TECO | Calculated: X when I0045 is active in JEST |

## How does the report work?

1. 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.
2. 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.
3. Equipment and maintenance planning plant come from AFIH, the equipment description from EQKT; contractor number and name come from EKKO and LFA1.
4. Days waiting = today − ESSR-ERDAT. An age class is assigned by the selected age buckets (for example 0–7, 8–30, 30+ days).
5. When TECO (I0045) is active in JEST for the maintenance order, the line is flagged as 'order closed, waiting for acceptance'.
6. The list is grouped by contractor; for each group the total sheet value (ESSR-LWERT) and the number of sheets are shown as subtotals.

## Authorization objects

- M_BEST_WRK: Display purchase orders by plant
- I_IWERK: Display 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=pm-unaccepted-service-entry-sheets
