1. Home
  2. Resources
  3. SAP Tables
  4. MSPR - Project Stock

SAP Table MSPR

Project Stock

MSPR (Project Stock) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MSPR to other SAP tables.

MSPR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D MARC CHAR 4 0
LGORT Storage Location LGORT_D MARD CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
PRSPR Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
PRLAB Valuated Unrestricted-Use Stock LABST QUAN 13 3
PRINS Stock in Quality Inspection INSME QUAN 13 3
PRSPE Blocked Stock SPEME QUAN 13 3
PRVLA Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
PRVIN Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
PRVSP Blocked stock of previous period VMSPE QUAN 13 3
PRILL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
PRILQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
PRILS Physical inventory indicator for blocked stock KZILS CHAR 3 0
PRVLL Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
PRVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
PRVLS Phys. inventory indicator for blocked stock in prev. period KZVLS CHAR 3 0
PRFLL Physical inventory indicator for stock in following year KZFLL CHAR 3 0
PRFLQ Physical inventory indicator, quality insp.stck, follow.yr. KZFLQ CHAR 3 0
PRFLS Phys. inventory ind. for blocked stock in following period KZFLS CHAR 3 0
PRDLL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
PREIN Total Stock of All Restricted Batches EINME QUAN 13 3
PRVEI Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
ERSDA Created On ERSDA DATS 8 0
PRJIN Fiscal year of current physical inventory indicator GJINV NUMC 4 0
PRRUE MxxxH rec. already exists for per. before last of Mxxx per. SBRUE CHAR 1 0
X Yes
NULL No

MSPR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MSPR CHARG MSPR CHARG MCHA Batches CHARG
MSPR CHARG MSPR MANDT MCHA Batches MANDT
MSPR CHARG MSPR MATNR MCHA Batches MATNR
MSPR CHARG MSPR WERKS MCHA Batches WERKS
MSPR LGORT MSPR WERKS MARD Storage Location Data for Material WERKS
MSPR LGORT MSPR LGORT MARD Storage Location Data for Material LGORT
MSPR LGORT MSPR MANDT MARD Storage Location Data for Material MANDT
MSPR LGORT MSPR MATNR MARD Storage Location Data for Material MATNR
MSPR MANDT MSPR MANDT T000 Clients MANDT
MSPR MATNR MSPR MANDT MARA General Material Data MANDT
MSPR MATNR MSPR MATNR MARA General Material Data MATNR
MSPR PSPNR MSPR MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
MSPR PSPNR MSPR PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
MSPR SOBKZ MSPR MANDT T148 Special Stock Indicator MANDT
MSPR SOBKZ MSPR SOBKZ T148 Special Stock Indicator SOBKZ
MSPR WERKS MSPR MANDT MARC Plant Data for Material MANDT
MSPR WERKS MSPR MATNR MARC Plant Data for Material MATNR
MSPR WERKS MSPR WERKS MARC Plant Data for Material WERKS