CO Report Custom development ALV report

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

  • CKM3N Material Price Analysis. Shows the price analysis for one material and plant; gives no collective list.
  • CKMLCP Actual Costing Cockpit. Manages the actual costing close; offers no per-material variance ranking.

Tables used

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

TableRoleJoinSystem
CKMLHDMaterial Ledger: Header RecordMaterial ledger header: KALNR, material, valuation area (driving table)—ECC + S/4
CKMLPPMaterial Ledger Period Totals: QuantitiesPeriod quantities and period statusCKMLPP-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 typeCKMLCR-KALNR = CKMLPP-KALNR AND CKMLCR-BDATJ = CKMLPP-BDATJ AND CKMLCR-POPER = CKMLPP-POPER AND CKMLCR-UNTPER = CKMLPP-UNTPER AND CKMLCR-CURTP = P_CURTPECC + S/4
MBEWMaterial ValuationValuation classMBEW-MATNR = CKMLHD-MATNR AND MBEW-BWKEY = CKMLHD-BWKEY AND MBEW-BWTAR = CKMLHD-BWTARECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = CKMLHD-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
T001WPlants/BranchesPlant and nameT001W-BWKEY = CKMLHD-BWKEYECC + 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_BWKEYValuation area (plant)Range / multipleCKMLHD-BWKEYYes1000
S_MATNRMaterialRange / multipleCKMLHD-MATNRNoRM-2051
S_BKLASValuation classRange / multipleMBEW-BKLASNo3000
P_BDATJYearSingle valueCKMLCR-BDATJYes2026
P_POPERPeriodSingle valueCKMLCR-POPERYes010
P_CURTPCurrency typeSingle valueCKMLCR-CURTPYes10
P_MINPDMinimum difference ratio to highlight (%)Single value—No5
P_DIFFOnly materials with price differencesCheckbox—NoX

Output columns

#ColumnSource
1PlantT001W-WERKS
2MaterialCKMLHD-MATNR
3Material descriptionMAKT-MAKTX
4Valuation classMBEW-BKLAS
5Price controlCKMLCR-VPRSV
6Standard priceCKMLCR-STPRS
7Periodic unit priceCKMLCR-PVPRS
8Price unitCKMLCR-PEINH
9Receipt quantityCKMLPP-ZUKUMO
10Receipt price differenceCKMLCR-ZUPRD_O
11Exchange rate differenceCKMLCR-ZUKDM_O
12Total price differenceCalculated CKMLCR-ZUPRD_O + CKMLCR-ZUKDM_O
13Stock valueCKMLCR-SALK3
14Difference ratio %Calculated Total price difference / (stock value + consumption value) × 100
15Period statusCKMLPP-STATUS
16CurrencyCKMLCR-WAERS

Sample output

PlantMaterialMaterial descriptionValuation classPrice controlStandard pricePeriodic unit pricePrice unitReceipt quantityReceipt price differenceExchange rate differenceTotal price differenceStock valueDifference ratio %Period statusCurrency
1000RM-2051Steel sheet 3 mm3000S64.8071.20118,500118,4002,300120,700412,0009.4020TRY
1000RM-1180Polyethylene granules3000S42.5043.10132,00019,200019,200286,0002.1020TRY
2000FG-5003Packed product C7920S295281.6014,200-56,2800-56,280590,000-4.6030TRY
2000RM-3302Carton box 60x403000S5.105.75164,00041,600041,60098,00015.8020TRY
A view built with fictional sample data; not real system data.

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.

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

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: Material Ledger Price Differences by Plant Report