S039 is a standard Data Collection Transparent Table in SAP Logistics application, which stores Statistics: Inventory Controlling 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 S039. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

S039 — Meta Data

Description: Statistics: Inventory Controlling
Main Category: Logistics
Sub Category: Data Collection
Table type: Transparent Table (TRANSP)

S039 — 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 DISPO MRP controller X CHAR 3 T024D
    12 DISMM MRP Type X CHAR 2 T438A
    13 MTART Material Type X CHAR 4 T134
    14 MATKL Material Group X CHAR 9 T023
    15 GSBER Business Area X CHAR 4 TGSB
    16 SPART Division X CHAR 2 TSPA
    17 PERIV Fi.Year Variant CHAR 2 T009
    18 VWDAT Character Field Length = 10 NUMC 10
    19 BASME Base Unit of Measure UNIT 3 T006
    20 HWAER Local Currency CUKY 5 TCURC
    21 MZUBB Field length 18 QUAN 15
    22 WZUBB Field length 18 CURR 15
    23 AZUBB Number of times that valuated stock has been received DEC 9
    24 MZUKB Field length 18 QUAN 15
    25 AZUKB Number of times that consignment stock has been received DEC 9
    26 MAGBB Field length 18 QUAN 15
    27 WAGBB Field length 18 CURR 15
    28 AAGBB Number of times valuated stock has been issued DEC 9
    29 MAGKB Field length 18 QUAN 15
    30 AAGKB Number of times consignment stock has been issued DEC 9
    31 AMBWG Number of material movements DEC 9
    32 MGVBR Field length 18 QUAN 15
    33 WGVBR Field length 18 CURR 15
    34 AGVBR Number of times that total usage has been updated DEC 9
    35 MUVBR Field length 18 QUAN 15
    36 WUVBR Field length 18 CURR 15
    37 AUVBR Number of times an unplanned usage has been recorded DEC 9
    38 ASTOR Number of cancelation documents to date DEC 9
    39 BBNULL Number of times that valuated stock was zero DEC 9
    40 KBNULL Number of times that consignment stock was zero DEC 9
    41 GBNULL Number of times that total stock was zero DEC 9
    42 .INCLUDE 0
    43 MBWBEST Field length 18 QUAN 15
    44 WBWBEST Field length 18 CURR 15
    45 MKOBEST Field length 18 QUAN 15
    46 DZUBB Average valuated stock receipts quantity QUAN 15
    47 DZWBB Average valuated stock receipts value CURR 15
    48 DAGBB Average quantity of valuated stock issues QUAN 15
    49 DAWBB Average valuated stock issues value CURR 15
    50 DZUKB Average consignment stock receipts quantity QUAN 15
    51 DAGKB Average quantity of consignment stock that has been issued QUAN 15
    52 DGVBR Average consumption QUAN 15
    53 GSBEST Field length 18 QUAN 15
    54 RWGSBEST Range of coverage of total stock DEC 7
    55 RWKOBEST Range of coverage of consignment stock DEC 7
    56 RWBEWBEST Range of coverage of valuated stock DEC 7
    57 UHGSBEST Turnover of total stock DEC 7
    58 UHBWBEST Turnover of valuated stock DEC 7
    59 UHKOBEST Turnover of consignment stock DEC 7
    60 DBWBEST Average quantity of valuated stock QUAN 15
    61 DKOBEST Average quantity of consignment stock QUAN 15
    62 DGSBEST Average quantity of total stock QUAN 15
    63 DWBWBEST Average valuated stock value CURR 15
    64 DRWBWBEST Average range of coverage of valuated stock DEC 7
    65 DRWKOBEST Average range of coverage of consignment stock DEC 7
    66 DRWGSBEST Average range of coverage of total stock DEC 7
    67 DUHBWBEST Average inventory turnover of valuated stock DEC 7
    68 DUHKOBEST Average turnover of consignment stock DEC 7
    69 DUHGSBEST Average turnover of total stock DEC 7
    70 DWGVBR Value of average total usage CURR 15
    71 DUVBR Average unplanned usage quantity QUAN 15
    72 DWUVBR Average unplanned usage value CURR 15
    73 UHWBWBEST Inventory turnover (value-based) of valuated stock DEC 7
    74 UHWGSBEST Inventory turnover (value-based) of total stock DEC 7
    75 DUHWGSBEST Average turnover (value-based) of total stock DEC 7
    76 DUHWBWBEST Average turnover (value-based) of valuated stock DEC 7
    77 JUHWGSBEST Annual inventory turnover (value-based) of total stock DEC 7
    78 JUHWBWBEST Annual inventory turnover (value-based) of valuated stock DEC 7
    79 JUHGSBEST Annual inventory turnover (quantity-based) of total stock DEC 7
    80 JUHKOBEST Annual turnover (quantity-based) of consignment stock DEC 7
    81 JUHBWBEST Annual inventory turnover of valuated stock DEC 7
    82 RWWGSBEST Range of coverage (value-based) of total stock DEC 7
    83 RWWBWBEST Range of coverage (value-based) of valuated stock DEC 7
    84 DRWWGSBEST Average range of coverage (value-based) of total stock DEC 7
    85 DRWWBWBEST Average range of coverage (value-based) of valuated stock DEC 7
    86 LETZTZUG Date: Last Receipt DATS 8
    87 LETZTABG Date: last (i.e. most recent) goods issue DATS 8
    88 LETZTVER Date: last (i.e. most recent) consumption DATS 8
    89 LETZTBEW Date: last (i.e. most recent) goods movement DATS 8
    90 EISBE Safety stock QUAN 15
    91 BESZUG Stock level at goods receipt QUAN 15
    92 WBESZUG Value of stock at goods receipt CURR 15
    93 BKLAS Valuation Class CHAR 4 *

