NSDM_E_MCHB

CDS View
37 Fields 6 CDS Views

MCHB Compatibility View

NSDM_E_MCHB is a CDS View in S/4HANA. MCHB Compatibility View. It contains 37 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
NSDM_E_V_BF_MARD view inner V_BF_MARD Compatibility View
NSDM_E_V_CF_MCHB view from V_CF_MCHB Compatibility View
NSDM_E_V_MMIM_LB view from V_MMIM_LB Compatibility View
NSDM_E_V_MMIM_LC view from V_MMIM_LC Compatibility View
NSDM_E_V_MMIM_LC_MB5M view from V_MMIM_LC_MB5M Compatibility View
NSDM_e_V_SLGH_2 view inner V_SLGH_2 Compatibility View

Fields (37)

KeyField CDS FieldsUsed in Views
KEY charg charg 5
KEY lgort lgort 6
KEY mandt mandt 6
KEY matnr matnr 6
KEY werks werks 6
/cwm/clabs cwmclabs 1
ceinm ceinm,EINME 5
chdll dlinl 2
chjin mdjin 2
cinsm cinsm,INSME 5
clabs clabs,LABST 6
cretm cretm,RETME 2
cspem cspem,SPEME 4
cumlm cumlm,UMLME 2
cvmei cvmei,VMEIN 2
cvmin cvmin,VMINS 2
cvmla cvmla,VMLAB 2
cvmre cvmre,VMRET 2
cvmsp cvmsp,VMSPE 2
cvmum cvmum,VMUML 2
ersda ersda 2
fsh_collection fsh_collection 1
fsh_salloc_qty fsh_salloc_qty 1
fsh_season fsh_season 1
fsh_season_year fsh_season_year 1
fsh_theme fsh_theme 1
kzicl kzicl,kzill 3
kzicq kzicq,kzilq 3
kzics kzils 2
kzvcl kzvll 2
kzvcq kzvlq 2
kzvcs kzvls 2
lfgja lfgja 4
lfmon lfmon 4
lvorm lvorm,lvorm_b 3
sgt_scat sgt_scat 1
sperc sperc,SPERR 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.

-- MCHB Compatibility View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NSDM_E_MCHB (
    CHARG,
    LGORT,
    MANDT,
    MATNR,
    WERKS,
    /CWM/CLABS,
    CEINM,
    CHDLL,
    CHJIN,
    CINSM,
    CLABS,
    CRETM,
    CSPEM,
    CUMLM,
    CVMEI,
    CVMIN,
    CVMLA,
    CVMRE,
    CVMSP,
    CVMUM,
    ERSDA,
    FSH_COLLECTION,
    FSH_SALLOC_QTY,
    FSH_SEASON,
    FSH_SEASON_YEAR,
    FSH_THEME,
    KZICL,
    KZICQ,
    KZICS,
    KZVCL,
    KZVCQ,
    KZVCS,
    LFGJA,
    LFMON,
    LVORM,
    SGT_SCAT,
    SPERC,
    PRIMARY KEY (CHARG, LGORT, MANDT, MATNR, WERKS)
);

Learn More