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

S195 — Meta Data

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

S195 — 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 SPMON Calendar year / month X NUMC 6
    3 MATNR Material X CHAR 40 MARA
    4 WERKS Plant X CHAR 4 T001W
    5 LGORT Stor. Location X CHAR 4 T001L
    6 VRSIO Version X CHAR 3
    7 SPTAG Calendar day X DATS 8
    8 SPWOC Calendar year / week X NUMC 6
    9 SPBUP Fiscal year / period X NUMC 6
    10 SSOUR Statistic(s) origin X CHAR 4
    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 MZUBB Field length 18 QUAN 15
    15 MZUKB Field length 18 QUAN 15
    16 MAGBB Field length 18 QUAN 15
    17 MAGKB Field length 18 QUAN 15
    18 MGVBR Field length 18 QUAN 15
    19 MUVBR Field length 18 QUAN 15
    20 AZUBB Number of times that valuated stock has been received DEC 9
    21 AZUKB Number of times that consignment stock has been received DEC 9
    22 AAGBB Number of times valuated stock has been issued DEC 9
    23 AAGKB Number of times consignment stock has been issued DEC 9
    24 AGVBR Number of times that total usage has been updated DEC 9
    25 AUVBR Number of times an unplanned usage has been recorded DEC 9
    26 AMBWG Number of material movements DEC 9
    27 ASTOR Number of cancelation documents to date DEC 9
    28 .INCLU--AP 0
    29 .INCLUDE 0
    30 .INCLUDE 0
    31 OIUOMQT Base quantity for excise duty rate (e.g.per 1 or 100 UoM) UNIT 3 *
    32 OITAXQT Excise duty tax quantity in STBME QUAN 13
    33 OIFUTQT Future tax quantity QUAN 13
    34 OIFEETOT Fee total CURR 13
    35 OIGLERF Quantity in unit of entry QUAN 13
    36 OIGLSKU Quantity QUAN 13
    37 OIGLBPR Quantity in Purchase Order Price Unit QUAN 13
    38 OIH_FOLQTY Excise Tax Follow-On License Quantity QUAN 13
    39 ERFME Unit of entry UNIT 3 *
    40 WAERS Currency CUKY 5 *
    41 BPRME Order Price Unit (Purchasing) UNIT 3 *
    42 .INCLUDE 0
    43 OIMSEHI1 Unit of measurement 1 UNIT 3 *
    44 OIADQNT1 Additional Oil and Gas Quantity FLTP 16
    45 OIMSEHI2 Unit of measurement 2 UNIT 3 *
    46 OIADQNT2 Additional oil quantity 2 FLTP 16
    47 OIMSEHI3 Unit of measurement 3 UNIT 3 *
    48 OIADQNT3 Additional oil quantity 3 FLTP 16
    49 OIMSEHI4 Unit of measurement 4 UNIT 3 *
    50 OIADQNT4 Additional oil quantity 4 FLTP 16
    51 OIMSEHI5 Unit of measurement 5 UNIT 3 *
    52 OIADQNT5 Additional oil quantity 5 FLTP 16

Related Tables

TABLE Description Functional Area
S039 Statistics: Inventory Controlling Logistics - Data Collection
S196 Goods movement: Plant MM - Inventory Controlling
V_PATH Generated Table for View V_PATH Basis - Platform-Independent File Names
MSTA Material Master Status Logistics - Material Master
MARD Storage Location Data for Material Logistics - Material Master
KOTP210 Material/plant/storage location Logistics - Master data
MARDH Material Master Storage Location Segment: History Logistics - Material Master

Transaction Codes for SAP Table S195

TCODE Description Functional Area
ME54N Release Purchase Requisition MM - Purchasing
SU01 User Maintenance Basis - User and Authorization Management
MB1A Goods Withdrawal MM - Inventory Management
OBA7 C FI maintain table T003 FI - Basic Functions
SCC4 Client Administration Basis - Client Copy
OLI1BW INVCO Stat. Setup: Material Movemts LO - Logistics Information System (LIS)
OBVU C FI Maintain View FI - Basic Functions
SM58 Asynchronous RFC Error Log Basis - RFC

FMs for SAP Table S195

FM Description Functional Area
WS_FILENAME_GET OBSOLETE: Call File Selector Basis - Graphic
PYXX_GET_RELID_FROM_PERNR Bestimmt RELID und MOLGA Payroll - Payroll: General Parts
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
F4_FILENAME F4 for filename / Filemanager support to locate file in a directory PM - Plant Maintenance

ABAP Reports for SAP Table S195

ABAP REPORT Description Functional Area
SAPLRSAP Reporting Server: Service API
SAPLRSDM Data basis: Read master data

BW Datasources for SAP Table S195

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_S195 Material movements: storage location MM - Materials Management
2LIS_03_S196 Goods movement: Plant MM - Materials Management