MSPR

Transparent Table Application Table
31 Fields 2 CDS Views

Project Stock

MSPR is an SAP database table in S/4HANA. Project Stock. It contains 31 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
nsdm_e_mspr view from MSPR Compatibility View
P_Mtm_Batches_For_Locking view union BASIC List of Batches to lock for stock MTM per material / plant

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY werks werks_d Plant
KEY lgort lgort_d Location
KEY charg charg_d Batch
KEY sobkz sobkz Special Stock
KEY pspnr ps_psp_pnr WBS Element
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
prspr sperr Phys. Inv. Blk
prlab labst Unrestricted
prins insme Quality Insp.
prspe speme Blocked Stock
prvla vmlab Unrestr.-use
prvin vmins In qual. insp.
prvsp vmspe Blocked
prill kzill Warehouse stock
prilq kzilq QualInspStock
prils kzils Blocked stock
prvll kzvll Warehouse stock
prvlq kzvlq QualInspStock
prvls kzvls Blocked stock
prfll kzfll Warehouse stock
prflq kzflq QualInspStock
prfls kzfls Blocked stock
prdll dlinl Last Count Date
prein einme Restricted-Use
prvei vmein Restr.-use PP
ersda ersda Created On
prjin gjinv Fiscal year of current physical inventory indicator
prrue sbrue MxxxH rec. already exists for per. before last of Mxxx per.

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.

-- Project Stock
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSPR (
    MANDT,  -- Client [mandt]
    MATNR,  -- Material [matnr]
    WERKS,  -- Plant [werks_d]
    LGORT,  -- Location [lgort_d]
    CHARG,  -- Batch [charg_d]
    SOBKZ,  -- Special Stock [sobkz]
    PSPNR,  -- WBS Element [ps_psp_pnr]
    LFGJA,  -- Year Cur.Period [lfgja]
    LFMON,  -- Current Period [lfmon]
    PRSPR,  -- Phys. Inv. Blk [sperr]
    PRLAB,  -- Unrestricted [labst]
    PRINS,  -- Quality Insp. [insme]
    PRSPE,  -- Blocked Stock [speme]
    PRVLA,  -- Unrestr.-use [vmlab]
    PRVIN,  -- In qual. insp. [vmins]
    PRVSP,  -- Blocked [vmspe]
    PRILL,  -- Warehouse stock [kzill]
    PRILQ,  -- QualInspStock [kzilq]
    PRILS,  -- Blocked stock [kzils]
    PRVLL,  -- Warehouse stock [kzvll]
    PRVLQ,  -- QualInspStock [kzvlq]
    PRVLS,  -- Blocked stock [kzvls]
    PRFLL,  -- Warehouse stock [kzfll]
    PRFLQ,  -- QualInspStock [kzflq]
    PRFLS,  -- Blocked stock [kzfls]
    PRDLL,  -- Last Count Date [dlinl]
    PREIN,  -- Restricted-Use [einme]
    PRVEI,  -- Restr.-use PP [vmein]
    ERSDA,  -- Created On [ersda]
    PRJIN,  -- Fiscal year of current physical inventory indicator [gjinv]
    PRRUE,  -- MxxxH rec. already exists for per. before last of Mxxx per. [sbrue]
    PRIMARY KEY (MANDT, MATNR, WERKS, LGORT, CHARG, SOBKZ, PSPNR)
);

Learn More