PM Report Custom development ALV report

Maintenance Orders Waiting for Material with Purchase Tracking Report

Short answer: A custom ALV report that shows, for every component of open maintenance orders, stock status, purchase requisition, purchase order, vendor and delivery date on the same line, and flags orders whose material is complete as ready. Planners see which job waits for which part without opening each order.

Estimated effort
M · 4–6 working days
System
ECC and S/4HANA
Tables
10
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

The IW38 order list has no columns for component material status, purchase requisition or purchase order; planners open every order in IW33, go from the component screen to the requisition and from there to ME5A and ME23N. The material availability check covers stock items only and does not show the purchasing stage of non-stock items and services. When the weekly schedule is prepared, jobs whose material has arrived are picked out by hand.

Who uses it? Maintenance planners, maintenance buyers, spare parts warehouse leads and maintenance managers.

Closest standard alternatives

  • IW38 Change PM Orders (List). Lists maintenance orders; no columns for requisition, purchase order and delivery date per component.
  • ME5A Purchase Requisitions: List Display. Lists purchase requisitions; it does not show which maintenance job waits for the requisition or the order's start date.

Tables used

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

TableRoleJoinSystem
RESBReservation/Dependent RequirementsOrder components, item category, open quantity and purchase requisition (driving table)—ECC + S/4
AFIHMaintenance Order HeaderPlanning plant, planner group and equipmentAFIH-AUFNR = RESB-AUFNRECC + S/4
AUFKOrder Master DataOrder type and short textAUFK-AUFNR = RESB-AUFNRECC + S/4
AFKOOrder Header Data for PP OrdersBasic start dateAFKO-AUFNR = RESB-AUFNRECC + S/4
MARDStorage Location Data for MaterialUnrestricted stock of stock itemsMARD-MATNR = RESB-MATNR AND MARD-WERKS = RESB-WERKS AND MARD-LGORT = RESB-LGORTECC + S/4
EBANPurchase RequisitionPurchase requisition, release status and assigned orderEBAN-BANFN = RESB-BANFN AND EBAN-BNFPO = RESB-BNFPOECC + S/4
EKETPurchasing Schedule LinesDelivery date and received quantityEKET-EBELN = EBAN-EBELN AND EKET-EBELP = EBAN-EBELPECC + S/4
EKKOPurchasing Document HeaderVendor of the purchase orderEKKO-EBELN = EBAN-EBELNECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
MAKTMaterial DescriptionsMaterial description of stock itemsMAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

S/4HANA notes

  • MARD → MATDOC: In S/4HANA stock quantities are no longer stored physically; reading MARD returns values calculated on the fly from MATDOC through a compatibility view. Reads still work, but test performance on very large selections.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_IWERKMaintenance planning plantRange / multipleAFIH-IWERKYes1000
S_AUFNRMaintenance orderRange / multipleRESB-AUFNRNo4000131
S_INGPRPlanner groupRange / multipleAFIH-INGPRNoM01
S_AUARTOrder typeRange / multipleAUFK-AUARTNoPM02
S_GSTRPBasic start dateRange / multipleAFKO-GSTRPNo17.11.2026 – 31.12.2026
S_MATNRMaterialRange / multipleRESB-MATNRNoSP-7801
P_KEYDTKey date (default: today)Single valueSY-DATUMYes17.11.2026
P_NOTRDYOrders with incomplete material onlyCheckbox—NoX

Output columns

#ColumnSource
1Maintenance orderRESB-AUFNR
2Short textAUFK-KTEXT
3EquipmentAFIH-EQUNR
4Basic startAFKO-GSTRP
5MaterialRESB-MATNR
6Material / service textCalculated MAKT-MAKTX for stock items, EBAN-TXZ01 for non-stock items
7Item categoryRESB-POSTP
8Open qtyCalculated RESB-BDMNG − RESB-ENMNG
9UnitRESB-MEINS
10Purchase requisitionRESB-BANFN
11Purchase orderEBAN-EBELN
12VendorLFA1-NAME1
13Delivery dateEKET-EINDT
14Material statusCalculated In stock, requisition awaiting release, requisition released, on order or received
15Delay against start (days)Calculated EKET-EINDT − AFKO-GSTRP (positive: the job cannot start)

Sample output

Maintenance orderShort textEquipmentBasic startMaterialMaterial / service textItem categoryOpen qtyUnitPurchase requisitionPurchase orderVendorDelivery dateMaterial statusDelay against start (days)
4000131Compressor 2000-hour service1000007811/20/2026SP-7801Oil separator filterL2PC00100045124500012655Marmara Endüstriyel11/25/2026On order5
4000131Compressor 2000-hour service1000007811/20/2026Compressor overhaul serviceN1PC0010004519Requisition awaiting release
4000140Conveyor motor failure1000010211/12/2026SP-5520Geared motor 4 kWL1PC00100044984500012631Anadolu Elektromekanik11/14/2026Received, awaiting issue2
4000152Panel thermal camera check1000011011/24/2026Thermal camera calibration kitN1PC00100045334500012660Ege Teknik Servis12/02/2026On order8
A view built with fictional sample data; not real system data.

How does the report work?

  1. Open maintenance orders (AUTYP = 30; not TECO or CLSD) are read from AUFK and AFIH, the basic start (GSTRP) from AFKO. Components are taken from RESB (XLOEK blank, KZEAR blank); open quantity = BDMNG − ENMNG.
  2. Stock item (POSTP = L): compared with unrestricted stock MARD-LABST at the component’s plant and storage location; when enough, the status is in stock. When not enough and RESB-BANFN is filled, the requisition is followed.
  3. Non-stock item (POSTP = N) or item with a requisition: requisition (BANFN/BNFPO), release indicator (FRGKZ), deletion (LOEKZ) and assigned purchase order (EBELN/EBELP) are read from EBAN. Delivery date (EINDT) and received quantity (WEMNG) come from EKET; the vendor name is added through EKKO-LIFNR → LFA1-NAME1.
  4. Material status: in stock / requisition awaiting release / requisition released, no PO / on order / received, awaiting issue.
  5. Delay against start = EKET-EINDT − AFKO-GSTRP; a positive value means the order cannot start on the planned date. When all lines of an order are in stock or received, the order is flagged as ready.
  6. ALV groups by planner group and order; ready orders are shown in green.

Performance notes

Read RESB with FOR ALL ENTRIES on the order numbers; read EBAN and EKET only for lines with a requisition. The report can run in the background before the weekly scheduling meeting.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order opens IW33, the requisition ME53N and the purchase order ME23N.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Requisitions awaiting release and late deliveries can be sent to maintenance purchasing.

Authorization objects

  • I_IWERKDisplay orders by maintenance planning plant
  • M_BANF_WRKDisplay purchase requisitions by plant
  • M_BEST_WRKDisplay purchase orders by plant

Frequently asked questions

Are service items tracked as well?

Yes. Non-stock items and external services are followed through the purchase requisition on RESB. The service entry sheet status can be added as an optional column.

What if stock is already reserved for other orders?

By default, unrestricted stock is shared between orders in the order of their requirement dates, so two jobs that need the same spare part do not count the same stock twice.

Does it work on S/4HANA?

Yes. RESB, AFIH, EBAN and EKET keep the same structure in S/4HANA; reading MARD is served from material documents through a compatibility view.

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: Maintenance Orders Waiting for Material with Purchase Tracking Report