V_MCHB_MD

28 Fields 1 CDS Views

Generated Table for View

V_MCHB_MD is an SAP database table in S/4HANA. Generated Table for View. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
NSDM_DDL_CHK_MAT_MASTER view left_outer Chk for miss mat mast vs. MATDOC_EXTRACT

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY lgort LGORT_D Location
KEY charg CHARG_D Batch
lvorm LVOCB Stock del. flag
ersda ERSDA Created On
ernam ERNAM Created By
laeda LAEDA Last Change
aenam AENAM Changed By
sperc SPERR Phys. Inv. Blk
kzicl KZILL Warehouse stock
kzicq KZILQ QualInspStock
kzice KZILE Restricted-use
kzics KZILS Blocked stock
kzvcl KZVLL Warehouse stock
kzvcq KZVLQ QualInspStock
kzvce KZVLE Restricted use
kzvcs KZVLS Blocked stock
herkl HERKL C/R of Origin
chdll DLINL Last Count Date
chjin GJINV Fiscal year of current physical inventory indicator
sgt_scat SGT_SCAT Stock Segment
fsh_season_year FSH_SAISJ Season Year
fsh_season FSH_SAISO Season
fsh_collection FSH_COLLECTION Collection
fsh_theme FSH_THEME Theme
fsh_salloc_qty FSH_SALLOC_QTY Allocated Stock

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_MCHB_MD (
    MANDT,            -- Client [MANDT]
    MATNR,            -- Material [MATNR]
    WERKS,            -- Plant [WERKS_D]
    LGORT,            -- Location [LGORT_D]
    CHARG,            -- Batch [CHARG_D]
    LVORM,            -- Stock del. flag [LVOCB]
    ERSDA,            -- Created On [ERSDA]
    ERNAM,            -- Created By [ERNAM]
    LAEDA,            -- Last Change [LAEDA]
    AENAM,            -- Changed By [AENAM]
    SPERC,            -- Phys. Inv. Blk [SPERR]
    KZICL,            -- Warehouse stock [KZILL]
    KZICQ,            -- QualInspStock [KZILQ]
    KZICE,            -- Restricted-use [KZILE]
    KZICS,            -- Blocked stock [KZILS]
    KZVCL,            -- Warehouse stock [KZVLL]
    KZVCQ,            -- QualInspStock [KZVLQ]
    KZVCE,            -- Restricted use [KZVLE]
    KZVCS,            -- Blocked stock [KZVLS]
    HERKL,            -- C/R of Origin [HERKL]
    CHDLL,            -- Last Count Date [DLINL]
    CHJIN,            -- Fiscal year of current physical inventory indicator [GJINV]
    SGT_SCAT,         -- Stock Segment [SGT_SCAT]
    FSH_SEASON_YEAR,  -- Season Year [FSH_SAISJ]
    FSH_SEASON,       -- Season [FSH_SAISO]
    FSH_COLLECTION,   -- Collection [FSH_COLLECTION]
    FSH_THEME,        -- Theme [FSH_THEME]
    FSH_SALLOC_QTY,   -- Allocated Stock [FSH_SALLOC_QTY]
    PRIMARY KEY (MANDT, MATNR, WERKS, LGORT, CHARG)
);

Learn More