SAP Help, Wiki Resources, and Forum Discussions on S039

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
S031 Statistics: Movements for current stocks Logistics - Data Collection
S032 Statistics: Current Stock and Grouping Terms Logistics - Data Collection
MBEW Material Valuation Logistics - Material Master
S034 INVCO: Movements (Batches) Logistics - Data Collection
S033 Statistics: Movements for Current Stock (Individual Records) Logistics - Data Collection
S035 Statistics: Batch Stocks Logistics - Data Collection
S094 Stock/Requirements Analysis MM - Inventory Controlling

Transaction Codes for SAP Table S039

TCODE Description Functional Area
MB5B Stocks for Posting Date MM - Inventory Management
MCBE INVCO: Material Analysis Selection MM - Inventory Controlling
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
MCBA INVCO: Plant Analysis Selection MM - Inventory Controlling
MMBE Stock Overview Logistics - Material Master
MB51 Material Doc. List MM - Inventory Management
SE16 Data Browser Basis - Workbench Utilities
MCBC INVCO: Stor. Loc. Analysis Selection MM - Inventory Controlling

FMs for SAP Table S039

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
PF_STATUS_SET Set general function key status RE - Real Estate Management
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
OIL_GET_PREV_MONTH Calculate previous month IS - Industry Solution Oil
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
OIUREP_MONTH_FIRST_LAST Determine 1st and last day of a month IS - Royalty Reporting
ADRT_GET_ROC Get Range of Coverage to set the end date IS - Aerospace & Defence Industry Solution

ABAP Reports for SAP Table S039

ABAP REPORT Description Functional Area
RMCBS039 Provide S039 With Actual Data for Planned/Actual Comparison MM - Inventory Controlling
RMCBNEUB Statistical Setup of Info Structures from Stocks MM - Inventory Controlling
RMCB0100 Plant Analysis MM - Inventory Controlling
RMCBNERP Statistical Setup of Info Strucs from Invoice Verification/Revaluation MM - Inventory Controlling
RMCB0300 Material Analysis MM - Inventory Controlling
RMCBNEUA New Setup for Info Structures from Material Movements MM - Inventory Controlling
RMCBNE32 Update for S032 MM - Inventory Controlling
RMCBDATE Date Field Creation in Information Structure S032 MM - Inventory Controlling

BW Datasources for SAP Table S039

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_03_UM Revaluations MM - Materials Management
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
2LIS_03_S196 Goods movement: Plant MM - Materials Management
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_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management

Authorization Objects for SAP Table S039

AUTHORIZATION OBJECT Description Functional Area
S_RO_OSOA SAP DataSource Authorizations
S_TABU_CLI Cross-Client Table Maintenance
M_IS_WERKS LIS Standard Analysis: Info Structure / Plant
F_BKPF_BUK Accounting Document: Authorization for Company Codes