Planned Order Conversion Readiness and Component Availability Report
Short answer: A custom ALV report that ranks planned orders whose opening date has arrived by how much of their component demand today's stock covers. For each planned order the number of short components, the readiness percentage and the most critical component appear on the same line, so planners convert the fully ready orders first.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MD16 and CO41 list and convert planned orders collectively by MRP controller, but the list does not show whether stock covers the components. The availability check only runs after the production order exists, or separately for each planned order. Several planned orders that need the same component share the stock, and the standard lists do not show this sharing. As a result orders with missing material are converted too and then wait on the shop floor.
Who uses it? MRP controllers, production planners and shop floor supervisors who manage order creation before the shift.
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 |
|---|---|---|---|
| PLAFPlanned Order | Planned order: material, quantity, opening, start and finish date (driving table) | — | ECC + S/4 |
| RESBReservation/Dependent Requirements | Component requirements of the planned order | RESB-PLNUM = PLAF-PLNUM | ECC + S/4 |
| MARDStorage Location Data for Material | Unrestricted-use stock of the components | MARD-MATNR = RESB-MATNR AND MARD-WERKS = RESB-WERKS | ECC + S/4 |
| MARCPlant Data for Material | Production storage location and MRP controller | MARC-MATNR = PLAF-MATNR AND MARC-WERKS = PLAF-PLWRK | ECC + S/4 |
| MAKTMaterial Descriptions | Material and component descriptions | MAKT-MATNR = PLAF-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_PLWRK | Planning plant | Range / multiple | PLAF-PLWRK | Yes | 1000 |
| S_DISPO | MRP controller | Range / multiple | PLAF-DISPO | No | 001 |
| S_MATNR | Material | Range / multiple | PLAF-MATNR | No | FG-5003 |
| S_PAART | Planned order type | Range / multiple | PLAF-PAART | No | LA |
| S_PERTR | Opening date range | Range / multiple | PLAF-PERTR | Yes | 01.11.2026 – 24.11.2026 |
| P_ALLOC | Allocate stock by requirement date | Checkbox | — | No | X |
| P_LGPRO | Count only stock in the production storage location | Checkbox | — | No | — |
| P_READY | Only convertible orders | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Planned order | PLAF-PLNUM |
| 2 | Material | PLAF-MATNR |
| 3 | Description | MAKT-MAKTX |
| 4 | MRP controller | PLAF-DISPO |
| 5 | Quantity | PLAF-GSMNG |
| 6 | Unit | PLAF-MEINS |
| 7 | Opening date | PLAF-PERTR |
| 8 | Start date | PLAF-PSTTR |
| 9 | Finish date | PLAF-PEDTR |
| 10 | Firmed | PLAF-AUFFX |
| 11 | Components | Calculated Number of evaluated RESB items of the planned order |
| 12 | Short components | Calculated Number of items where allocated stock < (RESB-BDMNG − RESB-ENMNG) |
| 13 | Readiness % | Calculated (Components − short components) ÷ components × 100 |
| 14 | Critical component | RESB-MATNR |
| 15 | Status | Calculated Convertible, partial or waiting |
Sample output
| Planned order | Material | Description | MRP controller | Quantity | Unit | Opening date | Start date | Finish date | Firmed | Components | Short components | Readiness % | Critical component | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0000412870 | FG-5003 | Packed product C | 001 | 500 | PC | 11/17/2026 | 11/19/2026 | 11/21/2026 | X | 6 | 0 | 100 | Convertible | |
| 0000412874 | FG-6100 | Panel cabinet 80 cm | 001 | 120 | PC | 11/18/2026 | 11/20/2026 | 11/24/2026 | 9 | 2 | 78 | RM-3220 | Partial | |
| 0000412881 | FG-7200 | Compressor unit K2 | 002 | 40 | PC | 11/19/2026 | 11/23/2026 | 11/26/2026 | 4 | 4 | 0 | SA-4010 | Waiting |
How does the report work?
- In-house planned orders (BESKZ = ‘E’, PAART by selection) are read from PLAF by the plant, MRP controller and opening date range on the selection screen.
- The component requirements of the planned orders are read from RESB (PLNUM filled); deleted (XLOEK), bulk (SCHGT) and phantom (DUMPS) items are left out of the evaluation.
- Unrestricted stock of the components is read from MARD-LABST as the plant total or, by selection, per production storage location.
- With ‘allocate by date’ selected, requirements for the same component are sorted by requirement date (BDTER) and stock is consumed in that order; otherwise every planned order sees the full stock.
- Per planned order the number of components, the number of short components and the readiness percentage (covered components ÷ all components × 100) are calculated. The component with the lowest coverage is written as the critical component.
- Status: ‘Convertible’ when all components are covered, ‘Partial’ when some are short, ‘Waiting’ when none are covered. The list is sorted by status first, then by start date.
Performance notes
Narrow PLAF by plant and opening date. Read RESB once with the list of PLNUM values, and MARD with FOR ALL ENTRIES only for the components involved. The report is usually run in the background every morning before the shift and distributed by email.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The planned order opens MD13, the critical component opens MD04.
- Export to Excel
- Runs as a background job
- Send the result by email Each MRP controller can receive their own list of convertible orders every morning.
Authorization objects
- M_MTDI_ORGDisplay planned orders by plant and MRP controller
- C_AFKO_AWKOrder authorization for converting from the list
Frequently asked questions
Does the report convert orders?
No, the report only reads. 'Convertible' lines can be selected and passed to CO41, or converted with a separate background program; that extension is a separate effort item.
Is stock in quality inspection counted?
By default only unrestricted stock (MARD-LABST) is counted. Optionally, stock in quality inspection (MARD-INSME) can be shown in a separate 'available soon' column.
Are open purchase orders taken into account?
The base version only considers stock on hand. If required, open purchase order deliveries (EKET) due before the start date can be added as a second coverage source.
Related reports
Mass Production Order Release with Component Availability Check Program
A custom background program that automatically releases production orders whose scheduled start is approaching, when the share of components covered …
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.