CKMLRUNPERIOD

Transparent Table Application Table
54 Fields 3 CDS Views

Material ledger costing run for one month

CKMLRUNPERIOD is an SAP database table in S/4HANA. Material ledger costing run for one month. It contains 54 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FCMLRUNPERAVR_DDL view from CDS ML Alternative Valu. Runs/References
FCMLRUNPERAVR_DDL view inner CDS ML Alternative Valu. Runs/References
ML4H_CDS_VMV view left_outer Value Flow Monitor

Fields (54)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY run_id CKML_RUN_ID Int. CstngRunNo.
run_type CKML_RUN_TYPE Costing Run
last_day CKML_RUN_LAST_DAY_OF_PERIOD Last day
gjahr CKML_RUN_GJAHR Fiscal Year
poper CKML_RUN_POPER Posting periods
xshifted CKML_XSHIFTED_GJAHR Non-calendar fiscal year determined
loekz CKML_RUN_LOEKZ Deletion indicator for the ML costing run
usnam USNAM User Name
rctime CKML_RUN_RC_TIME Time
rcdate CKML_RUN_RC_DATE Date
mgtyp CKML_MGTYP QtyStruct. Type
appl CKML_RUN_APPL Application
untper CK_UNTPER Value Type
first_day CKML_RUN_FIRST_DAY_OF_PERIOD First day
from_poper CKML_RUN_POPER_BEGINNING Initial period
from_gjahr CKML_RUN_GJAHR_BEGINNING Initial year
mgtypz CKML_MGTYPZ Add. QtyStrType
ktext CKML_RUN_TEXT Costing Run
versn0 CKML_VERSN_LEGAL Price: Legal
versn1 CKML_VERSN_GROUP Price: Grp. Val.
versn2 CKML_VERSN_PC Price in PC Val.
prev_run_id CKML_PREV_RUN Previous Run
prkzg CK_PRICE_KZG Valuation Alt.
bwstrat CK_BWSTRAT Price
erdiff CKML_ER_DIFF Cum. ER Difference
xposting CK_AVR_POSTING Posting Run
xcreditcc CK_AVR_CREDITCC Credit Cost Center
curtp CURTP Crcy type/val.
aggregation CK_AGGREGATION Aggreg. Completed
komok KOMOK Account Modif.
reval_cons CKMLAVR_REVAL_CONS Reval. Cons.
xpcp CKMLAVR_PCP Rel. for Costing
acc_principle ACCOUNTING_PRINCIPLE Accounting Principle
pst_no_delta CKMLAVR_NO_DELTA_POSTING AVR Posting Logic
prelimprice CKMLAVR_PRELIMPRICE Provisional Price
with_succ_run CKMLAVR_POSTING_SUCCESSOR_RUN Posting Connect.Run
write_runscale CKMLAVR_WRITE_RUNSCALE Update CKMLRUNSCALE
xcogm_run CKMLAVR_COGM_RUN Par. COGM
valutyp CKML_VALUTYP Valuation Views
valusubtyp FINS_VALUSUBTYP Subtype Val
run_reference CKML_RUN_REFERENCE Run Reference
ref_type CKML_RUN_REFERENCE_TYPE Reference Type
ref_run_id CKML_RUN_ID Int. CstngRunNo.
rldnr ML4H_LEDGER Ledger
ldgrp FAGL_LDGRP Ledger Group
xreval ML4H_XREVAL Reval. Material
xcoacc ML4H_XCOACC Acc. Assignm. Cons.
xsimbadi CKML_XSIMBADI Value Modification
category FCOM_CATEGORY Plan Category
version ML4H_VERSION Version
tmpl_id CKML_RUN_ID Int. CstngRunNo.
date_from ML4H_DATE_FROM Valid From
xvcr ML4H_VCR VCR

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Material ledger costing run for one month
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKMLRUNPERIOD (
    MANDT,           -- Client [MANDT]
    RUN_ID,          -- Int. CstngRunNo. [CKML_RUN_ID]
    RUN_TYPE,        -- Costing Run [CKML_RUN_TYPE]
    LAST_DAY,        -- Last day [CKML_RUN_LAST_DAY_OF_PERIOD]
    GJAHR,           -- Fiscal Year [CKML_RUN_GJAHR]
    POPER,           -- Posting periods [CKML_RUN_POPER]
    XSHIFTED,        -- Non-calendar fiscal year determined [CKML_XSHIFTED_GJAHR]
    LOEKZ,           -- Deletion indicator for the ML costing run [CKML_RUN_LOEKZ]
    USNAM,           -- User Name [USNAM]
    RCTIME,          -- Time [CKML_RUN_RC_TIME]
    RCDATE,          -- Date [CKML_RUN_RC_DATE]
    MGTYP,           -- QtyStruct. Type [CKML_MGTYP]
    APPL,            -- Application [CKML_RUN_APPL]
    UNTPER,          -- Value Type [CK_UNTPER]
    FIRST_DAY,       -- First day [CKML_RUN_FIRST_DAY_OF_PERIOD]
    FROM_POPER,      -- Initial period [CKML_RUN_POPER_BEGINNING]
    FROM_GJAHR,      -- Initial year [CKML_RUN_GJAHR_BEGINNING]
    MGTYPZ,          -- Add. QtyStrType [CKML_MGTYPZ]
    KTEXT,           -- Costing Run [CKML_RUN_TEXT]
    VERSN0,          -- Price: Legal [CKML_VERSN_LEGAL]
    VERSN1,          -- Price: Grp. Val. [CKML_VERSN_GROUP]
    VERSN2,          -- Price in PC Val. [CKML_VERSN_PC]
    PREV_RUN_ID,     -- Previous Run [CKML_PREV_RUN]
    PRKZG,           -- Valuation Alt. [CK_PRICE_KZG]
    BWSTRAT,         -- Price [CK_BWSTRAT]
    ERDIFF,          -- Cum. ER Difference [CKML_ER_DIFF]
    XPOSTING,        -- Posting Run [CK_AVR_POSTING]
    XCREDITCC,       -- Credit Cost Center [CK_AVR_CREDITCC]
    CURTP,           -- Crcy type/val. [CURTP]
    AGGREGATION,     -- Aggreg. Completed [CK_AGGREGATION]
    KOMOK,           -- Account Modif. [KOMOK]
    REVAL_CONS,      -- Reval. Cons. [CKMLAVR_REVAL_CONS]
    XPCP,            -- Rel. for Costing [CKMLAVR_PCP]
    ACC_PRINCIPLE,   -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    PST_NO_DELTA,    -- AVR Posting Logic [CKMLAVR_NO_DELTA_POSTING]
    PRELIMPRICE,     -- Provisional Price [CKMLAVR_PRELIMPRICE]
    WITH_SUCC_RUN,   -- Posting Connect.Run [CKMLAVR_POSTING_SUCCESSOR_RUN]
    WRITE_RUNSCALE,  -- Update CKMLRUNSCALE [CKMLAVR_WRITE_RUNSCALE]
    XCOGM_RUN,       -- Par. COGM [CKMLAVR_COGM_RUN]
    VALUTYP,         -- Valuation Views [CKML_VALUTYP]
    VALUSUBTYP,      -- Subtype Val [FINS_VALUSUBTYP]
    RUN_REFERENCE,   -- Run Reference [CKML_RUN_REFERENCE]
    REF_TYPE,        -- Reference Type [CKML_RUN_REFERENCE_TYPE]
    REF_RUN_ID,      -- Int. CstngRunNo. [CKML_RUN_ID]
    RLDNR,           -- Ledger [ML4H_LEDGER]
    LDGRP,           -- Ledger Group [FAGL_LDGRP]
    XREVAL,          -- Reval. Material [ML4H_XREVAL]
    XCOACC,          -- Acc. Assignm. Cons. [ML4H_XCOACC]
    XSIMBADI,        -- Value Modification [CKML_XSIMBADI]
    CATEGORY,        -- Plan Category [FCOM_CATEGORY]
    VERSION,         -- Version [ML4H_VERSION]
    TMPL_ID,         -- Int. CstngRunNo. [CKML_RUN_ID]
    DATE_FROM,       -- Valid From [ML4H_DATE_FROM]
    XVCR,            -- VCR [ML4H_VCR]
    PRIMARY KEY (MANDT, RUN_ID)
);

Learn More