V_MSLB_MD

17 Fields 1 CDS Views

Generated Table for View

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

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 lifnr LIFNR Supplier
lbspr SPERR Phys. Inv. Blk
lbill KZILL Warehouse stock
lbilq KZILQ QualInspStock
lbvll KZVLL Warehouse stock
lbvlq KZVLQ QualInspStock
lbfll KZFLL Warehouse stock
lbflq KZFLQ QualInspStock
lbdll DLINL Last Count Date
ersda ERSDA Created On
lbjin GJINV Fiscal year of current physical inventory indicator
sgt_scat SGT_SCAT Stock Segment

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_MSLB_MD (
    MANDT,     -- Client [MANDT]
    MATNR,     -- Material [MATNR]
    WERKS,     -- Plant [WERKS_D]
    CHARG,     -- Batch [CHARG_D]
    SOBKZ,     -- Special Stock [SOBKZ]
    LIFNR,     -- Supplier [LIFNR]
    LBSPR,     -- Phys. Inv. Blk [SPERR]
    LBILL,     -- Warehouse stock [KZILL]
    LBILQ,     -- QualInspStock [KZILQ]
    LBVLL,     -- Warehouse stock [KZVLL]
    LBVLQ,     -- QualInspStock [KZVLQ]
    LBFLL,     -- Warehouse stock [KZFLL]
    LBFLQ,     -- QualInspStock [KZFLQ]
    LBDLL,     -- Last Count Date [DLINL]
    ERSDA,     -- Created On [ERSDA]
    LBJIN,     -- Fiscal year of current physical inventory indicator [GJINV]
    SGT_SCAT,  -- Stock Segment [SGT_SCAT]
    PRIMARY KEY (MANDT, MATNR, WERKS, CHARG, SOBKZ, LIFNR)
);

Learn More