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
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: requirement and withdrawn quantity (driving table) | — | ECC + S/4 |
| AUFKOrder Master Data | Order type, plant, object number | AUFK-AUFNR = RESB-AUFNR | ECC + S/4 |
| JESTIndividual Object Status | DLV and TECO status | JEST-OBJNR = AUFK-OBJNR AND JEST-INACT = ' ' | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Actual finish date and MRP controller | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFPOOrder Item | Header material, order and delivered quantity | AFPO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| MBEWMaterial Valuation | Standard or moving average price for the variance value | MBEW-MATNR = RESB-MATNR AND MBEW-BWKEY = RESB-WERKS | ECC + S/4 |
| MAKTMaterial Descriptions | Component description | MAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AUFK-WERKS | Yes | 1000 |
| S_AUFNR | Order | Range / multiple | AUFK-AUFNR | No | — |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No | PP01 |
| S_DISPO | MRP controller | Range / multiple | AFKO-DISPO | No | 001 |
| S_GLTRI | Actual finish date | Range / multiple | AFKO-GLTRI | Yes | 01.10.2026 – 31.10.2026 |
| S_MATNR | Component | Range / multiple | RESB-MATNR | No | RM-* |
| P_TOL | Tolerance (%) | Single value | — | Yes | 3 |
| P_DONE | Only DLV or TECO orders | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Order | AUFK-AUFNR |
| 2 | Header material | AFPO-MATNR |
| 3 | Order quantity | AFPO-PSMNG |
| 4 | Delivered | AFPO-WEMNG |
| 5 | Component | RESB-MATNR |
| 6 | Component description | MAKT-MAKTX |
| 7 | Operation | RESB-VORNR |
| 8 | Requirement quantity | RESB-BDMNG |
| 9 | Target consumption | Calculated BDMNG × WEMNG ÷ PSMNG |
| 10 | Withdrawn quantity | RESB-ENMNG |
| 11 | Unit | RESB-MEINS |
| 12 | Variance quantity | Calculated ENMNG − target consumption |
| 13 | Variance (%) | Calculated Variance ÷ target consumption × 100 |
| 14 | Variance value | Calculated Variance × (STPRS or VERPR) ÷ PEINH |
| 15 | Backflush | RESB-RGEKZ |
Sample output
| Order | Header material | Order quantity | Delivered | Component | Component description | Operation | Requirement quantity | Target consumption | Withdrawn quantity | Unit | Variance quantity | Variance (%) | Variance value | Backflush |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000388 | FG-5003 | 1,200 | 1,150 | RM-2040 | Steel sheet 2 mm | 0010 | 2,160 | 2,070 | 2,235 | KG | 165 | 8 | 7,425 | X |
| 1000388 | FG-5003 | 1,200 | 1,150 | PK-1010 | Carton box 60x40 | 0040 | 1,200 | 1,150 | 1,112 | PC | -38 | -3.30 | -193.80 | X |
| 1000402 | FG-6100 | 150 | 150 | RM-3220 | Gasket set 12 pcs | 0030 | 150 | 150 | 162 | PC | 12 | 8 | 1,416 | |
| 1000419 | SA-3100 | 400 | 380 | RM-2105 | Grey primer paint | 0020 | 96 | 91.20 | 98.50 | L | 7.30 | 8 | 1,022 | X |
How does the report work?
- 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.
- AFKO gives the actual finish date (GLTRI) and MRP controller, AFPO the order quantity (PSMNG) and delivered quantity (WEMNG).
- 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).
- Target consumption = BDMNG × WEMNG ÷ PSMNG; variance = ENMNG − target, variance percentage = variance ÷ target × 100.
- 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.
- 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
Production Order Target vs Actual Cost Variance Report
A custom ALV report that compares the actual cost of production orders in a plant with the target cost from delivered quantity × standard price, and …
Production Orders with Consumption but No Goods Receipt Report
A custom ALV report that lists production orders with posted component consumption but no or very little goods receipt, with consumed value, receipt …
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 …
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.