PP Report Custom development ALV report

Production Order Component Consumption Variance Report (Planned vs Actual Issue)

Short answer: A custom ALV report that compares, for completed production orders, the consumption each component should have for the delivered quantity with the quantity actually withdrawn, and shows over- and under-issue as quantity, percentage and value. Components outside the tolerance appear in one list by order, material and operation.

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

Why is the standard not enough?

The COOIS component list has requirement and withdrawn quantities, but the requirement refers to the order quantity; for an order delivered short, the target consumption for the delivered quantity is not calculated, and there is no variance value or tolerance filter. Production order cost variance analysis shows the difference by cost element and value; it does not list across a plant which component was over-issued by how many units in which operation. The custom report scales the target consumption to the delivered quantity and evaluates the quantity variance.

Who uses it? Production planners, production supervisors, cost accounting and scrap/efficiency improvement teams.

Closest standard alternatives

  • COOIS Production Order Information System. Lists component requirement and withdrawn quantities; does not calculate target consumption for the delivered quantity or a variance value.
  • MB51 Material Document List. Shows the 261 movements posted to the order; there is no comparison with the plan.

Tables used

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

TableRoleJoinSystem
RESBReservation/Dependent RequirementsOrder components: requirement and withdrawn quantity (driving table)—ECC + S/4
AUFKOrder Master DataOrder type, plant, object numberAUFK-AUFNR = RESB-AUFNRECC + S/4
JESTIndividual Object StatusDLV and TECO statusJEST-OBJNR = AUFK-OBJNR AND JEST-INACT = ' 'ECC + S/4
AFKOOrder Header Data for PP OrdersActual finish date and MRP controllerAFKO-AUFNR = AUFK-AUFNRECC + S/4
AFPOOrder ItemHeader material, order and delivered quantityAFPO-AUFNR = AUFK-AUFNRECC + S/4
MBEWMaterial ValuationStandard or moving average price for the variance valueMBEW-MATNR = RESB-MATNR AND MBEW-BWKEY = RESB-WERKSECC + S/4
MAKTMaterial DescriptionsComponent descriptionMAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

S/4HANA notes

  • MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleAUFK-WERKSYes1000
S_AUFNROrderRange / multipleAUFK-AUFNRNo—
S_AUARTOrder typeRange / multipleAUFK-AUARTNoPP01
S_DISPOMRP controllerRange / multipleAFKO-DISPONo001
S_GLTRIActual finish dateRange / multipleAFKO-GLTRIYes01.10.2026 – 31.10.2026
S_MATNRComponentRange / multipleRESB-MATNRNoRM-*
P_TOLTolerance (%)Single value—Yes3
P_DONEOnly DLV or TECO ordersCheckbox—NoX

Output columns

#ColumnSource
1OrderAUFK-AUFNR
2Header materialAFPO-MATNR
3Order quantityAFPO-PSMNG
4DeliveredAFPO-WEMNG
5ComponentRESB-MATNR
6Component descriptionMAKT-MAKTX
7OperationRESB-VORNR
8Requirement quantityRESB-BDMNG
9Target consumptionCalculated BDMNG × WEMNG ÷ PSMNG
10Withdrawn quantityRESB-ENMNG
11UnitRESB-MEINS
12Variance quantityCalculated ENMNG − target consumption
13Variance (%)Calculated Variance ÷ target consumption × 100
14Variance valueCalculated Variance × (STPRS or VERPR) ÷ PEINH
15BackflushRESB-RGEKZ

Sample output

OrderHeader materialOrder quantityDeliveredComponentComponent descriptionOperationRequirement quantityTarget consumptionWithdrawn quantityUnitVariance quantityVariance (%)Variance valueBackflush
1000388FG-50031,2001,150RM-2040Steel sheet 2 mm00102,1602,0702,235KG16587,425X
1000388FG-50031,2001,150PK-1010Carton box 60x4000401,2001,1501,112PC-38-3.30-193.80X
1000402FG-6100150150RM-3220Gasket set 12 pcs0030150150162PC1281,416
1000419SA-3100400380RM-2105Grey primer paint00209691.2098.50L7.3081,022X
A view built with fictional sample data; not real system data.

How does the report work?

  1. Production orders of the selected plants and order types are read from AUFK; with ‘only completed’ selected, orders with DLV (I0012) or TECO (I0045) active in JEST are kept.
  2. AFKO gives the actual finish date (GLTRI) and MRP controller, AFPO the order quantity (PSMNG) and delivered quantity (WEMNG).
  3. Stock item components of the order (POSTP = ‘L’, XLOEK blank) are read from RESB with the requirement quantity (BDMNG), withdrawn quantity (ENMNG), operation (VORNR) and backflush indicator (RGEKZ).
  4. Target consumption = BDMNG × WEMNG ÷ PSMNG; variance = ENMNG − target, variance percentage = variance ÷ target × 100.
  5. The variance value uses the price in MBEW for the plant valuation area: STPRS when VPRSV = ‘S’, otherwise VERPR, divided by the price unit PEINH.
  6. Lines with an absolute variance percentage below the tolerance are hidden; the list is per order and component, with subtotals per material.

Performance notes

Fetch RESB with one FOR ALL ENTRIES read on the order number list (RESB-AUFNR). Limit the date range by the actual finish date; for monthly analysis, run the report in the background after the period close. Read MBEW prices once with the material list.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The order opens CO03; the withdrawn quantity opens the MB51 component movements of the order.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • C_AFKO_AWKDisplay production orders by plant and order type
  • M_MATE_WRKPlant-level material data for the component price

Frequently asked questions

How does this report differ from cost variance analysis?

Cost variance analysis gives the difference by value and cost element at order level. This report is quantity-focused: it shows which component was over- or under-issued by how many units in which operation, and makes it easy to find components with wrong backflush settings.

Is component scrap included in the target?

RESB-BDMNG already includes the component and operation scrap from the BOM, so the target consumption covers the planned scrap. If needed, a net target without scrap can be shown as a separate column.

How are co-products and by-products handled?

RESB lines with negative requirements (by-products, co-products) are excluded by default. If needed, they can be listed with a separate option as a variance on the receipt side.

Related reports

PP Report Custom ALV report

Scrap and Yield Analysis by Work Center Report

A custom ALV report that totals yield, scrap and rework from production confirmations per work center and operation, and compares the actual scrap …

AFRU · AFVC · AFVV · CRHD

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: Production Order Component Consumption Variance Report (Planned vs Actual Issue)