CKML1 SAP (Material Ledger Period Totals Records (Release 3.xx)) Table details
Dictionary Type: Table
Description: Material Ledger Period Totals Records (Release 3.xx)
Description: Material Ledger Period Totals Records (Release 3.xx)
Table field list including key, data, relationships and ABAP select examples
CKML1 is a standard SAP Table which is used to store Material Ledger Period Totals Records (Release 3.xx) data and is available within R/3 SAP systems 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. .
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
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
MATLED | Material ledger type | CK_MATLED | CHAR | 4 | TCKM1 | CK_MATLED | |||
BDATJ | Posting Date YYYY | BDATJ | NUMC | 4 | GJAHR | GJAHR | BDTJ | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
UNTPER | Value Structure Type | CK_UNTPER | NUMC | 3 | CK_UNTPER | ||||
STPRS_1 | Standard price | CK_STPRS_1 | CURR | 11(2) | WERT11 | ||||
STPRS_2 | Standard price | CK_STPRS_2 | CURR | 11(2) | WERT11 | ||||
STPRS_3 | Standard price | CK_STPRS_3 | CURR | 11(2) | WERT11 | ||||
PVPRS_1 | Periodic unit price | CK_PVPRS_1 | CURR | 11(2) | WERT11 | ||||
PVPRS_2 | Periodic unit price | CK_PVPRS_2 | CURR | 11(2) | WERT11 | ||||
PVPRS_3 | Periodic unit price | CK_PVPRS_3 | CURR | 11(2) | WERT11 | ||||
LBKUM | Total valuated stock | CK_LBKUM | QUAN | 15(3) | MENGV8 | ||||
SALK3_1 | Value of total valuated stock | CK_SALK3_1 | CURR | 15(2) | WERTV8 | ||||
SALK3_2 | Value of total valuated stock | CK_SALK3_2 | CURR | 15(2) | WERTV8 | ||||
SALK3_3 | Value of total valuated stock | CK_SALK3_3 | CURR | 15(2) | WERTV8 | ||||
SALKV_1 | Value based on the periodic unit price (only with pr.ctrl S) | CK_SALKV_1 | CURR | 15(2) | WERTV8 | ||||
SALKV_2 | Value based on the periodic unit price (only with pr.ctrl S) | CK_SALKV_2 | CURR | 15(2) | WERTV8 | ||||
SALKV_3 | Value based on the periodic unit price (only with pr.ctrl S) | CK_SALKV_3 | CURR | 15(2) | WERTV8 | ||||
KZ_ABGER | Material price will no longer be determined in this period | XABGER | CHAR | 1 | XABGER | ||||
.INCLU-O | 0 | ||||||||
WEKUMO | Total valuated qty of goods received in the period | CK_WEKUM | QUAN | 15(3) | MENGV8 | ||||
WEWRT_1O | Total value of goods receipts for period | CK_WEWRT_1 | CURR | 15(2) | WERTV8 | ||||
WEWRT_2O | Total value of goods receipts for period | CK_WEWRT_2 | CURR | 15(2) | WERTV8 | ||||
WEWRT_3O | Total value of goods receipts for period | CK_WEWRT_3 | CURR | 15(2) | WERTV8 | ||||
REKUMO | Total valuted invoice receipt quantity for the period | CK_REKUM | QUAN | 15(3) | MENGV8 | ||||
REWRT_1O | Total invoice receipt value of period | CK_REWRT_1 | CURR | 15(2) | WERTV8 | ||||
REWRT_2O | Total invoice receipt value of period | CK_REWRT_2 | CURR | 15(2) | WERTV8 | ||||
REWRT_3O | Total invoice receipt value of period | CK_REWRT_3 | CURR | 15(2) | WERTV8 | ||||
LVREKUMO | Subcontracting: total valuated invoice receipt quantity | CK_LVREKUM | QUAN | 15(3) | MENGV8 | ||||
LVREW_1O | Subcontracting: total invoice receipt value | CK_LVREW_1 | CURR | 15(2) | WERTV8 | ||||
LVREW_2O | Subcontracting: total invoice receipt value | CK_LVREW_2 | CURR | 15(2) | WERTV8 | ||||
LVREW_3O | Subcontracting: total invoice receipt value | CK_LVREW_3 | CURR | 15(2) | WERTV8 | ||||
ZUKUMO | Total quantity of goods received in period | CK_ZUKUM | QUAN | 15(3) | MENGV8 | ||||
ZUABW_1O | Receipts: Single-level price differences | CK_ZUABW_1 | CURR | 15(2) | WERTV8 | ||||
ZUABW_2O | Variance to ML price | CK_ZUABW_2 | CURR | 15(2) | WERTV8 | ||||
ZUABW_3O | Variance to ML price | CK_ZUABW_3 | CURR | 15(2) | WERTV8 | ||||
LVABW_1O | Subcontrac.: var. from planned value of mat. to be provided | CK_LVABW_1 | CURR | 15(2) | WERTV8 | ||||
LVABW_2O | Subcontrac.: var. from planned value of mat. to be provided | CK_LVABW_2 | CURR | 15(2) | WERTV8 | ||||
LVABW_3O | Subcontrac.: var. from planned value of mat. to be provided | CK_LVABW_3 | CURR | 15(2) | WERTV8 | ||||
LVWEKUMO | Subcontracting: total valuated quantity of goods received | CK_LVWEKUM | QUAN | 15(3) | MENGV8 | ||||
LVWEW_1O | Subcontracting: value of goods received | CK_LVWEW_1 | CURR | 15(2) | WERTV8 | ||||
LVWEW_2O | Subcontracting: value of goods received | CK_LVWEW_2 | CURR | 15(2) | WERTV8 | ||||
LVWEW_3O | Subcontracting: value of goods received | CK_LVWEW_3 | CURR | 15(2) | WERTV8 | ||||
ZUOME_1O | Amount to be debited to material ledger price | CK_ZUOME_1 | CURR | 15(2) | WERTV8 | ||||
ZUOME_2O | Amount to be debited to material ledger price | CK_ZUOME_2 | CURR | 15(2) | WERTV8 | ||||
ZUOME_3O | Amount to be debited to material ledger price | CK_ZUOME_3 | CURR | 15(2) | WERTV8 | ||||
ZUUMB_1O | Revaluation Amount | CK_ZUUMB_1 | CURR | 15(2) | WERTV8 | ||||
ZUUMB_2O | Revaluation amount for material ledger price | CK_ZUUMB_2 | CURR | 15(2) | WERTV8 | ||||
ZUUMB_3O | Revaluation amount for material ledger price | CK_ZUUMB_3 | CURR | 15(2) | WERTV8 | ||||
LVPVP_1 | Subcontracting: periodic unit price (PUP) | CK_LVPVP_1 | CURR | 11(2) | WERT11 | ||||
LVPVP_2 | Subcontracting: periodic unit price (PUP) | CK_LVPVP_2 | CURR | 11(2) | WERT11 | ||||
LVPVP_3 | Subcontracting: periodic unit price (PUP) | CK_LVPVP_3 | CURR | 11(2) | WERT11 | ||||
.INCLU-A | 0 | ||||||||
WEKUMA | Total valuated qty of goods received in the period | CK_WEKUM | QUAN | 15(3) | MENGV8 | ||||
WEWRT_1A | Total value of goods receipts for period | CK_WEWRT_1 | CURR | 15(2) | WERTV8 | ||||
WEWRT_2A | Total value of goods receipts for period | CK_WEWRT_2 | CURR | 15(2) | WERTV8 | ||||
WEWRT_3A | Total value of goods receipts for period | CK_WEWRT_3 | CURR | 15(2) | WERTV8 | ||||
REKUMA | Total valuted invoice receipt quantity for the period | CK_REKUM | QUAN | 15(3) | MENGV8 | ||||
REWRT_1A | Total invoice receipt value of period | CK_REWRT_1 | CURR | 15(2) | WERTV8 | ||||
REWRT_2A | Total invoice receipt value of period | CK_REWRT_2 | CURR | 15(2) | WERTV8 | ||||
REWRT_3A | Total invoice receipt value of period | CK_REWRT_3 | CURR | 15(2) | WERTV8 | ||||
LVREKUMA | Subcontracting: total valuated invoice receipt quantity | CK_LVREKUM | QUAN | 15(3) | MENGV8 | ||||
LVREW_1A | Subcontracting: total invoice receipt value | CK_LVREW_1 | CURR | 15(2) | WERTV8 | ||||
LVREW_2A | Subcontracting: total invoice receipt value | CK_LVREW_2 | CURR | 15(2) | WERTV8 | ||||
LVREW_3A | Subcontracting: total invoice receipt value | CK_LVREW_3 | CURR | 15(2) | WERTV8 | ||||
ZUKUMA | Total quantity of goods received in period | CK_ZUKUM | QUAN | 15(3) | MENGV8 | ||||
ZUABW_1A | Receipts: Single-level price differences | CK_ZUABW_1 | CURR | 15(2) | WERTV8 | ||||
ZUABW_2A | Variance to ML price | CK_ZUABW_2 | CURR | 15(2) | WERTV8 | ||||
ZUABW_3A | Variance to ML price | CK_ZUABW_3 | CURR | 15(2) | WERTV8 | ||||
LVABW_1A | Subcontrac.: var. from planned value of mat. to be provided | CK_LVABW_1 | CURR | 15(2) | WERTV8 | ||||
LVABW_2A | Subcontrac.: var. from planned value of mat. to be provided | CK_LVABW_2 | CURR | 15(2) | WERTV8 | ||||
LVABW_3A | Subcontrac.: var. from planned value of mat. to be provided | CK_LVABW_3 | CURR | 15(2) | WERTV8 | ||||
LVWEKUMA | Subcontracting: total valuated quantity of goods received | CK_LVWEKUM | QUAN | 15(3) | MENGV8 | ||||
LVWEW_1A | Subcontracting: value of goods received | CK_LVWEW_1 | CURR | 15(2) | WERTV8 | ||||
LVWEW_2A | Subcontracting: value of goods received | CK_LVWEW_2 | CURR | 15(2) | WERTV8 | ||||
LVWEW_3A | Subcontracting: value of goods received | CK_LVWEW_3 | CURR | 15(2) | WERTV8 | ||||
ZUOME_1A | Amount to be debited to material ledger price | CK_ZUOME_1 | CURR | 15(2) | WERTV8 | ||||
ZUOME_2A | Amount to be debited to material ledger price | CK_ZUOME_2 | CURR | 15(2) | WERTV8 | ||||
ZUOME_3A | Amount to be debited to material ledger price | CK_ZUOME_3 | CURR | 15(2) | WERTV8 | ||||
ZUUMB_1A | Revaluation Amount | CK_ZUUMB_1 | CURR | 15(2) | WERTV8 | ||||
ZUUMB_2A | Revaluation amount for material ledger price | CK_ZUUMB_2 | CURR | 15(2) | WERTV8 | ||||
ZUUMB_3A | Revaluation amount for material ledger price | CK_ZUUMB_3 | CURR | 15(2) | WERTV8 | ||||
ZUOMP_1O | Theoretical subsequent debit/credit price per price unit | CK_ZUOMP_1 | CURR | 11(2) | WERT11 | ||||
ZUOMP_2O | Theoretical subsequent debit/credit price per price unit | CK_ZUOMP_2 | CURR | 11(2) | WERT11 | ||||
ZUOMP_3O | Theoretical subsequent debit/credit price per price unit | CK_ZUOMP_3 | CURR | 11(2) | WERT11 | ||||
ZUOMP_1A | Theoretical subsequent debit/credit price per price unit | CK_ZUOMP_1 | CURR | 11(2) | WERT11 | ||||
ZUOMP_2A | Theoretical subsequent debit/credit price per price unit | CK_ZUOMP_2 | CURR | 11(2) | WERT11 | ||||
ZUOMP_3A | Theoretical subsequent debit/credit price per price unit | CK_ZUOMP_3 | CURR | 11(2) | WERT11 | ||||
ZUOMMO | Cumulated quantity of subs. debit/credit in period | CK_ZUOMM | QUAN | 15(3) | MENGV8 | ||||
ZUOMMA | Cumulated quantity of subs. debit/credit in period | CK_ZUOMM | QUAN | 15(3) | MENGV8 | ||||
PEINH_1 | Price unit | CK_PEINH_1 | DEC | 5 | PACK3 | ||||
PEINH_2 | Price unit for material ledger | CK_PEINH_2 | DEC | 5 | PACK3 | ||||
PEINH_3 | Price unit for material ledger | CK_PEINH_3 | DEC | 5 | PACK3 | ||||
UMKUMO | Quantity posted to previous period | CK_UMKUM | QUAN | 15(3) | MENGV8 | ||||
UMKUMA | Quantity posted to previous period | CK_UMKUM | QUAN | 15(3) | MENGV8 | ||||
WEKUMVA | Total valuated GR quantity (carried forward) | CK_WEKUMV | QUAN | 15(3) | MENGV8 | ||||
WEWRT_1VA | Total value of goods receipts (carried for.) | CK_WEWV_1 | CURR | 15(2) | WERTV8 | ||||
WEWRT_2VA | Total value of goods receipts (carried for.) | CK_WEWV_2 | CURR | 15(2) | WERTV8 | ||||
WEWRT_3VA | Total value of goods receipts (carried for.) | CK_WEWV_3 | CURR | 15(2) | WERTV8 | ||||
REKUMVA | Total valuted invoice receipt quantity (carried for.) | CK_REKUMV | QUAN | 15(3) | MENGV8 | ||||
REWRT_1VA | Total invoice receipt value (carried for.) | CK_REWV_1 | CURR | 15(2) | WERTV8 | ||||
REWRT_2VA | Total invoice receipt value (carried for.) | CK_REWV_2 | CURR | 15(2) | WERTV8 | ||||
REWRT_3VA | Total invoice receipt value (carried for.) | CK_REWV_3 | CURR | 15(2) | WERTV8 | ||||
LVWEKUMVA | Subcontracting: total valuated GR quantity (carried for.) | CK_LWEKV | QUAN | 15(3) | MENGV8 | ||||
LVWEW_1VA | Subcontracting: value of goods received (carried for.) | CK_LWEWV_1 | CURR | 15(2) | WERTV8 | ||||
LVWEW_2VA | Subcontracting: value of goods received (carried for.) | CK_LWEWV_2 | CURR | 15(2) | WERTV8 | ||||
LVWEW_3VA | Subcontracting: value of goods received (carried for.) | CK_LWEWV_3 | CURR | 15(2) | WERTV8 | ||||
LVREKUMVA | Subcontracting: Total Valuated IR Quantity (Carryforward) | CK_LREKV | QUAN | 15(3) | MENGV8 | ||||
LVREW_1VA | Subcontracting: Total Invoice Receipt Value (Carryforward) | CK_LREWV_1 | CURR | 15(2) | WERTV8 | ||||
LVREW_2VA | Subcontracting: Total Invoice Receipt Value (Carryforward) | CK_LREWV_2 | CURR | 15(2) | WERTV8 | ||||
LVREW_3VA | Subcontracting: Total Invoice Receipt Value (Carryforward) | CK_LREWV_3 | CURR | 15(2) | WERTV8 | ||||
ZPLPR_1 | Future planned price | DZPLPR | CURR | 11(2) | WERT11 | ||||
ZPLPR_2 | Future planned price | DZPLPR | CURR | 11(2) | WERT11 | ||||
ZPLPR_3 | Future planned price | DZPLPR | CURR | 11(2) | WERT11 | ||||
ZKPRS_1 | Future price | DZKPRS | CURR | 11(2) | WERT11 | ||||
ZKPRS_2 | Future price | DZKPRS | CURR | 11(2) | WERT11 | ||||
ZKPRS_3 | Future price | DZKPRS | CURR | 11(2) | WERT11 | ||||
XKONCHK | Switch off consistency check | CK_XKONCHK | CHAR | 1 | CK_XKONCHK | ||||
XINIT | Indicator: affected by initialization | CK_XINIT | CHAR | 1 | CK_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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects