PM Report Custom development ALV report

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

  • IW38 Change PM Orders (List). Lists maintenance orders; does not show the linked service entry sheets or their acceptance status.
  • ME23N Display Purchase Order. Shows the sheets in the purchase order history, but each order has to be opened separately.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
ESSRService Entry Sheet Header DataService entry sheet header: acceptance status, value, date (driving table)—ECC + S/4
EKKNAccount Assignment in Purchasing DocumentAccount assignment of the purchase order item: maintenance orderEKKN-EBELN = ESSR-EBELN AND EKKN-EBELP = ESSR-EBELPECC + S/4
AUFKOrder Master DataOrder type, short text and object numberAUFK-AUFNR = EKKN-AUFNRECC + S/4
AFIHMaintenance Order HeaderEquipment and maintenance planning plantAFIH-AUFNR = EKKN-AUFNRECC + S/4
EKKOPurchasing Document HeaderContractor (vendor) numberEKKO-EBELN = ESSR-EBELNECC + S/4
LFA1Vendor Master (General Section)Contractor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
JESTIndividual Object StatusTECO status of the maintenance orderJEST-OBJNR = AUFK-OBJNRECC + S/4
EQKTEquipment Short TextsEquipment descriptionEQKT-EQUNR = AFIH-EQUNR AND EQKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_IWERKMaintenance planning plantRange / multipleAFIH-IWERKYes1000
S_LIFNRContractorRange / multipleEKKO-LIFNRNo300120
S_AUFNRMaintenance orderRange / multipleEKKN-AUFNRNo4000123
S_ERDATSheet creation dateRange / multipleESSR-ERDATYes01.01.2026 – 17.11.2026
P_BUCKETAge buckets (days)Single value—No7,30,60
P_TECOOnly sheets whose order is TECOCheckbox—No—

Output columns

#ColumnSource
1Service entry sheetESSR-LBLNI
2Purchase orderESSR-EBELN
3ItemESSR-EBELP
4ContractorEKKO-LIFNR
5Contractor nameLFA1-NAME1
6Maintenance orderEKKN-AUFNR
7Order short textAUFK-KTEXT
8EquipmentAFIH-EQUNR
9Sheet short textESSR-TXZ01
10Service period endESSR-LZBIS
11Created onESSR-ERDAT
12Sheet valueESSR-LWERT
13CurrencyESSR-WAERS
14Days waitingCalculated Today − ESSR-ERDAT
15Age classCalculated By the selected age buckets
16Order TECOCalculated X when I0045 is active in JEST

Sample output

Service entry sheetPurchase orderItemContractorContractor nameMaintenance orderOrder short textEquipmentSheet short textService period endCreated onSheet valueCurrencyDays waitingAge classOrder TECO
1000004521450001312000010300120Anadolu Endüstriyel Bakım4000123Compressor K-12 overhaul10004512Overhaul labor October10/31/202611/03/202686,500TRY148–30 daysX
1000004538450001314400010300155Marmara Vinç Servis4000131Overhead crane periodic check10004801Periodic inspection service11/10/202611/12/202612,400TRY50–7 days
1000004410450001298700020300171Kuzey Elektrik Taahhüt4000098Panel maintenance line 210004630Electrical panel service09/15/202609/18/202631,200TRY6030+ daysX
A view built with fictional sample data; not real system data.

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.

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

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.

Related report: Unaccepted Service Entry Sheets for Maintenance Orders Aging Report