NSDM_E_MKOL

CDS View
27 Fields 3 CDS Views

MKOL Compatibility View

NSDM_E_MKOL is a CDS View in S/4HANA. MKOL Compatibility View. It contains 27 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
NSDM_E_V_BF_MKOL view from V_BF_MKOL Compatibility View
NSDM_E_V_CF_MKOL view from V_CF_MKOL Compatibility View
NSDM_E_V_MMIM_KN view from V_MMIM_KN Compatibility View

Fields (27)

KeyField CDS FieldsUsed in Views
KEY charg charg 3
KEY lgort lgort 3
KEY lifnr lifnr 3
KEY mandt mandt 3
KEY matnr matnr 3
KEY sobkz sobkz 3
KEY werks werks 3
ersda ersda 1
kzisl kzill 1
kzisq kzilq 1
kziss kzils 1
kzvsl kzvll 1
kzvsq kzvlq 1
kzvss kzvls 1
lfgja lfgja 3
lfmon lfmon 3
lvorm lvorm,LVORM_0 3
seinm CEINM,einme 3
sgt_scat sgt_scat 1
sinsm CINSM,insme 3
slabs CLABS,labst 3
spers SPERC,sperr 2
sspem CSPEM,speme 3
svmei CVMEI,vmein 2
svmin CVMIN,vmins 2
svmla CVMLA,vmlab 2
svmsp CVMSP,vmspe 2

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.

-- MKOL Compatibility View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NSDM_E_MKOL (
    CHARG,
    LGORT,
    LIFNR,
    MANDT,
    MATNR,
    SOBKZ,
    WERKS,
    ERSDA,
    KZISL,
    KZISQ,
    KZISS,
    KZVSL,
    KZVSQ,
    KZVSS,
    LFGJA,
    LFMON,
    LVORM,
    SEINM,
    SGT_SCAT,
    SINSM,
    SLABS,
    SPERS,
    SSPEM,
    SVMEI,
    SVMIN,
    SVMLA,
    SVMSP,
    PRIMARY KEY (CHARG, LGORT, LIFNR, MANDT, MATNR, SOBKZ, WERKS)
);

Learn More