MSCD_MD

Transparent Table Application Table
19 Fields 1 CDS Views

Master Data Fields of Customer Stock with Vendor

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
NSDM_E_MSCD view from MSCD 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 kunnr kunnr Customer
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
cdspr sperr Phys. Inv. Blk
cdill kzill Warehouse stock
cdilq kzilq QualInspStock
cdvll kzvll Warehouse stock
cdvlq kzvlq QualInspStock
cdfll kzfll Warehouse stock
cdflq kzflq QualInspStock
cddll dlinl Last Count Date
ersda ersda Created On
cdjin 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 Customer Stock with Vendor
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSCD_MD (
    MANDT,  -- Client [mandt]
    MATNR,  -- Material [matnr]
    WERKS,  -- Plant [werks_d]
    CHARG,  -- Batch [charg_d]
    SOBKZ,  -- Special Stock [sobkz]
    LIFNR,  -- Supplier [lifnr]
    KUNNR,  -- Customer [kunnr]
    LFGJA,  -- Year Cur.Period [lfgja]
    LFMON,  -- Current Period [lfmon]
    CDSPR,  -- Phys. Inv. Blk [sperr]
    CDILL,  -- Warehouse stock [kzill]
    CDILQ,  -- QualInspStock [kzilq]
    CDVLL,  -- Warehouse stock [kzvll]
    CDVLQ,  -- QualInspStock [kzvlq]
    CDFLL,  -- Warehouse stock [kzfll]
    CDFLQ,  -- QualInspStock [kzflq]
    CDDLL,  -- Last Count Date [dlinl]
    ERSDA,  -- Created On [ersda]
    CDJIN,  -- Fiscal year of current physical inventory indicator [gjinv]
    PRIMARY KEY (MANDT, MATNR, WERKS, CHARG, SOBKZ, LIFNR, KUNNR)
);

Learn More