queryviz

tables/relationship path

open in builder

SPRSL → SPRAS

SPRAS

MATNR

MATNR

CKMLHD

material ledger: material header. stores the material ledger settings and control data for each material/valuation area combination. mandatory in s/4hana for actual costing.

co9f · 2k · 3r

Unchanged in S/4

CKMLHD is mandatory in S/4HANA as Material Ledger is always active. The table structure remains the same but its importance increases significantly in S/4HANA.

key differences:

•Material Ledger is mandatory in S/4HANA (always activated)
•Actual costing run becomes the standard approach for period-end closing
•Integration with ACDOCA for actual cost postings

fields (9)

field	type	length	key	description
`KALNR`	numc	12	pk	cost estimate number (material ledger document)
`MANDT`	clnt	3	pk	client
`BWKEY`	char	4		valuation area (typically = plant)
`BWTAR`	char	10		valuation type (for split valuation)
`MATNR`	char	18		material number
`MEINS`	unit	3		base unit of measure
`MLAST`	char	1		material price determination: control
`MLKZ`	char	1		material price determination indicator
`VPRSV`	char	1		price control indicator (s=standard, v=moving average)

relationships (3)

header / item

parent-child document structure

references

CKMLCR

KALNRKALNR

1:N

referenced by

CKMLCR

KALNRKALNR

1:N

master lookup

reference to master data

references

MARA

MATNRMATNR

1:N