S197 is a standard Inventory Controlling Transparent Table in SAP MM application, which stores Periodic storage location stock 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 S197. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

S197 — Meta Data

Description: Periodic storage location stock
Main Category: MM
Sub Category: Inventory Controlling
Table type: Transparent Table (TRANSP)

S197 — 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 MATNR Material X CHAR 40 MARA
    9 WERKS Plant X CHAR 4 T001W
    10 LGORT Stor. Location X CHAR 4 T001L
    11 PERIV Fi.Year Variant CHAR 2 *
    12 VWDAT Character Field Length = 10 NUMC 10
    13 BASME Base Unit of Measure UNIT 3 T006
    14 MBWBEST Field length 18 QUAN 15
    15 MKOBEST Field length 18 QUAN 15

Related Tables

TABLE Description Functional Area
S198 Periodic plant stock MM - Inventory Controlling
T001 Company Codes FI - Financial Accounting
MBEW Material Valuation Logistics - Material Master
MCHB Batch Stocks Logistics - Material Master
S094 Stock/Requirements Analysis MM - Inventory Controlling
S039 Statistics: Inventory Controlling Logistics - Data Collection
T001W Plants/Branches Logistics - Plant Master

Transaction Codes for SAP Table S197

TCODE Description Functional Area
MCHB RIS: Till Receipt - Selection Logistics - Retail Information System (RIS)
MCBC INVCO: Stor. Loc. Analysis Selection MM - Inventory Controlling
VA11 Create Inquiry SD - Sales
VA42 Change Contract SD - Sales
VL01 Create Delivery LE - Shipping
VL02 Change Outbound Delivery LE - Shipping
MCSA SIS: Create Evaluation SD - Information System
OLI9 SIS Statistical Setup: Billing Docs LO - Logistics Information System (LIS)

BW Datasources for SAP Table S197

BW DATASOURCE Description Functional Area
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management