CKMLLACRLD

Transparent Table Application Table
20 Fields 2 CDS Views

ML Activity Type: Period Record/Currency Record

CKMLLACRLD is an SAP database table in S/4HANA. ML Activity Type: Period Record/Currency Record. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FMLV_CKMLLACR_UCT view from ML Activity Type: Period Record/Currency Record
FMLV_CKMLLACR_UCT_UNION view from ML Activity Type: Period Record/Currency Record

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kalnr CK_KALNR Cost EstimateNo
KEY bdatj BDATJ Year
KEY poper POPER Posting Period
KEY untper CK_UNTPER Value Type
KEY ext_curtype FINS_EXT_CURTYPE Crcy Type/Valn View
KEY rldnr FINS_LEDGER Ledger
togbtr CKML_PRICE Basic Rate Tot.
tofbtr CKML_PRICE_FIX Fixed Basic Rt.
togbtrd TOGDELTA Price Delta
toe TOEXXX Price unit OCrcy
waers WAERS Currency
togbtr_s CKML_PRICE Basic Rate Tot.
tofbtr_s CKML_PRICE_FIX Fixed Basic Rt.
togbtrd_s TOGDELTA Price Delta
toe_s TOEXXX Price unit OCrcy
waers_s WAERS Currency
bwstrat BWSTRAT Val.strategy
no_settle CKML_NO_SETTLE Do Not Consider
saprl SYSAPRL SAP Release

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.

-- ML Activity Type: Period Record/Currency Record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKMLLACRLD (
    MANDT,        -- Client [MANDT]
    KALNR,        -- Cost EstimateNo [CK_KALNR]
    BDATJ,        -- Year [BDATJ]
    POPER,        -- Posting Period [POPER]
    UNTPER,       -- Value Type [CK_UNTPER]
    EXT_CURTYPE,  -- Crcy Type/Valn View [FINS_EXT_CURTYPE]
    RLDNR,        -- Ledger [FINS_LEDGER]
    TOGBTR,       -- Basic Rate Tot. [CKML_PRICE]
    TOFBTR,       -- Fixed Basic Rt. [CKML_PRICE_FIX]
    TOGBTRD,      -- Price Delta [TOGDELTA]
    TOE,          -- Price unit OCrcy [TOEXXX]
    WAERS,        -- Currency [WAERS]
    TOGBTR_S,     -- Basic Rate Tot. [CKML_PRICE]
    TOFBTR_S,     -- Fixed Basic Rt. [CKML_PRICE_FIX]
    TOGBTRD_S,    -- Price Delta [TOGDELTA]
    TOE_S,        -- Price unit OCrcy [TOEXXX]
    WAERS_S,      -- Currency [WAERS]
    BWSTRAT,      -- Val.strategy [BWSTRAT]
    NO_SETTLE,    -- Do Not Consider [CKML_NO_SETTLE]
    SAPRL,        -- SAP Release [SYSAPRL]
    PRIMARY KEY (MANDT, KALNR, BDATJ, POPER, UNTPER, EXT_CURTYPE, RLDNR)
);

Learn More