S031 - Statistics: Movements for current stocks
Statistics: Movements for current stocks information is stored in SAP table S031.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S031
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| LGORT | Storage location | X | LGORT_D | CHAR | 8 | T001L |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | T009 | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| HWAER | Currency Key | WAERS | CUKY | 10 | TCURC | |
| MZUBB | Valuated stock receipts quantity | MZUBB | QUAN | 8 | ||
| WZUBB | Valuated stock receipts value | WZUBB | CURR | 8 | ||
| AZUBB | Number of times that valuated stock has been received | AZUBB | DEC | 5 | ||
| MZUKB | Consignment stock receipts quantity | MZUKB | QUAN | 8 | ||
| AZUKB | Number of times that consignment stock has been received | AZUKB | DEC | 5 | ||
| MAGBB | Quantity of valuated stock issues | MAGBB | QUAN | 8 | ||
| WAGBB | Value of valuated stock that has been issued | WAGBB | CURR | 8 | ||
| AAGBB | Number of times valuated stock has been issued | AAGBB | DEC | 5 | ||
| MAGKB | Quantity of consignment stock that has been issued | MAGKB | QUAN | 8 | ||
| AAGKB | Number of times consignment stock has been issued | AAGKB | DEC | 5 | ||
| AMBWG | Number of material movements | AMBWG | DEC | 5 | ||
| MGVBR | Total usage quantity | GVBRM | QUAN | 8 | ||
| WGVBR | Total usage value | WGVBR | CURR | 8 | ||
| AGVBR | Number of times that total usage has been updated | AGVBR | DEC | 5 | ||
| MUVBR | Unplanned usage quantity | UVBRM | QUAN | 8 | ||
| WUVBR | Unplanned usage value | WUVBR | CURR | 8 | ||
| AUVBR | Number of times an unplanned usage has been recorded | AUVBR | DEC | 5 | ||
| ASTOR | Number of cancelation documents to date | ASTOR | DEC | 5 | ||
| BBNULL | Number of times that valuated stock was zero | BBNULL | DEC | 5 | ||
| KBNULL | Number of times that consignment stock was zero | KBNULL | DEC | 5 | ||
| GBNULL | Number of times that total stock was zero | GBNULL | DEC | 5 | ||
| BESZUG | Stock level at goods receipt | BESZUG | QUAN | 8 | ||
| WBESZUG | Value of stock at goods receipt | WBESZUG | CURR | 8 |