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

- Type: Report, Custom development, ALV report
- Module: CO
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/standard-vs-current-cost-estimate-comparison-report/


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

### Closest standard alternatives

- CK13N: Shows one material's cost estimate; no comparison across materials.
- CK40N: Manages the costing run; gives no ranking of component differences.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| KEKO | Cost estimate header: variant, date, status, lot size (driving table) | Read | - | ECC + S/4 |
| KEPH | Cost component split (KST001…KST040) | Read | 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 |
| MBEW | Current standard price (for cross-check) | Read | MBEW-MATNR = KEKO-MATNR AND MBEW-BWKEY = KEKO-WERKS | ECC + S/4 |
| MARA | Material type | Read | MARA-MATNR = KEKO-MATNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = KEKO-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | KEKO-WERKS | Yes |
| S_MATNR | Material | Range / multiple | KEKO-MATNR | No |
| S_MTART | Material type | Range / multiple | MARA-MTART | No |
| P_KLVAR1 | Standard costing variant | Single value | KEKO-KLVAR | Yes |
| P_KLVAR2 | Comparison costing variant | Single value | KEKO-KLVAR | Yes |
| P_DATE | Costing date | Single value | KEKO-KADKY | Yes |
| P_TOL | Difference tolerance (%) | Single value | - | No |
| P_ONLYDV | Only materials above the tolerance | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Plant | KEKO-WERKS |
| Material | KEKO-MATNR |
| Material description | MAKT-MAKTX |
| Lot size | KEKO-LOSGR |
| Standard price | MBEW-STPRS |
| Standard total | Calculated: Cumulated KEPH KST001…KST040 total of the standard estimate |
| Comparison total | Calculated: Cumulated KEPH total of the comparison estimate |
| Difference | Calculated: Comparison total − standard total |
| Difference (%) | Calculated: Difference / standard total × 100 |
| Material component difference | Calculated: Difference of the KST components mapped to the material group |
| Labor and machine difference | Calculated: Difference of the KST components mapped to the labor and machine group |
| Overhead difference | Calculated: Difference of the KST components mapped to the overhead group |
| Currency | KEKO-HWAER |

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

## Authorization objects

- K_KEKO: Cost 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=co-cost-estimate-comparison
