SAP Table CKMLRUNPERIOD

Material ledger costing run for one month

CKMLRUNPERIOD (Material ledger costing run for one month) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CKMLRUNPERIOD to other SAP tables.

CKMLRUNPERIOD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RUN_ID Number of Costing Runs for Material Ledger CKML_RUN_ID NUMC 12 0
RUN_TYPE Costing Run in Actual Costing CKML_RUN_TYPE CHAR 8 0
LAST_DAY Last day of period CKML_RUN_LAST_DAY_OF_PERIOD DATS 8 0
GJAHR Fiscal Year CKML_RUN_GJAHR NUMC 4 0
POPER Posting period CKML_RUN_POPER NUMC 3 0
XSHIFTED Non-calendar fiscal year determined CKML_XSHIFTED_GJAHR CHAR 1 0
X TRUE
NULL FALSE
LOEKZ Deletion indicator for the ML costing run CKML_RUN_LOEKZ CHAR 1 0
X TRUE
NULL FALSE
USNAM User name USNAM CHAR 12 0
RCTIME Time of creation or time of last change CKML_RUN_RC_TIME TIMS 6 0
RCDATE Creation date or date of last change CKML_RUN_RC_DATE DATS 8 0
MGTYP Quantity Structure Type CKML_MGTYP CKMLMV006 CHAR 5 0
APPL Material Ledger Costing Run Application CKML_RUN_APPL CHAR 4 0
ACRU Actual Costing
CUM Alternative Valuation
UNTPER Value Structure Type CK_UNTPER NUMC 3 0
FIRST_DAY First day of period CKML_RUN_FIRST_DAY_OF_PERIOD DATS 8 0
FROM_POPER Initial Period in a Cumulation CKML_RUN_POPER_BEGINNING NUMC 3 0
FROM_GJAHR Initial Fiscal Year of a Cumulation CKML_RUN_GJAHR_BEGINNING NUMC 4 0
MGTYPZ Additional Quantity Structure Type CKML_MGTYPZ CHAR 5 0
KTEXT Long Name of a Costing Run CKML_RUN_TEXT CHAR 80 0
VERSN0 Version for Price for Cumulation in Legal Valuation CKML_VERSN_LEGAL CHAR 3 0
VERSN1 Version for Activity Price for Cumulation in Group Valuation CKML_VERSN_GROUP CHAR 3 0
VERSN2 Version for Price for Kumulation in Profit Center Valuation CKML_VERSN_PC CHAR 3 0
PREV_RUN_ID Run previous to the current run CKML_PREV_RUN NUMC 12 0
PRKZG Price Name for Ending Inventory/Balance Sheet Valuation CK_PRICE_KZG TCKMLPR_EB CHAR 3 0
BWSTRAT Price for Activity Valuation CK_BWSTRAT CHAR 1 0
1 Plan price for the period
2 Plan price as average of all fiscal year periods
3 Plan price as average of remaining periods of fiscal year
4 Actual price of prior period
5 Most up-to-date actual price in the past
6 Most up-to-date plan price
7 Actual price for the period
8 External actual price
9 Frozen price (material ledger)
ERDIFF Cumulation of Exchange Rate Differences CKML_ER_DIFF CHAR 1 0
NULL Cumulate Exchange Rate Differences Normally
1 Show Non-Inventory Relevant Exchange Rate Differences
2 Hide All Exchange Rate Differences
XPOSTING Indicator: Valuation Relevant Run CK_AVR_POSTING CHAR 1 0
X TRUE
NULL FALSE
XCREDITCC Indicator: Credit Cost Center using Closing Entry CK_AVR_CREDITCC CHAR 1 0
X Yes
NULL No
CURTP Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
AGGREGATION Aggregation was completed CK_AGGREGATION CHAR 1 0
X Yes
NULL No
KOMOK Account Modification KOMOK CHAR 3 0
REVAL_CONS Run Relevant for Revaluation of Consumption CKMLAVR_REVAL_CONS CHAR 1 0
X Yes
NULL No
XPCP Relevant for Costing CKMLAVR_PCP CHAR 1 0
X Yes
NULL No
ACC_PRINCIPLE Accounting Principle ACCOUNTING_PRINCIPLE TACC_PRINCIPLE CHAR 4 0
PST_NO_DELTA AVR Posting Logic CKMLAVR_NO_DELTA_POSTING CHAR 1 0
P Posting Logic Analogous to Periodic Closing Entry
D Delta Posting Logic (Conventional AVR Posting Logic)
PRELIMPRICE Origin of Provisional Price for the Cumulation of the AVRs CKMLAVR_PRELIMPRICE CHAR 3 0
E Price for the first cumulation period
L Price for the last cumulation period
WITH_SUCC_RUN Posting Connecting Run Exists CKMLAVR_POSTING_SUCCESSOR_RUN CHAR 1 0
X TRUE
NULL FALSE
WRITE_RUNSCALE Update of Price Differences in CKMLRUNSCALE CKMLAVR_WRITE_RUNSCALE CHAR 1 0
X TRUE
NULL FALSE
XCOGM_RUN Indicator: Run for Parallel Cost of Goods Manufactured CKMLAVR_COGM_RUN CHAR 1 0
X Yes
NULL No

CKMLRUNPERIOD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKMLRUNPERIOD ACC_PRINCIPLE CKMLRUNPERIOD ACC_PRINCIPLE TACC_PRINCIPLE Accounting Principle ACC_PRINCIPLE
CKMLRUNPERIOD ACC_PRINCIPLE CKMLRUNPERIOD MANDT TACC_PRINCIPLE Accounting Principle MANDT
CKMLRUNPERIOD MANDT CKMLRUNPERIOD MANDT T000 Clients MANDT
CKMLRUNPERIOD MGTYP CKMLRUNPERIOD MANDT CKMLMV006 Control data for the quantity structure types MANDT
CKMLRUNPERIOD MGTYP CKMLRUNPERIOD MGTYP CKMLMV006 Control data for the quantity structure types MGTYP
CKMLRUNPERIOD PRKZG CKMLRUNPERIOD MANDT TCKMLPR_EB Customizing for Bal. Sheet Valuation: Define Valuation Areas MANDT
CKMLRUNPERIOD PRKZG CKMLRUNPERIOD PRKZG TCKMLPR_EB Customizing for Bal. Sheet Valuation: Define Valuation Areas PRKZG