MSPR - Project Stock
Project Stock information is stored in SAP table MSPR.
It is part of development package MBND_PUBLIC in software component MM-IM-GF. This development package consists of objects that can be grouped under "MM: Inventory Management New Data Model Public Objects".
It is part of development package MBND_PUBLIC in software component MM-IM-GF. This development package consists of objects that can be grouped under "MM: Inventory Management New Data Model Public Objects".
Fields for table MSPR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | MARC |
| LGORT | Storage location | X | LGORT_D | CHAR | 8 | MARD |
| CHARG | Batch Number | X | CHARG_D | CHAR | 20 | MCHA |
| SOBKZ | Special Stock Indicator | X | SOBKZ | CHAR | 2 | T148 |
| PSPNR | Work Breakdown Structure Element (WBS Element) | X | PS_PSP_PNR | NUMC | 16 | PRPS |
| LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 8 | ||
| LFMON | Current period (posting period) | LFMON | NUMC | 4 | ||
| PRSPR | Physical Inventory Blocking Indicator | SPERR | CHAR | 2 | ||
| PRLAB | Valuated Unrestricted-Use Stock | LABST | QUAN | 7 | ||
| PRINS | Stock in Quality Inspection | INSME | QUAN | 7 | ||
| PRSPE | Blocked Stock | SPEME | QUAN | 7 | ||
| PRVLA | Valuated unrestricted-use stock in previous period | VMLAB | QUAN | 7 | ||
| PRVIN | Stock in Quality Inspection in Previous Period | VMINS | QUAN | 7 | ||
| PRVSP | Blocked stock of previous period | VMSPE | QUAN | 7 | ||
| PRILL | Physical inventory indicator for whse stock in current year | KZILL | CHAR | 6 | ||
| PRILQ | Phys. inventory ind. f. stock in qual. insp. in current year | KZILQ | CHAR | 6 | ||
| PRILS | Physical inventory indicator for blocked stock | KZILS | CHAR | 6 | ||
| PRVLL | Physical inventory indicator for stock in previous year | KZVLL | CHAR | 6 | ||
| PRVLQ | Phys. inventory ind. f. stock in qual. insp. in prev. period | KZVLQ | CHAR | 6 | ||
| PRVLS | Phys. inventory indicator for blocked stock in prev. period | KZVLS | CHAR | 6 | ||
| PRFLL | Physical inventory indicator for stock in following year | KZFLL | CHAR | 6 | ||
| PRFLQ | Physical inventory indicator, quality insp.stck, follow.yr. | KZFLQ | CHAR | 6 | ||
| PRFLS | Phys. inventory ind. for blocked stock in following period | KZFLS | CHAR | 6 | ||
| PRDLL | Date of Last Posted Count | DLINL | DATS | 16 | ||
| PREIN | Total Stock of All Restricted Batches | EINME | QUAN | 7 | ||
| PRVEI | Restricted-Use Stock in Previous Period | VMEIN | QUAN | 7 | ||
| ERSDA | Created On | ERSDA | DATS | 16 | ||
| PRJIN | Fiscal year of current physical inventory indicator | GJINV | NUMC | 8 | ||
| PRRUE | MxxxH rec. already exists for per. before last of Mxxx per. | SBRUE | CHAR | 2 | ||
| .INCLUDE | /CWM/EMSPR_PQ | 0 | ||||
| /CWM/PRLAB | Valuated Unrestricted-Use Stock | LABST | QUAN | 7 | ||
| /CWM/PRINS | Stock in Quality Inspection | INSME | QUAN | 7 | ||
| /CWM/PRSPE | Blocked Stock | SPEME | QUAN | 7 | ||
| /CWM/PREIN | Total Stock of All Restricted Batches | EINME | QUAN | 7 | ||
| /CWM/PRVLA | Valuated unrestricted-use stock in previous period | VMLAB | QUAN | 7 | ||
| /CWM/PRVIN | Stock in Quality Inspection in Previous Period | VMINS | QUAN | 7 | ||
| /CWM/PRVSP | Blocked stock of previous period | VMSPE | QUAN | 7 | ||
| /CWM/PRVEI | Restricted-Use Stock in Previous Period | VMEIN | QUAN | 7 |