CKMLMV001

Transparent Table Application Table
44 Fields 4 CDS Views

Procurement alternatives

CKMLMV001 is an SAP database table in S/4HANA. Procurement alternatives. It contains 44 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
R_EvtBsdRptvMfgProdnProcess view from BASIC Repetitive Manufacturing Production Process

Fields (44)

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.
prwrk_nd WERKS_D Plant
plwrk_nd CO_PWERK Planning Plant
pmatn_nd MATNR Material
verid_nd VERID Prod. Version
stlan_nd STLAN Usage
stlal_nd STALT Alternative
plnty_nd PLNTY Task List Type
plnnr_nd PLNNR Group
plnal_nd PLNAL Group Counter
ekorg_nd EKORG Purchasing Org.
lifnr_nd ELIFN Supplier
umlwk_nd CK_SOWRK SpclPrcmntPlant
umlma_nd MATNR Material
kdauf_nd VBELN SD Document
kdpos_nd KDPOS Sales Ord. Item
kunde_nd KUNNR Customer
pspnr_nd PS_POSNR WBS Element
spez_name_nd CKML_SPEZ_NAME User-Def. Name
stlan_pc STLAN Usage
stlal_pc STALT Alternative
losgr_pc CK_LOSGR Cstg Lot Size
meins_pc CK_MEINH_BEW Valuation Unit
csplit_pc CSPLIT Apportionment
ernam CKML_ERNAM Created By
erdat CKML_ERDAT Created On
logsystem_sender LOGSYSTEM_SENDER Sender Log Sys.
kalnr_sender CKML_ALPROCNR_SENDER SenderProcAlt/Proc

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.

-- Procurement alternatives
-- 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]
    PRWRK_ND,          -- Plant [WERKS_D]
    PLWRK_ND,          -- Planning Plant [CO_PWERK]
    PMATN_ND,          -- Material [MATNR]
    VERID_ND,          -- Prod. Version [VERID]
    STLAN_ND,          -- Usage [STLAN]
    STLAL_ND,          -- Alternative [STALT]
    PLNTY_ND,          -- Task List Type [PLNTY]
    PLNNR_ND,          -- Group [PLNNR]
    PLNAL_ND,          -- Group Counter [PLNAL]
    EKORG_ND,          -- Purchasing Org. [EKORG]
    LIFNR_ND,          -- Supplier [ELIFN]
    UMLWK_ND,          -- SpclPrcmntPlant [CK_SOWRK]
    UMLMA_ND,          -- Material [MATNR]
    KDAUF_ND,          -- SD Document [VBELN]
    KDPOS_ND,          -- Sales Ord. Item [KDPOS]
    KUNDE_ND,          -- Customer [KUNNR]
    PSPNR_ND,          -- WBS Element [PS_POSNR]
    SPEZ_NAME_ND,      -- User-Def. Name [CKML_SPEZ_NAME]
    STLAN_PC,          -- Usage [STLAN]
    STLAL_PC,          -- Alternative [STALT]
    LOSGR_PC,          -- Cstg Lot Size [CK_LOSGR]
    MEINS_PC,          -- Valuation Unit [CK_MEINH_BEW]
    CSPLIT_PC,         -- Apportionment [CSPLIT]
    ERNAM,             -- Created By [CKML_ERNAM]
    ERDAT,             -- Created On [CKML_ERDAT]
    LOGSYSTEM_SENDER,  -- Sender Log Sys. [LOGSYSTEM_SENDER]
    KALNR_SENDER,      -- SenderProcAlt/Proc [CKML_ALPROCNR_SENDER]
    PRIMARY KEY (MANDT, KALNR)
);

Learn More