MSID_MD

Transparent Table Application Table
19 Fields 1 CDS Views

Master Data Fields of Vendor Stock with Vendor

MSID_MD is an SAP database table in S/4HANA. Master Data Fields of Vendor Stock with Vendor. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
NSDM_E_MSID view from MSID Compatibility View

Fields (19)

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
KEY owner owner_d Owner of stock
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
idspr sperr Phys. Inv. Blk
idill kzill Warehouse stock
idilq kzilq QualInspStock
idvll kzvll Warehouse stock
idvlq kzvlq QualInspStock
idfll kzfll Warehouse stock
idflq kzflq QualInspStock
iddll dlinl Last Count Date
ersda ersda Created On
idjin gjinv Fiscal year of current physical inventory indicator

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.

-- Master Data Fields of Vendor Stock with Vendor
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSID_MD (
    MANDT,  -- Client [mandt]
    MATNR,  -- Material [matnr]
    WERKS,  -- Plant [werks_d]
    CHARG,  -- Batch [charg_d]
    SOBKZ,  -- Special Stock [sobkz]
    LIFNR,  -- Supplier [lifnr]
    OWNER,  -- Owner of stock [owner_d]
    LFGJA,  -- Year Cur.Period [lfgja]
    LFMON,  -- Current Period [lfmon]
    IDSPR,  -- Phys. Inv. Blk [sperr]
    IDILL,  -- Warehouse stock [kzill]
    IDILQ,  -- QualInspStock [kzilq]
    IDVLL,  -- Warehouse stock [kzvll]
    IDVLQ,  -- QualInspStock [kzvlq]
    IDFLL,  -- Warehouse stock [kzfll]
    IDFLQ,  -- QualInspStock [kzflq]
    IDDLL,  -- Last Count Date [dlinl]
    ERSDA,  -- Created On [ersda]
    IDJIN,  -- Fiscal year of current physical inventory indicator [gjinv]
    PRIMARY KEY (MANDT, MATNR, WERKS, CHARG, SOBKZ, LIFNR, OWNER)
);

Learn More