CO Report Custom development ALV report

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

  • KKBC_ORD Analyze Order. Analyzes costs per order; gives no ranking across the plant.
  • KOB1 Orders: Actual Line Items. Lists the order's actual line items; gives no target cost or variance.

Tables used

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

TableRoleJoinSystem
AFPOOrder ItemProduction order item: material, plant, planned and delivered quantity (driving table)—ECC + S/4
AFKOOrder Header Data for PP OrdersProduction order header and MRP controllerAFKO-AUFNR = AFPO-AUFNRECC + S/4
AUFKOrder Master DataOrder object number and controlling areaAUFK-AUFNR = AFPO-AUFNRECC + S/4
COSPCO Object: Cost Totals for External PostingsPrimary actual costs and goods receipt creditsCOSP-OBJNR = AUFK-OBJNRECC + S/4
COSSCO Object: Cost Totals for Internal PostingsSecondary actual costs (activities, overhead)COSS-OBJNR = AUFK-OBJNRECC + S/4
MBEWMaterial ValuationStandard price and price unitMBEW-MATNR = AFPO-MATNR AND MBEW-BWKEY = AFPO-PWERKECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = AFPO-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
JESTIndividual Object StatusSystem status (REL, DLV, TECO)JEST-OBJNR = AUFK-OBJNRECC + S/4
TKA01Controlling AreasControlling area currencyTKA01-KOKRS = AUFK-KOKRSECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleAFPO-PWERKYes1000
S_AUFNRProduction orderRange / multipleAFPO-AUFNRNo—
S_MATNRMaterialRange / multipleAFPO-MATNRNo300045
S_DISPOMRP controllerRange / multipleAFKO-DISPONo001
P_GJAHRFiscal yearSingle valueCOSS-GJAHRYes2026
P_PERIOUp to periodSingle value—Yes10
P_ONLYDLOnly delivered / technically complete ordersCheckbox—NoX
P_TOLVariance tolerance (%)Single value—No5

Output columns

#ColumnSource
1OrderAFPO-AUFNR
2PlantAFPO-PWERK
3MaterialAFPO-MATNR
4Material descriptionMAKT-MAKTX
5Planned quantityAFPO-PSMNG
6Delivered quantityAFPO-WEMNG
7UnitAFPO-MEINS
8Target costCalculated AFPO-WEMNG × MBEW-STPRS / MBEW-PEINH
9Actual costCalculated COSP + COSS value type 04 debits (settlement excluded)
10Goods receipt creditCalculated COSP + COSS value type 04 credits (BEKNZ = H)
11VarianceCalculated Actual cost − target cost
12Variance (%)Calculated Variance / target cost × 100
13System statusCalculated Short text of the active system statuses in JEST
14CurrencyTKA01-WAERS

Sample output

OrderPlantMaterialMaterial descriptionPlanned quantityDelivered quantityUnitTarget costActual costGoods receipt creditVarianceVariance (%)System statusCurrency
10000811000300045Plastic crate 40 L5,0004,920PC425,088447,300-425,08822,2125.20DLVTRY
10000941000300052Plastic bucket 10 L12,00012,000PC289,200286,950-289,200-2,250-0.80DLVTRY
10001021000300045Plastic crate 40 L3,0002,610PC225,504262,800-225,50437,29616.50TECOTRY
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. Target cost (simplified) = delivered quantity (AFPO-WEMNG) × MBEW-STPRS / MBEW-PEINH.
  4. Variance = actual cost − target cost; variance % = variance / target cost × 100. For yield, the delivered quantity is compared with the planned quantity (PSMNG).
  5. 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

CO Package Custom

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 …

4 components · v1.0

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: Production Order Target vs Actual Cost Variance Report