SAP Table S031
Statistics: Movements for current stocks
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table S031 (Statistics: Movements for current stocks) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S031 |
| Short Text | Statistics: Movements for current stocks |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S031
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SSOUR | ✔ | Statistic(s) origin | SSOUR | CHAR | 4 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| SPWOC | ✔ | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | ✔ | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| LGORT | ✔ | Storage Location | LGORT_D | CHAR | 4 | T001L |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| HWAER | Currency Key | WAERS | CUKY | 5 | TCURC | |
| MZUBB | Valuated stock receipts quantity | MZUBB | QUAN | 15 | ||
| WZUBB | Valuated stock receipts value | WZUBB | CURR | 15 | ||
| AZUBB | Number of times that valuated stock has been received | AZUBB | DEC | 9 | ||
| MZUKB | Consignment stock receipts quantity | MZUKB | QUAN | 15 | ||
| AZUKB | Number of times that consignment stock has been received | AZUKB | DEC | 9 | ||
| MAGBB | Quantity of valuated stock issues | MAGBB | QUAN | 15 | ||
| WAGBB | Value of valuated stock that has been issued | WAGBB | CURR | 15 | ||
| AAGBB | Number of times valuated stock has been issued | AAGBB | DEC | 9 | ||
| MAGKB | Quantity of consignment stock that has been issued | MAGKB | QUAN | 15 | ||
| AAGKB | Number of times consignment stock has been issued | AAGKB | DEC | 9 | ||
| AMBWG | Number of material movements | AMBWG | DEC | 9 | ||
| MGVBR | Total usage quantity | GVBRM | QUAN | 15 | ||
| WGVBR | Total usage value | WGVBR | CURR | 15 | ||
| AGVBR | Number of times that total usage has been updated | AGVBR | DEC | 9 | ||
| MUVBR | Unplanned usage quantity | UVBRM | QUAN | 15 | ||
| WUVBR | Unplanned usage value | WUVBR | CURR | 15 | ||
| AUVBR | Number of times an unplanned usage has been recorded | AUVBR | DEC | 9 | ||
| ASTOR | Number of cancelation documents to date | ASTOR | DEC | 9 | ||
| BBNULL | Number of times that valuated stock was zero | BBNULL | DEC | 9 | ||
| KBNULL | Number of times that consignment stock was zero | KBNULL | DEC | 9 | ||
| GBNULL | Number of times that total stock was zero | GBNULL | DEC | 9 | ||
| BESZUG | Stock level at goods receipt | BESZUG | QUAN | 15 | ||
| WBESZUG | Value of stock at goods receipt | WBESZUG | CURR | 15 |