MSPR

Project Stock | view | #transactional | Component: Basic Functions
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
LGORT FK Storage location
CHARG FK Batch Number
SOBKZ FK Special Stock Indicator
PSPNR FK Work Breakdown Structure Element (WBS Element)
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
PRLAB Valuated Unrestricted-Use Stock
PRINS Stock in Quality Inspection
PRSPE Blocked Stock
PRVLA Valuated unrestricted-use stock in previous period
PRVIN Stock in Quality Inspection in Previous Period
PRVSP Blocked stock of previous period
PREIN Total Stock of All Restricted Batches
PRVEI Restricted-Use Stock in Previous Period
/CWM/PRLAB Valuated Unrestricted-Use Stock
/CWM/PRINS Stock in Quality Inspection
/CWM/PRSPE Blocked Stock
/CWM/PREIN Total Stock of All Restricted Batches
/CWM/PRVLA Valuated unrestricted-use stock in previous period
/CWM/PRVIN Stock in Quality Inspection in Previous Period
/CWM/PRVSP Blocked stock of previous period
/CWM/PRVEI Restricted-Use Stock in Previous Period
Column Name Description
PRDLL Date of Last Posted Count
ERSDA Created On
Column Name Description
PRSPR Physical Inventory Blocking Indicator Show values
PRRUE MxxxH rec. already exists for per. before last of Mxxx per. Show values
Column Name Description Domain name
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
PRILL Physical inventory indicator for whse stock in current year INVKZ
PRILQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
PRILS Physical inventory indicator for blocked stock INVKZ
PRVLL Physical inventory indicator for stock in previous year INVKZ
PRVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
PRVLS Phys. inventory indicator for blocked stock in prev. period INVKZ
PRFLL Physical inventory indicator for stock in following year INVKZ
PRFLQ Physical inventory indicator, quality insp.stck, follow.yr. INVKZ
PRFLS Phys. inventory ind. for blocked stock in following period INVKZ
PRJIN Fiscal year of current physical inventory indicator GJAHR
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Batch Number
  • Plant
  • MSPR.MANDT == MCHA.MANDT
  • MSPR.MATNR == MCHA.MATNR
  • MSPR.CHARG == MCHA.CHARG
  • MSPR.WERKS == MCHA.WERKS
Storage location
  • Plant
  • Material Number
  • Storage location
  • MSPR.MANDT == MARD.MANDT
  • MSPR.WERKS == MARD.WERKS
  • MSPR.MATNR == MARD.MATNR
  • MSPR.LGORT == MARD.LGORT
Client MSPR.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • MSPR.MATNR == MARA.MATNR
  • MSPR.MANDT == MARA.MANDT
Special Stock Indicator
  • MSPR.MANDT == T148.MANDT
  • MSPR.SOBKZ == T148.SOBKZ
Plant
  • Material Number
  • Client
  • Plant
  • MSPR.MATNR == MARC.MATNR
  • MSPR.MANDT == MARC.MANDT
  • MSPR.WERKS == MARC.WERKS