Material Ledger Price Differences by Plant Report
Short answer: 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.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Product cost controllers, teams running the material ledger close and managers tracking purchase price variance.
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 |
|---|---|---|---|
| CKMLHDMaterial Ledger: Header Record | Material ledger header: KALNR, material, valuation area (driving table) | — | ECC + S/4 |
| CKMLPPMaterial Ledger Period Totals: Quantities | Period quantities and period status | CKMLPP-KALNR = CKMLHD-KALNR AND CKMLPP-BDATJ = P_BDATJ AND CKMLPP-POPER = P_POPER AND CKMLPP-UNTPER = '000' | ECC + S/4 |
| CKMLCRMaterial Ledger: Period Totals (Values) | Prices, stock value and price differences per currency type | 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 |
| MBEWMaterial Valuation | Valuation class | MBEW-MATNR = CKMLHD-MATNR AND MBEW-BWKEY = CKMLHD-BWKEY AND MBEW-BWTAR = CKMLHD-BWTAR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = CKMLHD-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| T001WPlants/Branches | Plant and name | T001W-BWKEY = CKMLHD-BWKEY | 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_BWKEY | Valuation area (plant) | Range / multiple | CKMLHD-BWKEY | Yes | 1000 |
| S_MATNR | Material | Range / multiple | CKMLHD-MATNR | No | RM-2051 |
| S_BKLAS | Valuation class | Range / multiple | MBEW-BKLAS | No | 3000 |
| P_BDATJ | Year | Single value | CKMLCR-BDATJ | Yes | 2026 |
| P_POPER | Period | Single value | CKMLCR-POPER | Yes | 010 |
| P_CURTP | Currency type | Single value | CKMLCR-CURTP | Yes | 10 |
| P_MINPD | Minimum difference ratio to highlight (%) | Single value | — | No | 5 |
| P_DIFF | Only materials with price differences | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | T001W-WERKS |
| 2 | Material | CKMLHD-MATNR |
| 3 | Material description | MAKT-MAKTX |
| 4 | Valuation class | MBEW-BKLAS |
| 5 | Price control | CKMLCR-VPRSV |
| 6 | Standard price | CKMLCR-STPRS |
| 7 | Periodic unit price | CKMLCR-PVPRS |
| 8 | Price unit | CKMLCR-PEINH |
| 9 | Receipt quantity | CKMLPP-ZUKUMO |
| 10 | Receipt price difference | CKMLCR-ZUPRD_O |
| 11 | Exchange rate difference | CKMLCR-ZUKDM_O |
| 12 | Total price difference | Calculated CKMLCR-ZUPRD_O + CKMLCR-ZUKDM_O |
| 13 | Stock value | CKMLCR-SALK3 |
| 14 | Difference ratio % | Calculated Total price difference / (stock value + consumption value) × 100 |
| 15 | Period status | CKMLPP-STATUS |
| 16 | Currency | CKMLCR-WAERS |
Sample output
| Plant | Material | Material description | Valuation class | Price control | Standard price | Periodic unit price | Price unit | Receipt quantity | Receipt price difference | Exchange rate difference | Total price difference | Stock value | Difference ratio % | Period status | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | RM-2051 | Steel sheet 3 mm | 3000 | S | 64.80 | 71.20 | 1 | 18,500 | 118,400 | 2,300 | 120,700 | 412,000 | 9.40 | 20 | TRY |
| 1000 | RM-1180 | Polyethylene granules | 3000 | S | 42.50 | 43.10 | 1 | 32,000 | 19,200 | 0 | 19,200 | 286,000 | 2.10 | 20 | TRY |
| 2000 | FG-5003 | Packed product C | 7920 | S | 295 | 281.60 | 1 | 4,200 | -56,280 | 0 | -56,280 | 590,000 | -4.60 | 30 | TRY |
| 2000 | RM-3302 | Carton box 60x40 | 3000 | S | 5.10 | 5.75 | 1 | 64,000 | 41,600 | 0 | 41,600 | 98,000 | 15.80 | 20 | TRY |
How does the report work?
- 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.
- Quantities and period status for the selected year and period are read from CKMLPP: receipts (ZUKUMO), consumption (VNKUMO), stock (LBKUM), STATUS.
- 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).
- Total price difference = ZUPRD_O + ZUKDM_O; difference ratio = total price difference / (stock value + consumption value) × 100.
- 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.
Performance notes
Read CKMLCR and CKMLPP by KALNR, year, period and currency type; build the KALNR list from CKMLHD first. For sub-periods (UNTPER) take only 000. On S/4HANA material ledger values come from ACDOCA and the related CDS views; the logic stays the same.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the material opens CKM3N for that period.
- Export to Excel
- Runs as a background job Can be scheduled before and after the closing run for comparison.
Authorization objects
- K_ML_VAMaterial ledger authorization by valuation area
- K_KEKOAuthorization 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.
Related reports
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 …
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 …
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.