SAP Table S110
OTB
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table S110 (OTB) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S110 |
| Short Text | OTB |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S110
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SSOUR | ✔ | Statistic(s) origin | SSOUR | CHAR | 4 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| SPWOC | ✔ | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | ✔ | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| SAISO | ✔ | Season Category | SAISO | CHAR | 4 | T6WSP |
| EKORG | ✔ | Purchasing Organization | EKORG | CHAR | 4 | T024E |
| VKORG | ✔ | Sales Organization | VKORG | CHAR | 4 | TVKO |
| VTWEG | ✔ | Distribution Channel | VTWEG | CHAR | 2 | TVTW |
| WGRU2 | ✔ | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 18 | |
| WGRU1 | ✔ | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 18 | |
| MATKL | ✔ | Material Group | MATKL | CHAR | 9 | T023 |
| PLGTP | ✔ | Price Band Category | PLGTP | CHAR | 2 | TWPT |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | |
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 19 | ||
| UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 15 | ||
| PRSNLS | Sales deviation during sales | MCW_PRSNLS | CURR | 19 | ||
| BSTGVP | Stock at retail with tax | MCW_BSTGVP | CURR | 19 | ||
| BSTMNG | Stock quantity in base unit of measure | MCW_BSTMNG | QUAN | 15 | ||
| BSTPROZ | Stock as % of sales volume | BESTPROZ | FLTP | 16 | ||
| UBGVP | Revaluations at sales price including tax | MCW_UBGVP | CURR | 19 | ||
| UBMNG | Revaluation quantity in BUn | UBMNG | QUAN | 15 | ||
| UBPROZ | Revaluations as a percentage | UBPROZ | FLTP | 16 | ||
| BKIVP | Stock adjustments: inventory difference at sales price + tax | MCW_BKIVP | CURR | 19 | ||
| BKIMNG | Stock adjustments: inventory differences as base unit qty | BKIMNG | QUAN | 15 | ||
| BKIPROZ | Stock adjustments: inventory differences as a % | BKIPROZ | FLTP | 16 | ||
| SBUDGVP | Seasonal budget at sales price including tax | GLIMGVP | CURR | 19 | ||
| SBUDMNG | Seasonal budget - quantity in base unit (BUn) | GLIMMNG | QUAN | 15 | ||
| VQUOTEPROZ | Initial purchasing quota (%) | VERT_LIM | FLTP | 16 | ||
| VLIMGVP | Budget already released at sales price including VAT | VBUDGVP | CURR | 19 | ||
| VBUDMNG | Budget Already Released - Quantity (Base Unit of Measure) | VLIMMNG | QUAN | 15 | ||
| RLIMGVP | Reserve budget SPwT | RBUDGVP | CURR | 19 | ||
| RLIMMNG | Reserve budget quantity in base unit of measure (BUn) | RLIMMNG | QUAN | 15 | ||
| BBSGVP | On-order stock at retail with tax | MCW_BBSGVP | CURR | 19 | ||
| BBSMNG | On-order stock quantity in BUn | MCW_BBSMNG | QUAN | 15 | ||
| ULBBSGVP | Open stock transport orders (delivering plant) at SPw/VAT | ULBBSGVP | CURR | 19 | ||
| ULBBSMNG | Open stock transport order qty (supplying plant) in BUn | ULBBSMNG | QUAN | 15 | ||
| UBBSGVP | Open stock transport orders at sales price including tax | UBBSGVP | CURR | 19 | ||
| UBBSMNG | Open stock transport order quantity in BUn | UBBSMNG | QUAN | 15 | ||
| ZUGGVP | Receipts at retail with tax | MCW_ZUGGVP | CURR | 19 | ||
| ZUGMNG | Receipts quantity in BUn | MCW_ZUGMNG | QUAN | 15 | ||
| ABGGVP | Issues at retail with tax | MCW_ABGGVP | CURR | 19 | ||
| ABGMNG | Issues quantity in BUn | MCW_ABGMNG | QUAN | 15 | ||
| SOTBGVP | OTB of seasonal budget at sales price including tax | OTBSGVP | CURR | 19 | ||
| SOTBMNG | OTB of seasonal budget in quantity of base unit | OTBSMNG | QUAN | 15 | ||
| VOTBGVP | OTB of budget already released at sales price including tax | OTBVGVP | CURR | 19 | ||
| VOTBMNG | Open-to-buy of budget already released in qty of base unit | OTBVMNG | QUAN | 15 | ||
| AVGVP | Average price of price band at sales price with tax | AVGVP | CURR | 19 | ||
| GLIMGVO | Seasonal budget at sales price without tax | GLIMGVO | CURR | 19 | ||
| GLIMGEO | Seasonal budget at purchase price without tax | GLIMGEO | CURR | 19 | ||
| VBUDGVO | Budget already released at sales price without VAT | VBUDGVO | CURR | 19 | ||
| VBUDGEO | Budget already released at purchase price without VAT | VBUDGEO | CURR | 19 | ||
| RBUDGVO | Reserve budget SPw/oVAT | RBUDGVO | CURR | 19 | ||
| RBUDGEO | Reserve budget PPw/oVAT | RBUDGEO | CURR | 19 | ||
| AVGVO | Average price band price at sales price without tax | AVGVO | CURR | 19 | ||
| AVGEO | Average price band price at purchase price without tax | AVGEO | CURR | 19 | ||
| UBGVO | Revaluations at sales price without tax | MCW_UBGVO | CURR | 19 | ||
| UBGEO | Revaluation PPw/oVAT | MCW_UBGEO | CURR | 19 | ||
| BKIVO | Stock adjustments: inventory difference at SPw/oVAT | MCW_BKIVO | CURR | 19 | ||
| BKIEO | Stock adjustments: inventory difference at PPw/oVAT | MCW_BKIEO | CURR | 19 | ||
| SOTBGVO | OTB of seasonal budget at sales price without tax | OTBSGVO | CURR | 19 | ||
| SOTBGEO | OTB of seasonal budget at purchase price without tax | OTBSGEO | CURR | 19 | ||
| VOTBGVO | OTB of budget already released at sales price without tax | OTBVGVO | CURR | 19 | ||
| VOTBGEO | OTB of budget already released at purchase price without tax | OTBVGEO | CURR | 19 | ||
| UBBSGVO | Open stock transport orders at sales price without tax | UBBSGVO | CURR | 19 | ||
| UBBSGEO | Open stock transport orders at PPw/oVAT | UBBSGEO | CURR | 19 | ||
| ULBBSGVO | Open stock transport orders (delivering plant) at SPw/oVAT | ULBBSGVO | CURR | 19 | ||
| ULBBSGEO | Open stock transport orders (delivering plant) at PPw/oVAT | ULBBSGEO | CURR | 19 | ||
| UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 19 | ||
| UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 19 | ||
| BSTGEO | Stock at cost | MCW_BSTGEO | CURR | 19 | ||
| BSTGVO | Stock at retail | MCW_BSTGVO | CURR | 19 | ||
| ABGGEO | Issues at cost | MCW_ABGGEO | CURR | 19 | ||
| ABGGVO | Issues at retail | MCW_ABGGVO | CURR | 19 | ||
| ZUGGEO | Receipts at cost | MCW_ZUGGEO | CURR | 19 | ||
| ZUGGVO | Receipts at retail | MCW_ZUGGVO | CURR | 19 | ||
| BBSGEO | On-order stock at cost | MCW_BBSGEO | CURR | 19 | ||
| BBSGVO | On-order stock at retail | MCW_BBSGVO | CURR | 19 | ||
| UMSMAO | Sales margin | MCW_UMSMAO | DEC | 6 | ||
| UMSMAM | Sales margin with tax | MCW_UMSMAM | DEC | 6 | ||
| WESMAO | Goods receipt margin (vendor+GR(DC)) | MCW_WESMAO | DEC | 6 | ||
| WESMAM | Goods receipt margin with tax (vendor+GR(DC)) | MCW_WESMAM | DEC | 6 | ||
| JUWERT | Annual inventory turn (value) | MCW_JUWERT | DEC | 6 | ||
| JUMENG | Annual inventory turn (quantity) | MCW_JUMENG | DEC | 6 |