MSRD_MD

Transparent Table Application Table
19 Fields 2 CDS Views

Master Data Fields of Project Stock with Vendor

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
NSDM_DDL_CHK_MAT_MASTER view left_outer Chk for miss mat mast vs. MATDOC_EXTRACT
NSDM_E_MSRD view from MSRD 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 pspnr ps_psp_pnr WBS Element
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
rdspr sperr Phys. Inv. Blk
rdill kzill Warehouse stock
rdilq kzilq QualInspStock
rdvll kzvll Warehouse stock
rdvlq kzvlq QualInspStock
rdfll kzfll Warehouse stock
rdflq kzflq QualInspStock
rddll dlinl Last Count Date
ersda ersda Created On
rdjin 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 Project Stock with Vendor
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSRD_MD (
    MANDT,  -- Client [mandt]
    MATNR,  -- Material [matnr]
    WERKS,  -- Plant [werks_d]
    CHARG,  -- Batch [charg_d]
    SOBKZ,  -- Special Stock [sobkz]
    LIFNR,  -- Supplier [lifnr]
    PSPNR,  -- WBS Element [ps_psp_pnr]
    LFGJA,  -- Year Cur.Period [lfgja]
    LFMON,  -- Current Period [lfmon]
    RDSPR,  -- Phys. Inv. Blk [sperr]
    RDILL,  -- Warehouse stock [kzill]
    RDILQ,  -- QualInspStock [kzilq]
    RDVLL,  -- Warehouse stock [kzvll]
    RDVLQ,  -- QualInspStock [kzvlq]
    RDFLL,  -- Warehouse stock [kzfll]
    RDFLQ,  -- QualInspStock [kzflq]
    RDDLL,  -- Last Count Date [dlinl]
    ERSDA,  -- Created On [ersda]
    RDJIN,  -- Fiscal year of current physical inventory indicator [gjinv]
    PRIMARY KEY (MANDT, MATNR, WERKS, CHARG, SOBKZ, LIFNR, PSPNR)
);

Learn More