S197 is an SAP table in package MCB (R/3 application development: Inventory Controlling), used in LO (Logistics General), LO-LIS (Inventory Controlling). View details, fields & related tables of S197 in SAP.
- Table description : Periodic storage location stock
- Module : LO (Logistics General)
- Component : LO-LIS (Inventory Controlling)
- Package : MCB
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 S197 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 |
| MATNR | Material Number | MATNR | MATNR |
| WERKS | Plant | WERKS_D | WERKS |
| 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 |
| MBWBEST | Quantity of valuated stock | MBWBEST | MENGV15 |
| MKOBEST | Quantity of consignment stock | MKOBEST | MENGV15 |
S197 related tables
| Table | Note |
|---|---|
| S197 | Periodic storage location stock |
| S197BIW1 | Periodic storage location stock |
| S197BIW2 | S197BIW2 * Periodic Storage Location Stock |
| CDBD_STOCK | Van Stock details for Plant, Storage location and material |
| CIF_IMMARD | Integration Model Reference Table for Storage Location Stock |
| /SPE/POD_STL | Special Storage Location Used for Stock Tr. Discr. Handling |
| /LIME/LOC_I001 | LIME - Location Key Plant, Storage Location (R/3) |
| S198 | Periodic plant stock |
| S198BIW2 | S198BIW2 * Periodic Plant Stock |
| /SAPSLL/GPASTOCK | Shared, Periodic, and Completed Stock |
| DICS_T157B | Descr. of Qty Fields (Plant Stock Avail., Stock Display) |
| OIB_T156_FIELDS | Material-stock field relation with stock type and SOBKZ |
| T157B | Descr. of Qty Fields (Plant Stock Avail., Stock Display) |
| UPARA_STOCKS | Assign Actual Stock to Planned Stock |
| /LIME/STOCK_I011 | LIME - Stock Key Sales Order Stock (R/3) |
Related tcodes for S197
Transaction codes in the same SAP package (MCB) as the S197 table.
| Tcode | Description |
|---|---|
| MC40 | INVCO: ABC Analysis of Usage Values |
| MC41 | INVCO: ABC Analysis of Reqmt Values |
| MC42 | INVCO: Range of Coverage by Usg.Val. |
| MC43 | INVCO: Range Of Coverage By Reqmts |
| MC44 | INVCO:Analysis of Inventory Turnover |
| MC45 | INVCO: Analysis of Usage Values |
| MC46 | INVCO: Analysis of Slow-Moving Items |
| MC47 | INVCO: Analysis of Reqmt Values |
| MC48 | INVCO: Anal. of Current Stock Values |
| MC49 | INVCO: Mean Stock Values |
| MC50 | INVCO: Analysis of Dead Stock |
| MCA7 | INVCO: Execute Evaluation |
Internal identification of rules of periodic appointments TablesMoving average price/periodic unit price in previous year TablesHow to remove stock from storage location TablesHow to add stock in storage location TablesHow to maintain stock in storage location mm TablesAllow negative stock in storage location sap TablesRemove stock from storage location TablesStock by storage location 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