V_MSKU_MD

22 Fields 1 CDS Views

Generated Table for View

V_MSKU_MD is an SAP database table in S/4HANA. Generated Table for View. It contains 22 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 (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY charg CHARG_D Batch
KEY sobkz SOBKZ Special Stock
KEY kunnr KUNNR Customer
kuspr SPERR Phys. Inv. Blk
kuill KZILL Warehouse stock
kuilq KZILQ QualInspStock
kuvll KZVLL Warehouse stock
kuvlq KZVLQ QualInspStock
kufll KZFLL Warehouse stock
kuflq KZFLQ QualInspStock
kudll DLINL Last Count Date
ersda ERSDA Created On
kujin 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_MSKU_MD (
    MANDT,            -- Client [MANDT]
    MATNR,            -- Material [MATNR]
    WERKS,            -- Plant [WERKS_D]
    CHARG,            -- Batch [CHARG_D]
    SOBKZ,            -- Special Stock [SOBKZ]
    KUNNR,            -- Customer [KUNNR]
    KUSPR,            -- Phys. Inv. Blk [SPERR]
    KUILL,            -- Warehouse stock [KZILL]
    KUILQ,            -- QualInspStock [KZILQ]
    KUVLL,            -- Warehouse stock [KZVLL]
    KUVLQ,            -- QualInspStock [KZVLQ]
    KUFLL,            -- Warehouse stock [KZFLL]
    KUFLQ,            -- QualInspStock [KZFLQ]
    KUDLL,            -- Last Count Date [DLINL]
    ERSDA,            -- Created On [ERSDA]
    KUJIN,            -- 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, CHARG, SOBKZ, KUNNR)
);

Learn More