CKMLMV001

Transparent Table Application Table
17 Fields 4 CDS Views

Beschaffungsalternativen

CKMLMV001 is an SAP database table in S/4HANA. Beschaffungsalternativen. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Fcml_Proc_DDL view from CDS View with structure of table FCML_PROC
Fcml_Proc_DDL view union_all CDS View with structure of table FCML_PROC
P_ProcurementAlternative view from BASIC Procurement Alternatives
R_EvtBsdRptvMfgProdnProcess view from BASIC Repetitive Manufacturing Production Process

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kalnr ckml_alprocnr PrcrmntAlt/Proc
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
btyp ckml_btyp Process Cat.
flg_procequal ckml_flg_procequal Process Same
flg_planobj ckml_flg_planobj Planning Object
proc_kalnr ckml_n_procnr Procurement proc.
main_process ckml_n_procnr Procurement proc.
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.

-- Beschaffungsalternativen
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKMLMV001 (
    MANDT,          -- Client [mandt]
    KALNR,          -- PrcrmntAlt/Proc [ckml_alprocnr]
    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]
    BTYP,           -- Process Cat. [ckml_btyp]
    FLG_PROCEQUAL,  -- Process Same [ckml_flg_procequal]
    FLG_PLANOBJ,    -- Planning Object [ckml_flg_planobj]
    PROC_KALNR,     -- Procurement proc. [ckml_n_procnr]
    MAIN_PROCESS,   -- Procurement proc. [ckml_n_procnr]
    SORT_NAME,      -- Sort String [ckml_sort_name]
    NRULE,          -- Controlling Level [ckml_name_rule]
    LOEKZ,          -- Deletion Indic. [ckml_loekz]
    PRIMARY KEY (MANDT, KALNR)
);

Learn More