S031 is an SAP table in package MCS (R/3 application development: Logistics Information Warehouse), used in LO (Logistics General), LO-LIS (Logistics Information System). View details, fields & related tables of S031 in SAP.
- Table description : Statistics: Movements for current stocks
- Module : LO (Logistics General)
- Component : LO-LIS (Logistics Information System)
- Package : MCS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP S031 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SSOUR | Statistic(s) origin | SSOUR | SSOUR |
| VRSIO | Version number in the information structure | VRSIO | VRSIO |
| SPMON | Period to analyze - month | SPMON | MCPERIOD |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
| SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
| WERKS | Plant | WERKS_D | WERKS |
| MATNR | Material Number | MATNR | MATNR |
| LGORT | Storage location | LGORT_D | LGORT |
| PERIV | Fiscal Year Variant | PERIV | PERIV |
| VWDAT | Pointer to administrative data | VWDAT | VWDAT |
| BASME | Base Unit of Measure | MEINS | MEINS |
| HWAER | Currency Key | WAERS | WAERS |
| MZUBB | Valuated stock receipts quantity | MZUBB | MENGV15 |
| WZUBB | Valuated stock receipts value | WZUBB | WERT15 |
| AZUBB | Number of times that valuated stock has been received | AZUBB | ANZAHL |
| MZUKB | Consignment stock receipts quantity | MZUKB | MENGV15 |
| AZUKB | Number of times that consignment stock has been received | AZUKB | ANZAHL |
| MAGBB | Quantity of valuated stock issues | MAGBB | MENGV15 |
| WAGBB | Value of valuated stock that has been issued | WAGBB | WERT15 |
| AAGBB | Number of times valuated stock has been issued | AAGBB | ANZAHL |
| MAGKB | Quantity of consignment stock that has been issued | MAGKB | MENGV15 |
| AAGKB | Number of times consignment stock has been issued | AAGKB | ANZAHL |
| AMBWG | Number of material movements | AMBWG | ANZAHL |
| MGVBR | Total usage quantity | GVBRM | MENGV15 |
| WGVBR | Total usage value | WGVBR | WERT15 |
| AGVBR | Number of times that total usage has been updated | AGVBR | ANZAHL |
| MUVBR | Unplanned usage quantity | UVBRM | MENGV15 |
| WUVBR | Unplanned usage value | WUVBR | WERT15 |
| AUVBR | Number of times an unplanned usage has been recorded | AUVBR | ANZAHL |
| ASTOR | Number of cancelation documents to date | ASTOR | ANZAHL |
| BBNULL | Number of times that valuated stock was zero | BBNULL | ANZAHL |
| KBNULL | Number of times that consignment stock was zero | KBNULL | ANZAHL |
| GBNULL | Number of times that total stock was zero | GBNULL | ANZAHL |
| BESZUG | Stock level at goods receipt | BESZUG | MENGV15 |
| WBESZUG | Value of stock at goods receipt | WBESZUG | WERT15 |
S031 related tables
| Table | Note |
|---|---|
| S031 | Statistics: Movements for current stocks |
| S033 | Statistics: Movements for Current Stock (Individual Records) |
| J_3GABEST | Current Stocks |
| PEG_TACTASS | Pegging: Current Assignments Based on Goods Movements |
| S035 | Statistics: Batch Stocks |
| NS01 | IS-H: Statistics database - movements |
| S435 | Statistics: Material Movements for Batches / NOT USED ANYM |
| S032 | Statistics: Current Stock and Grouping Terms |
| AQTDB | SAP Query: Transport stocks (local) |
| CIFSTKUCOUNT | CIF Update Counter Table for Stocks |
| CIF_IMMCHB | Integration Model Reference Table for Batch Stocks |
| CIF_IMMSKU | Int. Model Reference Table for Special Stocks at Customer |
| CIF_IMMSLB | Int. Model Reference Table for Special Stocks at Vendor |
| CIF_IMMSPR | Integration Model Reference Table for Project Stocks |
| LL05 | Whse Activity Monitor: Critical Stocks |
Related tcodes for S031
Transaction codes in the same SAP package (MCS) as the S031 table.
| Tcode | Description |
|---|---|
| MC00 | Logistics Information System (LIS) |
| MC10 | Perform Analysis |
| MC11 | Create Evaluation |
| MC12 | Change Evaluation |
| MC13 | Display Evaluation |
| MC14 | TIS: Maintain requirements |
| MC15 | TIS: Maintain formulas |
| MC16 | LIS: Delete Evaluation Structure |
| MC18 | Create Field Catalog |
| MC19 | Change Field Catalog |
| MC1A | Maintain Formulas/Requirements |
| MC1B | SIS: Maintain Requirements |
Requirements reduction upon goods movements TablesBdisplay material documents for blocked stocks TablesSpecial stocks TablesStatistics update indicator (post in/post out) TablesUpdate group for statistics update TablesStatistics-relevant delivery date Tables"statistics-relevant delivery date" TablesExchange rate for statistics (exch.rate at time of creation) Tables
Latest Table Searches
Handling units sap table in SAPHow to display handling unit table in SAP
Sap handling unit zuordnung löschen table in SAP
Where to find handling unit table in SAP
Handling unit management configuration wm table in SAP
Handling unit wm table in SAP
What is sap handling unit table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP