PP Report Custom development ALV report

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

  • MD16 Collective Display of Planned Orders. Lists planned orders collectively; component availability and readiness are not shown.
  • CO41 Collective Conversion of Planned Orders. Converts planned orders collectively, but does not rank missing components before conversion.

Tables used

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

TableRoleJoinSystem
PLAFPlanned OrderPlanned order: material, quantity, opening, start and finish date (driving table)—ECC + S/4
RESBReservation/Dependent RequirementsComponent requirements of the planned orderRESB-PLNUM = PLAF-PLNUMECC + S/4
MARDStorage Location Data for MaterialUnrestricted-use stock of the componentsMARD-MATNR = RESB-MATNR AND MARD-WERKS = RESB-WERKSECC + S/4
MARCPlant Data for MaterialProduction storage location and MRP controllerMARC-MATNR = PLAF-MATNR AND MARC-WERKS = PLAF-PLWRKECC + S/4
MAKTMaterial DescriptionsMaterial and component descriptionsMAKT-MATNR = PLAF-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_PLWRKPlanning plantRange / multiplePLAF-PLWRKYes1000
S_DISPOMRP controllerRange / multiplePLAF-DISPONo001
S_MATNRMaterialRange / multiplePLAF-MATNRNoFG-5003
S_PAARTPlanned order typeRange / multiplePLAF-PAARTNoLA
S_PERTROpening date rangeRange / multiplePLAF-PERTRYes01.11.2026 – 24.11.2026
P_ALLOCAllocate stock by requirement dateCheckbox—NoX
P_LGPROCount only stock in the production storage locationCheckbox—No—
P_READYOnly convertible ordersCheckbox—No—

Output columns

#ColumnSource
1Planned orderPLAF-PLNUM
2MaterialPLAF-MATNR
3DescriptionMAKT-MAKTX
4MRP controllerPLAF-DISPO
5QuantityPLAF-GSMNG
6UnitPLAF-MEINS
7Opening datePLAF-PERTR
8Start datePLAF-PSTTR
9Finish datePLAF-PEDTR
10FirmedPLAF-AUFFX
11ComponentsCalculated Number of evaluated RESB items of the planned order
12Short componentsCalculated Number of items where allocated stock < (RESB-BDMNG − RESB-ENMNG)
13Readiness %Calculated (Components − short components) ÷ components × 100
14Critical componentRESB-MATNR
15StatusCalculated Convertible, partial or waiting

Sample output

Planned orderMaterialDescriptionMRP controllerQuantityUnitOpening dateStart dateFinish dateFirmedComponentsShort componentsReadiness %Critical componentStatus
0000412870FG-5003Packed product C001500PC11/17/202611/19/202611/21/2026X60100Convertible
0000412874FG-6100Panel cabinet 80 cm001120PC11/18/202611/20/202611/24/20269278RM-3220Partial
0000412881FG-7200Compressor unit K200240PC11/19/202611/23/202611/26/2026440SA-4010Waiting
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. Unrestricted stock of the components is read from MARD-LABST as the plant total or, by selection, per production storage location.
  4. 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.
  5. 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.
  6. 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

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: Planned Order Conversion Readiness and Component Availability Report