CKMLMV005

Transparent Table Application Table
13 Fields 2 CDS Views

Verbrauchsalternativen

CKMLMV005 is an SAP database table in S/4HANA. Verbrauchsalternativen. It contains 13 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 (13)

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.

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.

-- Verbrauchsalternativen
-- 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]
    PRIMARY KEY (MANDT, KALNR)
);

Learn More