MSFS_MD

Transparent Table Application Table
11 Fields 1 CDS Views

Master Data Fields of Sales Order Stock with Vendor - Total

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
NSDM_E_MSFS view from MSFS Compatibility View

Fields (11)

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 vbeln vbeln SD Document
KEY posnr posnr Item
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 Sales Order Stock with Vendor - Total
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSFS_MD (
    MANDT,  -- Client [mandt]
    MATNR,  -- Material [matnr]
    WERKS,  -- Plant [werks_d]
    SOBKZ,  -- Special Stock [sobkz]
    LIFNR,  -- Supplier [lifnr]
    VBELN,  -- SD Document [vbeln]
    POSNR,  -- Item [posnr]
    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, VBELN, POSNR)
);

Learn More