S110 SAP (OTB) Table details
Dictionary Type: Table
Description: OTB
Description: OTB
Table field list including key, data, relationships and ABAP select examples
S110 is a standard SAP Table which is used to store OTB data and is available within R/3 SAP systems depending on the version and release level.
The S110 table consists of various fields, each holding specific information or linking keys about OTB data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP S110 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
SAISO | Season Category | SAISO | CHAR | 4 | T6WSP | SAISO | SAISO | ||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
WGRU2 | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 18 | KLASSE | WGRU2 | |||
WGRU1 | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 18 | KLASSE | WGRU1 | |||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
PLGTP | Price Band Category | PLGTP | CHAR | 2 | TWPT | PLGTP | |||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | WAERS | |||
BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 19(2) | WERTV10 | ||||
UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 15(3) | MENGV15_3 | ||||
PRSNLS | Sales deviation during sales | MCW_PRSNLS | CURR | 19(2) | WERTV10 | ||||
BSTGVP | Stock at retail with tax | MCW_BSTGVP | CURR | 19(2) | WERTV10 | ||||
BSTMNG | Stock quantity in base unit of measure | MCW_BSTMNG | QUAN | 15(3) | MENGV15_3 | ||||
BSTPROZ | Stock as % of sales volume | BESTPROZ | FLTP | 16(16) | FLTP | ||||
UBGVP | Revaluations at sales price including tax | MCW_UBGVP | CURR | 19(2) | WERTV10 | ||||
UBMNG | Revaluation quantity in BUn | UBMNG | QUAN | 15(3) | MENGV15_3 | ||||
UBPROZ | Revaluations as a percentage | UBPROZ | FLTP | 16(16) | FLTP | ||||
BKIVP | Stock adjustments: inventory difference at sales price + tax | MCW_BKIVP | CURR | 19(2) | WERTV10 | ||||
BKIMNG | Stock adjustments: inventory differences as base unit qty | BKIMNG | QUAN | 15(3) | MENGV15_3 | ||||
BKIPROZ | Stock adjustments: inventory differences as a % | BKIPROZ | FLTP | 16(16) | FLTP | ||||
SBUDGVP | Seasonal budget at sales price including tax | GLIMGVP | CURR | 19(2) | WERTV10 | ||||
SBUDMNG | Seasonal budget - quantity in base unit (BUn) | GLIMMNG | QUAN | 15(3) | MENGV15_3 | ||||
VQUOTEPROZ | Initial purchasing quota (%) | VERT_LIM | FLTP | 16(16) | FLTP | ||||
VLIMGVP | Budget already released at sales price including VAT | VBUDGVP | CURR | 19(2) | WERTV10 | ||||
VBUDMNG | Budget Already Released - Quantity (Base Unit of Measure) | VLIMMNG | QUAN | 15(3) | MENGV15_3 | ||||
RLIMGVP | Reserve budget SPwT | RBUDGVP | CURR | 19(2) | WERTV10 | ||||
RLIMMNG | Reserve budget quantity in base unit of measure (BUn) | RLIMMNG | QUAN | 15(3) | MENGV15_3 | ||||
BBSGVP | On-order stock at retail with tax | MCW_BBSGVP | CURR | 19(2) | WERTV10 | ||||
BBSMNG | On-order stock quantity in BUn | MCW_BBSMNG | QUAN | 15(3) | MENGV15_3 | ||||
ULBBSGVP | Open stock transport orders (delivering plant) at SPw/VAT | ULBBSGVP | CURR | 19(2) | WERTV10 | ||||
ULBBSMNG | Open stock transport order qty (supplying plant) in BUn | ULBBSMNG | QUAN | 15(3) | MENGV15_3 | ||||
UBBSGVP | Open stock transport orders at sales price including tax | UBBSGVP | CURR | 19(2) | WERTV10 | ||||
UBBSMNG | Open stock transport order quantity in BUn | UBBSMNG | QUAN | 15(3) | MENGV15_3 | ||||
ZUGGVP | Receipts at retail with tax | MCW_ZUGGVP | CURR | 19(2) | WERTV10 | ||||
ZUGMNG | Receipts quantity in BUn | MCW_ZUGMNG | QUAN | 15(3) | MENGV15_3 | ||||
ABGGVP | Issues at retail with tax | MCW_ABGGVP | CURR | 19(2) | WERTV10 | ||||
ABGMNG | Issues quantity in BUn | MCW_ABGMNG | QUAN | 15(3) | MENGV15_3 | ||||
SOTBGVP | OTB of seasonal budget at sales price including tax | OTBSGVP | CURR | 19(2) | WERTV10 | ||||
SOTBMNG | OTB of seasonal budget in quantity of base unit | OTBSMNG | QUAN | 15(3) | MENGV15_3 | ||||
VOTBGVP | OTB of budget already released at sales price including tax | OTBVGVP | CURR | 19(2) | WERTV10 | ||||
VOTBMNG | Open-to-buy of budget already released in qty of base unit | OTBVMNG | QUAN | 15(3) | MENGV15_3 | ||||
AVGVP | Average price of price band at sales price with tax | AVGVP | CURR | 19(2) | WERTV10 | ||||
GLIMGVO | Seasonal budget at sales price without tax | GLIMGVO | CURR | 19(2) | WERTV10 | ||||
GLIMGEO | Seasonal budget at purchase price without tax | GLIMGEO | CURR | 19(2) | WERTV10 | ||||
VBUDGVO | Budget already released at sales price without VAT | VBUDGVO | CURR | 19(2) | WERTV10 | ||||
VBUDGEO | Budget already released at purchase price without VAT | VBUDGEO | CURR | 19(2) | WERTV10 | ||||
RBUDGVO | Reserve budget SPw/oVAT | RBUDGVO | CURR | 19(2) | WERTV10 | ||||
RBUDGEO | Reserve budget PPw/oVAT | RBUDGEO | CURR | 19(2) | WERTV10 | ||||
AVGVO | Average price band price at sales price without tax | AVGVO | CURR | 19(2) | WERTV10 | ||||
AVGEO | Average price band price at purchase price without tax | AVGEO | CURR | 19(2) | WERTV10 | ||||
UBGVO | Revaluations at sales price without tax | MCW_UBGVO | CURR | 19(2) | WERTV10 | ||||
UBGEO | Revaluation PPw/oVAT | MCW_UBGEO | CURR | 19(2) | WERTV10 | ||||
BKIVO | Stock adjustments: inventory difference at SPw/oVAT | MCW_BKIVO | CURR | 19(2) | WERTV10 | ||||
BKIEO | Stock adjustments: inventory difference at PPw/oVAT | MCW_BKIEO | CURR | 19(2) | WERTV10 | ||||
SOTBGVO | OTB of seasonal budget at sales price without tax | OTBSGVO | CURR | 19(2) | WERTV10 | ||||
SOTBGEO | OTB of seasonal budget at purchase price without tax | OTBSGEO | CURR | 19(2) | WERTV10 | ||||
VOTBGVO | OTB of budget already released at sales price without tax | OTBVGVO | CURR | 19(2) | WERTV10 | ||||
VOTBGEO | OTB of budget already released at purchase price without tax | OTBVGEO | CURR | 19(2) | WERTV10 | ||||
UBBSGVO | Open stock transport orders at sales price without tax | UBBSGVO | CURR | 19(2) | WERTV10 | ||||
UBBSGEO | Open stock transport orders at PPw/oVAT | UBBSGEO | CURR | 19(2) | WERTV10 | ||||
ULBBSGVO | Open stock transport orders (delivering plant) at SPw/oVAT | ULBBSGVO | CURR | 19(2) | WERTV10 | ||||
ULBBSGEO | Open stock transport orders (delivering plant) at PPw/oVAT | ULBBSGEO | CURR | 19(2) | WERTV10 | ||||
UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 19(2) | WERTV10 | ||||
UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 19(2) | WERTV10 | ||||
BSTGEO | Stock at cost | MCW_BSTGEO | CURR | 19(2) | WERTV10 | ||||
BSTGVO | Stock at retail | MCW_BSTGVO | CURR | 19(2) | WERTV10 | ||||
ABGGEO | Issues at cost | MCW_ABGGEO | CURR | 19(2) | WERTV10 | ||||
ABGGVO | Issues at retail | MCW_ABGGVO | CURR | 19(2) | WERTV10 | ||||
ZUGGEO | Receipts at cost | MCW_ZUGGEO | CURR | 19(2) | WERTV10 | ||||
ZUGGVO | Receipts at retail | MCW_ZUGGVO | CURR | 19(2) | WERTV10 | ||||
BBSGEO | On-order stock at cost | MCW_BBSGEO | CURR | 19(2) | WERTV10 | ||||
BBSGVO | On-order stock at retail | MCW_BBSGVO | CURR | 19(2) | WERTV10 | ||||
UMSMAO | Sales margin | MCW_UMSMAO | DEC | 6(2) | PRZ32V | ||||
UMSMAM | Sales margin with tax | MCW_UMSMAM | DEC | 6(2) | PRZ32V | ||||
WESMAO | Goods receipt margin (vendor+GR(DC)) | MCW_WESMAO | DEC | 6(2) | PRZ32V | ||||
WESMAM | Goods receipt margin with tax (vendor+GR(DC)) | MCW_WESMAM | DEC | 6(2) | PRZ32V | ||||
JUWERT | Annual inventory turn (value) | MCW_JUWERT | DEC | 6(2) | PRZ32V | ||||
JUMENG | Annual inventory turn (quantity) | MCW_JUMENG | DEC | 6(2) | PRZ32V |
Key field | Non-key field |
How do I retrieve data from SAP table S110 using ABAP code
The following ABAP code Example will allow you to do a basic selection on S110 to SELECT all data from the tableDATA: WA_S110 TYPE S110.
SELECT SINGLE *
FROM S110
INTO CORRESPONDING FIELDS OF WA_S110
WHERE...
How to access SAP table S110
Within an ECC or HANA version of SAP you can also view further information about S110 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects