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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| KEKOProduct Costing Header Data | Cost estimate header: variant, date, status, lot size (driving table) | — | ECC + S/4 |
| KEPHProduct Costing: Cost Components | Cost 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-TVERS | ECC + S/4 |
| MBEWMaterial Valuation | Current standard price (for cross-check) | MBEW-MATNR = KEKO-MATNR AND MBEW-BWKEY = KEKO-WERKS | ECC + S/4 |
| MARAGeneral Material Data | Material type | MARA-MATNR = KEKO-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = KEKO-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 | KEKO-WERKS | Yes | 1000 |
| S_MATNR | Material | Range / multiple | KEKO-MATNR | No | 300000–399999 |
| S_MTART | Material type | Range / multiple | MARA-MTART | No | FERT |
| P_KLVAR1 | Standard costing variant | Single value | KEKO-KLVAR | Yes | PPC1 |
| P_KLVAR2 | Comparison costing variant | Single value | KEKO-KLVAR | Yes | PPC2 |
| P_DATE | Costing date | Single value | KEKO-KADKY | Yes | 01.11.2026 |
| P_TOL | Difference tolerance (%) | Single value | — | No | 5 |
| P_ONLYDV | Only materials above the tolerance | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | KEKO-WERKS |
| 2 | Material | KEKO-MATNR |
| 3 | Material description | MAKT-MAKTX |
| 4 | Lot size | KEKO-LOSGR |
| 5 | Standard price | MBEW-STPRS |
| 6 | Standard total | Calculated Cumulated KEPH KST001…KST040 total of the standard estimate |
| 7 | Comparison total | Calculated Cumulated KEPH total of the comparison estimate |
| 8 | Difference | Calculated Comparison total − standard total |
| 9 | Difference (%) | Calculated Difference / standard total × 100 |
| 10 | Material component difference | Calculated Difference of the KST components mapped to the material group |
| 11 | Labor and machine difference | Calculated Difference of the KST components mapped to the labor and machine group |
| 12 | Overhead difference | Calculated Difference of the KST components mapped to the overhead group |
| 13 | Currency | KEKO-HWAER |
Sample output
| Plant | Material | Material description | Lot size | Standard price | Standard total | Comparison total | Difference | Difference (%) | Material component difference | Labor and machine difference | Overhead difference | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 300045 | Plastic crate 40 L | 1,000 | 86.40 | 86,400 | 93,150 | 6,750 | 7.80 | 6,100 | 420 | 230 | TRY |
| 1000 | 300052 | Plastic bucket 10 L | 1,000 | 24.10 | 24,100 | 24,480 | 380 | 1.60 | 290 | 60 | 30 | TRY |
| 2000 | 500210 | Steel shelving unit | 100 | 1,450 | 145,000 | 131,900 | -13,100 | -9 | -14,200 | 800 | 300 | TRY |
How does the report work?
- Materials are read from KEKO by plant and material selection, the material type from MARA and the description from MAKT.
- 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.
- Comparison estimate: the latest error-free KEKO record with costing variant P_KLVAR2.
- 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).
- 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
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
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 …
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, …
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.