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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| RESBReservation/Dependent Requirements | Order components, item category, open quantity and purchase requisition (driving table) | — | ECC + S/4 |
| AFIHMaintenance Order Header | Planning plant, planner group and equipment | AFIH-AUFNR = RESB-AUFNR | ECC + S/4 |
| AUFKOrder Master Data | Order type and short text | AUFK-AUFNR = RESB-AUFNR | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Basic start date | AFKO-AUFNR = RESB-AUFNR | ECC + S/4 |
| MARDStorage Location Data for Material | Unrestricted stock of stock items | MARD-MATNR = RESB-MATNR AND MARD-WERKS = RESB-WERKS AND MARD-LGORT = RESB-LGORT | ECC + S/4 |
| EBANPurchase Requisition | Purchase requisition, release status and assigned order | EBAN-BANFN = RESB-BANFN AND EBAN-BNFPO = RESB-BNFPO | ECC + S/4 |
| EKETPurchasing Schedule Lines | Delivery date and received quantity | EKET-EBELN = EBAN-EBELN AND EKET-EBELP = EBAN-EBELP | ECC + S/4 |
| EKKOPurchasing Document Header | Vendor of the purchase order | EKKO-EBELN = EBAN-EBELN | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description of stock items | MAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_IWERK | Maintenance planning plant | Range / multiple | AFIH-IWERK | Yes | 1000 |
| S_AUFNR | Maintenance order | Range / multiple | RESB-AUFNR | No | 4000131 |
| S_INGPR | Planner group | Range / multiple | AFIH-INGPR | No | M01 |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No | PM02 |
| S_GSTRP | Basic start date | Range / multiple | AFKO-GSTRP | No | 17.11.2026 – 31.12.2026 |
| S_MATNR | Material | Range / multiple | RESB-MATNR | No | SP-7801 |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_NOTRDY | Orders with incomplete material only | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Maintenance order | RESB-AUFNR |
| 2 | Short text | AUFK-KTEXT |
| 3 | Equipment | AFIH-EQUNR |
| 4 | Basic start | AFKO-GSTRP |
| 5 | Material | RESB-MATNR |
| 6 | Material / service text | Calculated MAKT-MAKTX for stock items, EBAN-TXZ01 for non-stock items |
| 7 | Item category | RESB-POSTP |
| 8 | Open qty | Calculated RESB-BDMNG − RESB-ENMNG |
| 9 | Unit | RESB-MEINS |
| 10 | Purchase requisition | RESB-BANFN |
| 11 | Purchase order | EBAN-EBELN |
| 12 | Vendor | LFA1-NAME1 |
| 13 | Delivery date | EKET-EINDT |
| 14 | Material status | Calculated In stock, requisition awaiting release, requisition released, on order or received |
| 15 | Delay against start (days) | Calculated EKET-EINDT − AFKO-GSTRP (positive: the job cannot start) |
Sample output
| Maintenance order | Short text | Equipment | Basic start | Material | Material / service text | Item category | Open qty | Unit | Purchase requisition | Purchase order | Vendor | Delivery date | Material status | Delay against start (days) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4000131 | Compressor 2000-hour service | 10000078 | 11/20/2026 | SP-7801 | Oil separator filter | L | 2 | PC | 0010004512 | 4500012655 | Marmara Endüstriyel | 11/25/2026 | On order | 5 |
| 4000131 | Compressor 2000-hour service | 10000078 | 11/20/2026 | Compressor overhaul service | N | 1 | PC | 0010004519 | Requisition awaiting release | |||||
| 4000140 | Conveyor motor failure | 10000102 | 11/12/2026 | SP-5520 | Geared motor 4 kW | L | 1 | PC | 0010004498 | 4500012631 | Anadolu Elektromekanik | 11/14/2026 | Received, awaiting issue | 2 |
| 4000152 | Panel thermal camera check | 10000110 | 11/24/2026 | Thermal camera calibration kit | N | 1 | PC | 0010004533 | 4500012660 | Ege Teknik Servis | 12/02/2026 | On order | 8 |
How does the report work?
- 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.
- 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.
- 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.
- Material status: in stock / requisition awaiting release / requisition released, no PO / on order / received, awaiting issue.
- 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.
- 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
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 …
Production Order Missing Parts with Covering Purchase Order Report
A custom ALV report that shows the missing components of production orders, the shortage quantity and the open purchase order that will cover it, with …
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.