S031 is a standard Data Collection Transparent Table in SAP Logistics application, which stores Statistics: Movements for current stocks data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for S031. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

S031 — Meta Data

Description: Statistics: Movements for current stocks
Main Category: Logistics
Sub Category: Data Collection
Table type: Transparent Table (TRANSP)

S031 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 SSOUR Statistic(s) origin X CHAR 4
    3 VRSIO Version X CHAR 3 *
    4 SPMON Calendar year / month X NUMC 6
    5 SPTAG Calendar day X DATS 8
    6 SPWOC Calendar year / week X NUMC 6
    7 SPBUP Fiscal year / period X NUMC 6
    8 WERKS Plant X CHAR 4 T001W
    9 MATNR Material X CHAR 40 MARA
    10 LGORT Stor. Location X CHAR 4 T001L
    11 PERIV Fi.Year Variant CHAR 2 T009
    12 VWDAT Character Field Length = 10 NUMC 10
    13 BASME Base Unit of Measure UNIT 3 T006
    14 HWAER Local Currency CUKY 5 TCURC
    15 MZUBB Field length 18 QUAN 15
    16 WZUBB Field length 18 CURR 15
    17 AZUBB Number of times that valuated stock has been received DEC 9
    18 MZUKB Field length 18 QUAN 15
    19 AZUKB Number of times that consignment stock has been received DEC 9
    20 MAGBB Field length 18 QUAN 15
    21 WAGBB Field length 18 CURR 15
    22 AAGBB Number of times valuated stock has been issued DEC 9
    23 MAGKB Field length 18 QUAN 15
    24 AAGKB Number of times consignment stock has been issued DEC 9
    25 AMBWG Number of material movements DEC 9
    26 MGVBR Field length 18 QUAN 15
    27 WGVBR Field length 18 CURR 15
    28 AGVBR Number of times that total usage has been updated DEC 9
    29 MUVBR Field length 18 QUAN 15
    30 WUVBR Field length 18 CURR 15
    31 AUVBR Number of times an unplanned usage has been recorded DEC 9
    32 ASTOR Number of cancelation documents to date DEC 9
    33 BBNULL Number of times that valuated stock was zero DEC 9
    34 KBNULL Number of times that consignment stock was zero DEC 9
    35 GBNULL Number of times that total stock was zero DEC 9
    36 BESZUG Stock level at goods receipt QUAN 15
    37 WBESZUG Value of stock at goods receipt CURR 15

SAP Help, Wiki Resources, and Forum Discussions on S031

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
S032 Statistics: Current Stock and Grouping Terms Logistics - Data Collection
MBEW Material Valuation Logistics - Material Master
S033 Statistics: Movements for Current Stock (Individual Records) Logistics - Data Collection
MARD Storage Location Data for Material Logistics - Material Master
MKPF Header: Material Document MM - Inventory Management
S039 Statistics: Inventory Controlling Logistics - Data Collection
MARA General Material Data Logistics - Material Master

Transaction Codes for SAP Table S031

TCODE Description Functional Area
MB5B Stocks for Posting Date MM - Inventory Management
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
MB51 Material Doc. List MM - Inventory Management
MMBE Stock Overview Logistics - Material Master
FERT Flow of cost trace FI - Financial Accounting
MB52 List of Warehouse Stocks on Hand MM - Inventory Management
SE16 Data Browser Basis - Workbench Utilities
MB5L List of Stock Values: Balances MM - Inventory Management

FMs for SAP Table S031

FM Description Functional Area
BKK_GET_MONTH_LASTDAY Determine Last Day of Month IS - Bank Customer Accounts
CONVERSION_EXIT_PERI_OUTPUT Output conversion for period field Logistics - Data Collection
CONVERSION_EXIT_PERI_INPUT Input conversion for period field Logistics - Data Collection
CONVERSION_EXIT_ALPHA_OUTPUT Conversion exit ALPHA, internal->external Basis - Syntax, Compiler, Runtime
DYNP_VALUES_READ Read screen field values before PAI field transport Basis - F1 Help
DYNP_VALUES_UPDATE Change screen field contents w/o PBO Basis - F1 Help
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
POPUP_TO_SELECT_MONTH Popup to choose a month Basis - Holiday Calendar, Factory Calendar, Appointment Calendar

ABAP Reports for SAP Table S031

ABAP REPORT Description Functional Area
SAPLALDB SAPLALDB
RMCB0300 Material Analysis MM - Inventory Controlling
RMCBS039 Provide S039 With Actual Data for Planned/Actual Comparison MM - Inventory Controlling
RMCBNEUB Statistical Setup of Info Structures from Stocks MM - Inventory Controlling
RMCBNEUA New Setup for Info Structures from Material Movements MM - Inventory Controlling
RMDATIND Transfer Material Master Data by Direct Input Logistics - Material Master
RMCBNERP Statistical Setup of Info Strucs from Invoice Verification/Revaluation MM - Inventory Controlling
RM07MMFI MM/FI balance comparison MM - Inventory Management

BW Datasources for SAP Table S031

BW DATASOURCE Description Functional Area
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management
2LIS_03_BX Stock Initialization for Inventory Management MM - Materials Management
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
2LIS_03_UM Revaluations MM - Materials Management
2LIS_13_VDITM Billing Document Item Data SD - Sales and Distribution
0FI_GL_1 General ledger: Transaction figures FI - General Ledger Accounting
2LIS_11_V_SCL Sales-Shipping Allocation Schedule Line SD - Sales and Distribution
2LIS_03_S198 Periodic plant stock MM - Materials Management

Authorization Objects for SAP Table S031

AUTHORIZATION OBJECT Description Functional Area
M_MATE_WRK Material Master: Plants
S_RO_OSOA SAP DataSource Authorizations
S_TABU_CLI Cross-Client Table Maintenance