# Material Ledger Price Differences by Plant Report

> A custom ALV report that shows the standard price, periodic unit price and price differences from the material ledger for all materials and plants in one list. The ratio of price differences to stock value is calculated, and materials above a threshold stand out.

- 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/material-ledger-price-differences-by-plant-report/


## Why is the standard not enough?

CKM3N opens the material price analysis for one material and one plant; at period end it is run one by one to scan hundreds of materials. CKMLCP manages the closing steps but gives no per-material variance ranking. Seeing which materials have high price differences before the close needs a collective list.

### Closest standard alternatives

- CKM3N: Shows the price analysis for one material and plant; gives no collective list.
- CKMLCP: Manages the actual costing close; offers no per-material variance ranking.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| CKMLHD | Material ledger header: KALNR, material, valuation area (driving table) | Read | - | ECC + S/4 |
| CKMLPP | Period quantities and period status | Read | CKMLPP-KALNR = CKMLHD-KALNR AND CKMLPP-BDATJ = P_BDATJ AND CKMLPP-POPER = P_POPER AND CKMLPP-UNTPER = '000' | ECC + S/4 |
| CKMLCR | Prices, stock value and price differences per currency type | Read | CKMLCR-KALNR = CKMLPP-KALNR AND CKMLCR-BDATJ = CKMLPP-BDATJ AND CKMLCR-POPER = CKMLPP-POPER AND CKMLCR-UNTPER = CKMLPP-UNTPER AND CKMLCR-CURTP = P_CURTP | ECC + S/4 |
| MBEW | Valuation class | Read | MBEW-MATNR = CKMLHD-MATNR AND MBEW-BWKEY = CKMLHD-BWKEY AND MBEW-BWTAR = CKMLHD-BWTAR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = CKMLHD-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| T001W | Plant and name | Read | T001W-BWKEY = CKMLHD-BWKEY | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BWKEY | Valuation area (plant) | Range / multiple | CKMLHD-BWKEY | Yes |
| S_MATNR | Material | Range / multiple | CKMLHD-MATNR | No |
| S_BKLAS | Valuation class | Range / multiple | MBEW-BKLAS | No |
| P_BDATJ | Year | Single value | CKMLCR-BDATJ | Yes |
| P_POPER | Period | Single value | CKMLCR-POPER | Yes |
| P_CURTP | Currency type | Single value | CKMLCR-CURTP | Yes |
| P_MINPD | Minimum difference ratio to highlight (%) | Single value | - | No |
| P_DIFF | Only materials with price differences | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Plant | T001W-WERKS |
| Material | CKMLHD-MATNR |
| Material description | MAKT-MAKTX |
| Valuation class | MBEW-BKLAS |
| Price control | CKMLCR-VPRSV |
| Standard price | CKMLCR-STPRS |
| Periodic unit price | CKMLCR-PVPRS |
| Price unit | CKMLCR-PEINH |
| Receipt quantity | CKMLPP-ZUKUMO |
| Receipt price difference | CKMLCR-ZUPRD_O |
| Exchange rate difference | CKMLCR-ZUKDM_O |
| Total price difference | Calculated: CKMLCR-ZUPRD_O + CKMLCR-ZUKDM_O |
| Stock value | CKMLCR-SALK3 |
| Difference ratio % | Calculated: Total price difference / (stock value + consumption value) × 100 |
| Period status | CKMLPP-STATUS |
| Currency | CKMLCR-WAERS |

## How does the report work?

1. Cost estimate numbers (KALNR) are taken from CKMLHD by valuation area (BWKEY) and material selection; the valuation class is added from MBEW and filtered by S_BKLAS.
2. Quantities and period status for the selected year and period are read from CKMLPP: receipts (ZUKUMO), consumption (VNKUMO), stock (LBKUM), STATUS.
3. Values for the same period and the selected currency type (CURTP) are read from CKMLCR: standard price (STPRS), periodic unit price (PVPRS), stock value (SALK3), receipt price differences (ZUPRD_O), consumption price differences (VNPRD_EA) and exchange rate differences (ZUKDM_O).
4. Total price difference = ZUPRD_O + ZUKDM_O; difference ratio = total price difference / (stock value + consumption value) × 100.
5. The plant name is added from T001W (by BWKEY) and the text from MAKT; rows above P_MINPD are highlighted and the list is sorted by ratio.

## Authorization objects

- K_ML_VA: Material ledger authorization by valuation area
- K_KEKO: Authorization to display product costing data

## Frequently asked questions

### What does the currency type mean?

The material ledger can keep values in several currencies: 10 for company code currency, 30 for group currency and so on. The report shows the values of the selected type.

### What is visible before the close?

The receipt price differences accumulated during the period are visible; the periodic unit price is final after the closing run. The pre-close list helps find problem materials early.

### Are multilevel price determination differences included?

Differences rolled up from consumption (fields such as VNPRD_EA) can be added as a separate column. The default layout focuses on receipt and exchange rate differences.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=co-material-ledger-price-differences
