V_MSKA_MD

27 Fields 1 CDS Views

Generated Table for View

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

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
KEY sobkz SOBKZ Special Stock
KEY vbeln VBELN SD Document
KEY posnr POSNR Item
kaspr SPERR Phys. Inv. Blk
kaill KZILL Warehouse stock
kailq KZILQ QualInspStock
kails KZILS Blocked stock
kavll KZVLL Warehouse stock
kavlq KZVLQ QualInspStock
kavls KZVLS Blocked stock
kafll KZFLL Warehouse stock
kaflq KZFLQ QualInspStock
kafls KZFLS Blocked stock
kadll DLINL Last Count Date
ersda ERSDA Created On
kajin 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_MSKA_MD (
    MANDT,            -- Client [MANDT]
    MATNR,            -- Material [MATNR]
    WERKS,            -- Plant [WERKS_D]
    LGORT,            -- Location [LGORT_D]
    CHARG,            -- Batch [CHARG_D]
    SOBKZ,            -- Special Stock [SOBKZ]
    VBELN,            -- SD Document [VBELN]
    POSNR,            -- Item [POSNR]
    KASPR,            -- Phys. Inv. Blk [SPERR]
    KAILL,            -- Warehouse stock [KZILL]
    KAILQ,            -- QualInspStock [KZILQ]
    KAILS,            -- Blocked stock [KZILS]
    KAVLL,            -- Warehouse stock [KZVLL]
    KAVLQ,            -- QualInspStock [KZVLQ]
    KAVLS,            -- Blocked stock [KZVLS]
    KAFLL,            -- Warehouse stock [KZFLL]
    KAFLQ,            -- QualInspStock [KZFLQ]
    KAFLS,            -- Blocked stock [KZFLS]
    KADLL,            -- Last Count Date [DLINL]
    ERSDA,            -- Created On [ERSDA]
    KAJIN,            -- 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, SOBKZ, VBELN, POSNR)
);

Learn More