CKMLMV005

Transparent Table Application Table
30 Fields 2 CDS Views

Consumption alternatives

CKMLMV005 is an SAP database table in S/4HANA. Consumption alternatives. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
Fcml_Proc_DDL view union_all CDS View with structure of table FCML_PROC
P_ConsuptionAlternative view from BASIC

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kalnr CKML_VALTNR Consumpt.Alter.
otyp CKML_OTYP Object Type
bwkey BWKEY Valuation Area
werks WERKS_D Plant
matnr MATNR Material
bwtar BWTAR_D Valuation Type
sobkz SOBKZ Special Stock
kalnr_mat CK_KALNR Cost EstimateNo
vtyp CKML_VTYP Consumpt. Type
sort_name CKML_SORT_NAME Sort String
nrule CKML_NAME_RULE Controlling Level
loekz CKML_LOEKZ Deletion Indic.
pwerk_nd WERKS_D Plant
pmatn_nd MATNR Material
kostl_nd KOSTL Cost Center
kdauf_nd KDAUF Sales Order
kdpos_nd KDPOS Sales Ord. Item
kunde_nd KUNAG Sold-to Party
pspnr_nd PS_PSP_PNR WBS Element
kstrg_nd KSTRG Cost Object
saknr_nd SAKNR G/L Account
objnr_nd CKML_OBJNR CO acc. ass.
prctr_nd PRCTR Profit Center
gsber_nd GSBER Business Area
bukrs_nd BUKRS Company Code
vbund_nd RASSC Trading Partner
spez_name_nd CKML_SPEZ_NAME User-Def. Name
ernam CKML_ERNAM Created By
erdat CKML_ERDAT Created On

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.

-- Consumption alternatives
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKMLMV005 (
    MANDT,         -- Client [MANDT]
    KALNR,         -- Consumpt.Alter. [CKML_VALTNR]
    OTYP,          -- Object Type [CKML_OTYP]
    BWKEY,         -- Valuation Area [BWKEY]
    WERKS,         -- Plant [WERKS_D]
    MATNR,         -- Material [MATNR]
    BWTAR,         -- Valuation Type [BWTAR_D]
    SOBKZ,         -- Special Stock [SOBKZ]
    KALNR_MAT,     -- Cost EstimateNo [CK_KALNR]
    VTYP,          -- Consumpt. Type [CKML_VTYP]
    SORT_NAME,     -- Sort String [CKML_SORT_NAME]
    NRULE,         -- Controlling Level [CKML_NAME_RULE]
    LOEKZ,         -- Deletion Indic. [CKML_LOEKZ]
    PWERK_ND,      -- Plant [WERKS_D]
    PMATN_ND,      -- Material [MATNR]
    KOSTL_ND,      -- Cost Center [KOSTL]
    KDAUF_ND,      -- Sales Order [KDAUF]
    KDPOS_ND,      -- Sales Ord. Item [KDPOS]
    KUNDE_ND,      -- Sold-to Party [KUNAG]
    PSPNR_ND,      -- WBS Element [PS_PSP_PNR]
    KSTRG_ND,      -- Cost Object [KSTRG]
    SAKNR_ND,      -- G/L Account [SAKNR]
    OBJNR_ND,      -- CO acc. ass. [CKML_OBJNR]
    PRCTR_ND,      -- Profit Center [PRCTR]
    GSBER_ND,      -- Business Area [GSBER]
    BUKRS_ND,      -- Company Code [BUKRS]
    VBUND_ND,      -- Trading Partner [RASSC]
    SPEZ_NAME_ND,  -- User-Def. Name [CKML_SPEZ_NAME]
    ERNAM,         -- Created By [CKML_ERNAM]
    ERDAT,         -- Created On [CKML_ERDAT]
    PRIMARY KEY (MANDT, KALNR)
);

Learn More