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

> 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.

- Type: Report, Custom development, ALV report
- Module: PP
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/production-order-component-consumption-variance-report/


## 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.

### Closest standard alternatives

- COOIS: Lists component requirement and withdrawn quantities; does not calculate target consumption for the delivered quantity or a variance value.
- MB51: Shows the 261 movements posted to the order; there is no comparison with the plan.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| RESB | Order components: requirement and withdrawn quantity (driving table) | Read | - | ECC + S/4 |
| AUFK | Order type, plant, object number | Read | AUFK-AUFNR = RESB-AUFNR | ECC + S/4 |
| JEST | DLV and TECO status | Read | JEST-OBJNR = AUFK-OBJNR AND JEST-INACT = ' ' | ECC + S/4 |
| AFKO | Actual finish date and MRP controller | Read | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFPO | Header material, order and delivered quantity | Read | AFPO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| MBEW | Standard or moving average price for the variance value | Read | MBEW-MATNR = RESB-MATNR AND MBEW-BWKEY = RESB-WERKS | ECC + S/4 |
| MAKT | Component description | Read | MAKT-MATNR = RESB-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AUFK-WERKS | Yes |
| S_AUFNR | Order | Range / multiple | AUFK-AUFNR | No |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No |
| S_DISPO | MRP controller | Range / multiple | AFKO-DISPO | No |
| S_GLTRI | Actual finish date | Range / multiple | AFKO-GLTRI | Yes |
| S_MATNR | Component | Range / multiple | RESB-MATNR | No |
| P_TOL | Tolerance (%) | Single value | - | Yes |
| P_DONE | Only DLV or TECO orders | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Order | AUFK-AUFNR |
| Header material | AFPO-MATNR |
| Order quantity | AFPO-PSMNG |
| Delivered | AFPO-WEMNG |
| Component | RESB-MATNR |
| Component description | MAKT-MAKTX |
| Operation | RESB-VORNR |
| Requirement quantity | RESB-BDMNG |
| Target consumption | Calculated: BDMNG × WEMNG ÷ PSMNG |
| Withdrawn quantity | RESB-ENMNG |
| Unit | RESB-MEINS |
| Variance quantity | Calculated: ENMNG − target consumption |
| Variance (%) | Calculated: Variance ÷ target consumption × 100 |
| Variance value | Calculated: Variance × (STPRS or VERPR) ÷ PEINH |
| Backflush | RESB-RGEKZ |

## 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.

## Authorization objects

- C_AFKO_AWK: Display production orders by plant and order type
- M_MATE_WRK: Plant-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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=pp-component-consumption-variance
