SAP CKML1 Material Ledger Period Totals Records (Release 3.xx) Table data and field list

CKML1 is a standard SAP Table which is used to store Material Ledger Period Totals Records (Release 3.xx) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CKML1 table consists of various fields, each holding specific information or linking keys about Material Ledger Period Totals Records (Release 3.xx) data available in SAP. These include KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure), MATLED (Material ledger type), BDATJ (Posting Date YYYY), POPER (Posting period)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CKML1 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CKML1 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CKML1 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
MATLEDMaterial ledger type CK_MATLEDCHAR4TCKM1CK_MATLED
BDATJPosting Date YYYY BDATJNUMC4GJAHRGJAHRBDTJ
POPERPosting period POPERNUMC3POPERPOPR
UNTPERValue Structure Type CK_UNTPERNUMC3CK_UNTPER
STPRS_1Standard price CK_STPRS_1CURR11(2) WERT11
STPRS_2Standard price CK_STPRS_2CURR11(2) WERT11
STPRS_3Standard price CK_STPRS_3CURR11(2) WERT11
PVPRS_1Periodic unit price CK_PVPRS_1CURR11(2) WERT11
PVPRS_2Periodic unit price CK_PVPRS_2CURR11(2) WERT11
PVPRS_3Periodic unit price CK_PVPRS_3CURR11(2) WERT11
LBKUMTotal valuated stock CK_LBKUMQUAN15(3) MENGV8
SALK3_1Value of total valuated stock CK_SALK3_1CURR15(2) WERTV8
SALK3_2Value of total valuated stock CK_SALK3_2CURR15(2) WERTV8
SALK3_3Value of total valuated stock CK_SALK3_3CURR15(2) WERTV8
SALKV_1Value based on the periodic unit price (only with pr.ctrl S) CK_SALKV_1CURR15(2) WERTV8
SALKV_2Value based on the periodic unit price (only with pr.ctrl S) CK_SALKV_2CURR15(2) WERTV8
SALKV_3Value based on the periodic unit price (only with pr.ctrl S) CK_SALKV_3CURR15(2) WERTV8
KZ_ABGERMaterial price will no longer be determined in this period XABGERCHAR1XABGER
.INCLU-O 0
WEKUMOTotal valuated qty of goods received in the period CK_WEKUMQUAN15(3) MENGV8
WEWRT_1OTotal value of goods receipts for period CK_WEWRT_1CURR15(2) WERTV8
WEWRT_2OTotal value of goods receipts for period CK_WEWRT_2CURR15(2) WERTV8
WEWRT_3OTotal value of goods receipts for period CK_WEWRT_3CURR15(2) WERTV8
REKUMOTotal valuted invoice receipt quantity for the period CK_REKUMQUAN15(3) MENGV8
REWRT_1OTotal invoice receipt value of period CK_REWRT_1CURR15(2) WERTV8
REWRT_2OTotal invoice receipt value of period CK_REWRT_2CURR15(2) WERTV8
REWRT_3OTotal invoice receipt value of period CK_REWRT_3CURR15(2) WERTV8
LVREKUMOSubcontracting: total valuated invoice receipt quantity CK_LVREKUMQUAN15(3) MENGV8
LVREW_1OSubcontracting: total invoice receipt value CK_LVREW_1CURR15(2) WERTV8
LVREW_2OSubcontracting: total invoice receipt value CK_LVREW_2CURR15(2) WERTV8
LVREW_3OSubcontracting: total invoice receipt value CK_LVREW_3CURR15(2) WERTV8
ZUKUMOTotal quantity of goods received in period CK_ZUKUMQUAN15(3) MENGV8
ZUABW_1OReceipts: Single-level price differences CK_ZUABW_1CURR15(2) WERTV8
ZUABW_2OVariance to ML price CK_ZUABW_2CURR15(2) WERTV8
ZUABW_3OVariance to ML price CK_ZUABW_3CURR15(2) WERTV8
LVABW_1OSubcontrac.: var. from planned value of mat. to be provided CK_LVABW_1CURR15(2) WERTV8
LVABW_2OSubcontrac.: var. from planned value of mat. to be provided CK_LVABW_2CURR15(2) WERTV8
LVABW_3OSubcontrac.: var. from planned value of mat. to be provided CK_LVABW_3CURR15(2) WERTV8
LVWEKUMOSubcontracting: total valuated quantity of goods received CK_LVWEKUMQUAN15(3) MENGV8
LVWEW_1OSubcontracting: value of goods received CK_LVWEW_1CURR15(2) WERTV8
LVWEW_2OSubcontracting: value of goods received CK_LVWEW_2CURR15(2) WERTV8
LVWEW_3OSubcontracting: value of goods received CK_LVWEW_3CURR15(2) WERTV8
ZUOME_1OAmount to be debited to material ledger price CK_ZUOME_1CURR15(2) WERTV8
ZUOME_2OAmount to be debited to material ledger price CK_ZUOME_2CURR15(2) WERTV8
ZUOME_3OAmount to be debited to material ledger price CK_ZUOME_3CURR15(2) WERTV8
ZUUMB_1ORevaluation Amount CK_ZUUMB_1CURR15(2) WERTV8
ZUUMB_2ORevaluation amount for material ledger price CK_ZUUMB_2CURR15(2) WERTV8
ZUUMB_3ORevaluation amount for material ledger price CK_ZUUMB_3CURR15(2) WERTV8
LVPVP_1Subcontracting: periodic unit price (PUP) CK_LVPVP_1CURR11(2) WERT11
LVPVP_2Subcontracting: periodic unit price (PUP) CK_LVPVP_2CURR11(2) WERT11
LVPVP_3Subcontracting: periodic unit price (PUP) CK_LVPVP_3CURR11(2) WERT11
.INCLU-A 0
WEKUMATotal valuated qty of goods received in the period CK_WEKUMQUAN15(3) MENGV8
WEWRT_1ATotal value of goods receipts for period CK_WEWRT_1CURR15(2) WERTV8
WEWRT_2ATotal value of goods receipts for period CK_WEWRT_2CURR15(2) WERTV8
WEWRT_3ATotal value of goods receipts for period CK_WEWRT_3CURR15(2) WERTV8
REKUMATotal valuted invoice receipt quantity for the period CK_REKUMQUAN15(3) MENGV8
REWRT_1ATotal invoice receipt value of period CK_REWRT_1CURR15(2) WERTV8
REWRT_2ATotal invoice receipt value of period CK_REWRT_2CURR15(2) WERTV8
REWRT_3ATotal invoice receipt value of period CK_REWRT_3CURR15(2) WERTV8
LVREKUMASubcontracting: total valuated invoice receipt quantity CK_LVREKUMQUAN15(3) MENGV8
LVREW_1ASubcontracting: total invoice receipt value CK_LVREW_1CURR15(2) WERTV8
LVREW_2ASubcontracting: total invoice receipt value CK_LVREW_2CURR15(2) WERTV8
LVREW_3ASubcontracting: total invoice receipt value CK_LVREW_3CURR15(2) WERTV8
ZUKUMATotal quantity of goods received in period CK_ZUKUMQUAN15(3) MENGV8
ZUABW_1AReceipts: Single-level price differences CK_ZUABW_1CURR15(2) WERTV8
ZUABW_2AVariance to ML price CK_ZUABW_2CURR15(2) WERTV8
ZUABW_3AVariance to ML price CK_ZUABW_3CURR15(2) WERTV8
LVABW_1ASubcontrac.: var. from planned value of mat. to be provided CK_LVABW_1CURR15(2) WERTV8
LVABW_2ASubcontrac.: var. from planned value of mat. to be provided CK_LVABW_2CURR15(2) WERTV8
LVABW_3ASubcontrac.: var. from planned value of mat. to be provided CK_LVABW_3CURR15(2) WERTV8
LVWEKUMASubcontracting: total valuated quantity of goods received CK_LVWEKUMQUAN15(3) MENGV8
LVWEW_1ASubcontracting: value of goods received CK_LVWEW_1CURR15(2) WERTV8
LVWEW_2ASubcontracting: value of goods received CK_LVWEW_2CURR15(2) WERTV8
LVWEW_3ASubcontracting: value of goods received CK_LVWEW_3CURR15(2) WERTV8
ZUOME_1AAmount to be debited to material ledger price CK_ZUOME_1CURR15(2) WERTV8
ZUOME_2AAmount to be debited to material ledger price CK_ZUOME_2CURR15(2) WERTV8
ZUOME_3AAmount to be debited to material ledger price CK_ZUOME_3CURR15(2) WERTV8
ZUUMB_1ARevaluation Amount CK_ZUUMB_1CURR15(2) WERTV8
ZUUMB_2ARevaluation amount for material ledger price CK_ZUUMB_2CURR15(2) WERTV8
ZUUMB_3ARevaluation amount for material ledger price CK_ZUUMB_3CURR15(2) WERTV8
ZUOMP_1OTheoretical subsequent debit/credit price per price unit CK_ZUOMP_1CURR11(2) WERT11
ZUOMP_2OTheoretical subsequent debit/credit price per price unit CK_ZUOMP_2CURR11(2) WERT11
ZUOMP_3OTheoretical subsequent debit/credit price per price unit CK_ZUOMP_3CURR11(2) WERT11
ZUOMP_1ATheoretical subsequent debit/credit price per price unit CK_ZUOMP_1CURR11(2) WERT11
ZUOMP_2ATheoretical subsequent debit/credit price per price unit CK_ZUOMP_2CURR11(2) WERT11
ZUOMP_3ATheoretical subsequent debit/credit price per price unit CK_ZUOMP_3CURR11(2) WERT11
ZUOMMOCumulated quantity of subs. debit/credit in period CK_ZUOMMQUAN15(3) MENGV8
ZUOMMACumulated quantity of subs. debit/credit in period CK_ZUOMMQUAN15(3) MENGV8
PEINH_1Price unit CK_PEINH_1DEC5PACK3
PEINH_2Price unit for material ledger CK_PEINH_2DEC5PACK3
PEINH_3Price unit for material ledger CK_PEINH_3DEC5PACK3
UMKUMOQuantity posted to previous period CK_UMKUMQUAN15(3) MENGV8
UMKUMAQuantity posted to previous period CK_UMKUMQUAN15(3) MENGV8
WEKUMVATotal valuated GR quantity (carried forward) CK_WEKUMVQUAN15(3) MENGV8
WEWRT_1VATotal value of goods receipts (carried for.) CK_WEWV_1CURR15(2) WERTV8
WEWRT_2VATotal value of goods receipts (carried for.) CK_WEWV_2CURR15(2) WERTV8
WEWRT_3VATotal value of goods receipts (carried for.) CK_WEWV_3CURR15(2) WERTV8
REKUMVATotal valuted invoice receipt quantity (carried for.) CK_REKUMVQUAN15(3) MENGV8
REWRT_1VATotal invoice receipt value (carried for.) CK_REWV_1CURR15(2) WERTV8
REWRT_2VATotal invoice receipt value (carried for.) CK_REWV_2CURR15(2) WERTV8
REWRT_3VATotal invoice receipt value (carried for.) CK_REWV_3CURR15(2) WERTV8
LVWEKUMVASubcontracting: total valuated GR quantity (carried for.) CK_LWEKVQUAN15(3) MENGV8
LVWEW_1VASubcontracting: value of goods received (carried for.) CK_LWEWV_1CURR15(2) WERTV8
LVWEW_2VASubcontracting: value of goods received (carried for.) CK_LWEWV_2CURR15(2) WERTV8
LVWEW_3VASubcontracting: value of goods received (carried for.) CK_LWEWV_3CURR15(2) WERTV8
LVREKUMVASubcontracting: Total Valuated IR Quantity (Carryforward) CK_LREKVQUAN15(3) MENGV8
LVREW_1VASubcontracting: Total Invoice Receipt Value (Carryforward) CK_LREWV_1CURR15(2) WERTV8
LVREW_2VASubcontracting: Total Invoice Receipt Value (Carryforward) CK_LREWV_2CURR15(2) WERTV8
LVREW_3VASubcontracting: Total Invoice Receipt Value (Carryforward) CK_LREWV_3CURR15(2) WERTV8
ZPLPR_1Future planned price DZPLPRCURR11(2) WERT11
ZPLPR_2Future planned price DZPLPRCURR11(2) WERT11
ZPLPR_3Future planned price DZPLPRCURR11(2) WERT11
ZKPRS_1Future price DZKPRSCURR11(2) WERT11
ZKPRS_2Future price DZKPRSCURR11(2) WERT11
ZKPRS_3Future price DZKPRSCURR11(2) WERT11
XKONCHKSwitch off consistency check CK_XKONCHKCHAR1CK_XKONCHK
XINITIndicator: affected by initialization CK_XINITCHAR1CK_XINIT

Key field Non-key field



How do I retrieve data from SAP table CKML1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on CKML1 to SELECT all data from the table
DATA: WA_CKML1 TYPE CKML1.

SELECT SINGLE *
FROM CKML1
INTO CORRESPONDING FIELDS OF WA_CKML1
WHERE...

How to access SAP table CKML1

Within an ECC or HANA version of SAP you can also view further information about CKML1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).