SAP table MSPR (Project Stock)

SAP table MSPR has 7 primary key fields being MANDT,MATNR,WERKS,LGORT,CHARG,SOBKZ,PSPNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

MSPR foreign key relationships

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