MSIS_MD

Transparent Table Application Table
10 Fields 1 CDS Views

Master Data Fields of Vendor Stock with Vendor - Total

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
NSDM_E_MSIS view from MSIS Compatibility View

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY werks werks_d Plant
KEY sobkz sobkz Special Stock
KEY lifnr lifnr Supplier
KEY owner owner_d Owner of stock
ersda ersda Created On
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
xobew xobew Vendor stk val.

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 - Total
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSIS_MD (
    MANDT,  -- Client [mandt]
    MATNR,  -- Material [matnr]
    WERKS,  -- Plant [werks_d]
    SOBKZ,  -- Special Stock [sobkz]
    LIFNR,  -- Supplier [lifnr]
    OWNER,  -- Owner of stock [owner_d]
    ERSDA,  -- Created On [ersda]
    LFGJA,  -- Year Cur.Period [lfgja]
    LFMON,  -- Current Period [lfmon]
    XOBEW,  -- Vendor stk val. [xobew]
    PRIMARY KEY (MANDT, MATNR, WERKS, SOBKZ, LIFNR, OWNER)
);

Learn More