Production Order Target vs Actual Cost Variance Report
Short answer: 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 ranks the variance by amount and percentage. It gives an early warning before the variance calculation and settlement.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
KKBC_ORD analyzes costs per order and orders are opened one by one. KOB1 lists actual line items but gives no target cost or variance. The period-end variance calculation results are per order and do not offer a list that ranks all orders of a plant by variance size with material description and yield.
Who uses it? Production controllers, cost accountants and production planning managers.
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 |
|---|---|---|---|
| AFPOOrder Item | Production order item: material, plant, planned and delivered quantity (driving table) | — | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Production order header and MRP controller | AFKO-AUFNR = AFPO-AUFNR | ECC + S/4 |
| AUFKOrder Master Data | Order object number and controlling area | AUFK-AUFNR = AFPO-AUFNR | ECC + S/4 |
| COSPCO Object: Cost Totals for External Postings | Primary actual costs and goods receipt credits | COSP-OBJNR = AUFK-OBJNR | ECC + S/4 |
| COSSCO Object: Cost Totals for Internal Postings | Secondary actual costs (activities, overhead) | COSS-OBJNR = AUFK-OBJNR | ECC + S/4 |
| MBEWMaterial Valuation | Standard price and price unit | MBEW-MATNR = AFPO-MATNR AND MBEW-BWKEY = AFPO-PWERK | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = AFPO-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| JESTIndividual Object Status | System status (REL, DLV, TECO) | JEST-OBJNR = AUFK-OBJNR | ECC + S/4 |
| TKA01Controlling Areas | Controlling area currency | TKA01-KOKRS = AUFK-KOKRS | ECC + S/4 |
S/4HANA notes
- COSP → ACDOCA: In S/4HANA COSP is a view, not a table; actual totals are calculated from ACDOCA.
- COSS → ACDOCA: In S/4HANA COSS is a view, not a table; internal actual postings are read from ACDOCA.
- 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 | AFPO-PWERK | Yes | 1000 |
| S_AUFNR | Production order | Range / multiple | AFPO-AUFNR | No | — |
| S_MATNR | Material | Range / multiple | AFPO-MATNR | No | 300045 |
| S_DISPO | MRP controller | Range / multiple | AFKO-DISPO | No | 001 |
| P_GJAHR | Fiscal year | Single value | COSS-GJAHR | Yes | 2026 |
| P_PERIO | Up to period | Single value | — | Yes | 10 |
| P_ONLYDL | Only delivered / technically complete orders | Checkbox | — | No | X |
| P_TOL | Variance tolerance (%) | Single value | — | No | 5 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Order | AFPO-AUFNR |
| 2 | Plant | AFPO-PWERK |
| 3 | Material | AFPO-MATNR |
| 4 | Material description | MAKT-MAKTX |
| 5 | Planned quantity | AFPO-PSMNG |
| 6 | Delivered quantity | AFPO-WEMNG |
| 7 | Unit | AFPO-MEINS |
| 8 | Target cost | Calculated AFPO-WEMNG × MBEW-STPRS / MBEW-PEINH |
| 9 | Actual cost | Calculated COSP + COSS value type 04 debits (settlement excluded) |
| 10 | Goods receipt credit | Calculated COSP + COSS value type 04 credits (BEKNZ = H) |
| 11 | Variance | Calculated Actual cost − target cost |
| 12 | Variance (%) | Calculated Variance / target cost × 100 |
| 13 | System status | Calculated Short text of the active system statuses in JEST |
| 14 | Currency | TKA01-WAERS |
Sample output
| Order | Plant | Material | Material description | Planned quantity | Delivered quantity | Unit | Target cost | Actual cost | Goods receipt credit | Variance | Variance (%) | System status | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000081 | 1000 | 300045 | Plastic crate 40 L | 5,000 | 4,920 | PC | 425,088 | 447,300 | -425,088 | 22,212 | 5.20 | DLV | TRY |
| 1000094 | 1000 | 300052 | Plastic bucket 10 L | 12,000 | 12,000 | PC | 289,200 | 286,950 | -289,200 | -2,250 | -0.80 | DLV | TRY |
| 1000102 | 1000 | 300045 | Plastic crate 40 L | 3,000 | 2,610 | PC | 225,504 | 262,800 | -225,504 | 37,296 | 16.50 | TECO | TRY |
How does the report work?
- Production order items matching the plant (PWERK) and material selection are read from AFPO, the MRP controller from AFKO and the object number from AUFK; the system status comes from JEST. With P_ONLYDL only delivered (DLV) or technically complete (TECO) orders are listed.
- Actual cost: value type 04 debits in COSP and COSS from the start of the fiscal year up to P_PERIO; goods receipt credits are summed separately by the debit/credit indicator (BEKNZ) and settlement lines are excluded. The report therefore gives the same result before and after settlement.
- Target cost (simplified) = delivered quantity (AFPO-WEMNG) × MBEW-STPRS / MBEW-PEINH.
- Variance = actual cost − target cost; variance % = variance / target cost × 100. For yield, the delivered quantity is compared with the planned quantity (PSMNG).
- Orders above P_TOL are put first and sorted by the absolute variance.
Performance notes
Select orders from AFPO with plant and a date limit; read COSP/COSS once with the object number list. For high-volume plants, a background run is recommended.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants Variants with subtotals by material or MRP controller can be saved.
- Double-click drill-down to the document Double-clicking the order opens KKBC_ORD; double-clicking the actual cost opens KOB1.
- Export to Excel
- Runs as a background job
- Send the result by email
Authorization objects
- C_AFKO_AWKProduction order authorization by plant and order type
Frequently asked questions
Why can the result differ from the period-end variance calculation?
The report simplifies the target cost as delivered quantity × standard price. The period-end variance calculation uses the target cost version, work in process and variance categories. The report is for early warning; for exact variance categories, the variance calculation results can be added to the report.
Are scrap and yield losses visible?
The ratio of delivered to planned quantity can be shown as yield. Confirmed scrap quantities can be read from the operation confirmations and added as a separate column.
Does it work on S/4HANA?
Yes. AFKO, AFPO and JEST are used the same way; COSP, COSS and MBEW are read as compatibility views and actuals come from ACDOCA.
Packages that include this solution
Product Cost and Production Variance Pack
A four-report pack that shows where product cost variance comes from, with one plant and period selection: standard vs current cost estimate …
Related reports
Activity Type Plan vs Actual Rate and Under/Over-Absorption Report
A custom ALV report that compares the plan rate per cost center and activity type with the actual rate derived from actual costs, and shows the under- …
Standard vs Current Cost Estimate Comparison by Cost Component
A custom ALV report that compares the released standard cost estimate of all materials in a plant with the current or modified cost estimate by cost …
Orders Without Settlement Rule or With Unsettled Balance Report
A custom ALV report that lists orders that received costs but have no settlement rule, and internal and production orders that still carry a balance …
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.