CO Report Custom development ALV report

Standard vs Current Cost Estimate Comparison by Cost Component

Short answer: 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 component, and ranks the difference by amount and percentage.

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

Why is the standard not enough?

CK13N shows the cost estimate and component split of one material; to compare two estimates, materials are opened one by one. CK40N manages the costing run but gives no ranking of component differences across materials. Before releasing the new period's standard cost, which component changed in which material is usually worked out in Excel.

Who uses it? Product cost accountants, production controllers and pricing teams.

Closest standard alternatives

  • CK13N Display Material Cost Estimate. Shows one material's cost estimate; no comparison across materials.
  • CK40N Edit Costing Run. Manages the costing run; gives no ranking of component differences.

Tables used

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

TableRoleJoinSystem
KEKOProduct Costing Header DataCost estimate header: variant, date, status, lot size (driving table)—ECC + S/4
KEPHProduct Costing: Cost ComponentsCost component split (KST001…KST040)KEPH-BZOBJ = KEKO-BZOBJ AND KEPH-KALNR = KEKO-KALNR AND KEPH-KALKA = KEKO-KALKA AND KEPH-KADKY = KEKO-KADKY AND KEPH-TVERS = KEKO-TVERSECC + S/4
MBEWMaterial ValuationCurrent standard price (for cross-check)MBEW-MATNR = KEKO-MATNR AND MBEW-BWKEY = KEKO-WERKSECC + S/4
MARAGeneral Material DataMaterial typeMARA-MATNR = KEKO-MATNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = KEKO-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 / multipleKEKO-WERKSYes1000
S_MATNRMaterialRange / multipleKEKO-MATNRNo300000–399999
S_MTARTMaterial typeRange / multipleMARA-MTARTNoFERT
P_KLVAR1Standard costing variantSingle valueKEKO-KLVARYesPPC1
P_KLVAR2Comparison costing variantSingle valueKEKO-KLVARYesPPC2
P_DATECosting dateSingle valueKEKO-KADKYYes01.11.2026
P_TOLDifference tolerance (%)Single value—No5
P_ONLYDVOnly materials above the toleranceCheckbox—No—

Output columns

#ColumnSource
1PlantKEKO-WERKS
2MaterialKEKO-MATNR
3Material descriptionMAKT-MAKTX
4Lot sizeKEKO-LOSGR
5Standard priceMBEW-STPRS
6Standard totalCalculated Cumulated KEPH KST001…KST040 total of the standard estimate
7Comparison totalCalculated Cumulated KEPH total of the comparison estimate
8DifferenceCalculated Comparison total − standard total
9Difference (%)Calculated Difference / standard total × 100
10Material component differenceCalculated Difference of the KST components mapped to the material group
11Labor and machine differenceCalculated Difference of the KST components mapped to the labor and machine group
12Overhead differenceCalculated Difference of the KST components mapped to the overhead group
13CurrencyKEKO-HWAER

Sample output

PlantMaterialMaterial descriptionLot sizeStandard priceStandard totalComparison totalDifferenceDifference (%)Material component differenceLabor and machine differenceOverhead differenceCurrency
1000300045Plastic crate 40 L1,00086.4086,40093,1506,7507.806,100420230TRY
1000300052Plastic bucket 10 L1,00024.1024,10024,4803801.602906030TRY
2000500210Steel shelving unit1001,450145,000131,900-13,100-9-14,200800300TRY
A view built with fictional sample data; not real system data.

How does the report work?

  1. Materials are read from KEKO by plant and material selection, the material type from MARA and the description from MAKT.
  2. Standard estimate: the latest KEKO record with costing variant P_KLVAR1, status released (FEH_STA = FR) and a costing date (KADKY) before P_DATE. It is cross-checked against MBEW-STPRS.
  3. Comparison estimate: the latest error-free KEKO record with costing variant P_KLVAR2.
  4. For both estimates the primary cost component split is read from KEPH; level and lower-level rows (KKZST) are added together for the cumulated value. Components KST001…KST040 are summed into groups defined during installation (material, labor and machine, overhead).
  5. The total difference, percentage and component group differences are calculated; materials above P_TOL are put first and sorted by the absolute difference.

Performance notes

Read KEKO by plant, costing variant and date; the KEPH read uses the full cost estimate keys (KALNR, KADKY, TVERS). For thousands of materials, a background run is recommended.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the material opens both estimates in CK13N.
  • Export to Excel
  • Runs as a background job Can run automatically after the overnight costing run.

Authorization objects

  • K_KEKOCost estimate display authorization

Frequently asked questions

How are cost components mapped to columns?

The numbers KST001…KST040 get their meaning from the company's cost component structure. During installation this structure is read and the components are mapped to groups such as material, labor and machine, and overhead; each component can also be shown as its own column.

Can I see which item caused the difference?

The report shows the difference at component group level. For detail, the itemization table (CKIS) can be read to list the raw material or activity items behind the difference on a second screen; this extension adds 1–2 days to the effort range.

Does it work on S/4HANA?

Yes. KEKO, KEPH and CKIS are still used for product costing on S/4HANA; MBEW is read as a compatibility view.

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

MM Report Custom ALV report

Stock Aging Report

A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …

MARD · MARA · MAKT · MBEW

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: Standard vs Current Cost Estimate Comparison by Cost Component