S110 - OTB

OTB information is stored in SAP table S110.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".

Fields for table S110

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	3	T000
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	4
VRSIO	Version number in the information structure	X	VRSIO	CHAR	3	*
SPMON	Period to analyze - month	X	SPMON	NUMC	6
SPTAG	Period to analyze - current date	X	SPTAG	DATS	8
SPWOC	Period to analyze - week	X	SPWOC	NUMC	6
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	6
SAISO	Season Category	X	SAISO	CHAR	4	T6WSP
EKORG	Purchasing organization	X	EKORG	CHAR	4	T024E
VKORG	Sales Organization	X	VKORG	CHAR	4	TVKO
VTWEG	Distribution Channel	X	VTWEG	CHAR	2	TVTW
WGRU2	Material group hierarchy 2	X	MCW_WGRU2	CHAR	18
WGRU1	Material group hierarchy 1	X	MCW_WGRU1	CHAR	18
MATKL	Material Group	X	MATKL	CHAR	9	T023
PLGTP	Price Band Category	X	PLGTP	CHAR	2	TWPT
WERKS	Plant	X	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	10
UMSMNG	Sales quantity in base unit of measure		MCW_UMSMNG	QUAN	8
PRSNLS	Sales deviation during sales		MCW_PRSNLS	CURR	10
BSTGVP	Stock at retail with tax		MCW_BSTGVP	CURR	10
BSTMNG	Stock quantity in base unit of measure		MCW_BSTMNG	QUAN	8
BSTPROZ	Stock as % of sales volume		BESTPROZ	FLTP	8
UBGVP	Revaluations at sales price including tax		MCW_UBGVP	CURR	10
UBMNG	Revaluation quantity in BUn		UBMNG	QUAN	8
UBPROZ	Revaluations as a percentage		UBPROZ	FLTP	8
BKIVP	Stock adjustments: inventory difference at sales price + tax		MCW_BKIVP	CURR	10
BKIMNG	Stock adjustments: inventory differences as base unit qty		BKIMNG	QUAN	8
BKIPROZ	Stock adjustments: inventory differences as a %		BKIPROZ	FLTP	8
SBUDGVP	Seasonal budget at sales price including tax		GLIMGVP	CURR	10
SBUDMNG	Seasonal budget - quantity in base unit (BUn)		GLIMMNG	QUAN	8
VQUOTEPROZ	Initial purchasing quota (%)		VERT_LIM	FLTP	8
VLIMGVP	Budget already released at sales price including VAT		VBUDGVP	CURR	10
VBUDMNG	Budget Already Released - Quantity (Base Unit of Measure)		VLIMMNG	QUAN	8
RLIMGVP	Reserve budget SPwT		RBUDGVP	CURR	10
RLIMMNG	Reserve budget quantity in base unit of measure (BUn)		RLIMMNG	QUAN	8
BBSGVP	On-order stock at retail with tax		MCW_BBSGVP	CURR	10
BBSMNG	On-order stock quantity in BUn		MCW_BBSMNG	QUAN	8
ULBBSGVP	Open stock transport orders (delivering plant) at SPw/VAT		ULBBSGVP	CURR	10
ULBBSMNG	Open stock transport order qty (supplying plant) in BUn		ULBBSMNG	QUAN	8
UBBSGVP	Open stock transport orders at sales price including tax		UBBSGVP	CURR	10
UBBSMNG	Open stock transport order quantity in BUn		UBBSMNG	QUAN	8
ABGGVP	Issues at retail with tax		MCW_ABGGVP	CURR	10
ABGMNG	Issues quantity in BUn		MCW_ABGMNG	QUAN	8
SOTBGVP	OTB of seasonal budget at sales price including tax		OTBSGVP	CURR	10
SOTBMNG	OTB of seasonal budget in quantity of base unit		OTBSMNG	QUAN	8
VOTBGVP	OTB of budget already released at sales price including tax		OTBVGVP	CURR	10
VOTBMNG	Open-to-buy of budget already released in qty of base unit		OTBVMNG	QUAN	8
AVGVP	Average price of price band at sales price with tax		AVGVP	CURR	10
GLIMGVO	Seasonal budget at sales price without tax		GLIMGVO	CURR	10
GLIMGEO	Seasonal budget at purchase price without tax		GLIMGEO	CURR	10
VBUDGVO	Budget already released at sales price without VAT		VBUDGVO	CURR	10
VBUDGEO	Budget already released at purchase price without VAT		VBUDGEO	CURR	10
RBUDGVO	Reserve budget SPw/oVAT		RBUDGVO	CURR	10
RBUDGEO	Reserve budget PPw/oVAT		RBUDGEO	CURR	10
AVGVO	Average price band price at sales price without tax		AVGVO	CURR	10
AVGEO	Average price band price at purchase price without tax		AVGEO	CURR	10
UBGVO	Revaluations at sales price without tax		MCW_UBGVO	CURR	10
UBGEO	Revaluation PPw/oVAT		MCW_UBGEO	CURR	10
BKIVO	Stock adjustments: inventory difference at SPw/oVAT		MCW_BKIVO	CURR	10
BKIEO	Stock adjustments: inventory difference at PPw/oVAT		MCW_BKIEO	CURR	10
SOTBGVO	OTB of seasonal budget at sales price without tax		OTBSGVO	CURR	10
SOTBGEO	OTB of seasonal budget at purchase price without tax		OTBSGEO	CURR	10
VOTBGVO	OTB of budget already released at sales price without tax		OTBVGVO	CURR	10
VOTBGEO	OTB of budget already released at purchase price without tax		OTBVGEO	CURR	10
UBBSGVO	Open stock transport orders at sales price without tax		UBBSGVO	CURR	10
UBBSGEO	Open stock transport orders at PPw/oVAT		UBBSGEO	CURR	10
ULBBSGVO	Open stock transport orders (delivering plant) at SPw/oVAT		ULBBSGVO	CURR	10
ULBBSGEO	Open stock transport orders (delivering plant) at PPw/oVAT		ULBBSGEO	CURR	10
UMSGEO	Sales at cost		MCW_UMSGEO	CURR	10
UMSGVO	Sales at retail		MCW_UMSGVO	CURR	10
BSTGEO	Stock at cost		MCW_BSTGEO	CURR	10
BSTGVO	Stock at retail		MCW_BSTGVO	CURR	10
ABGGEO	Issues at cost		MCW_ABGGEO	CURR	10
ABGGVO	Issues at retail		MCW_ABGGVO	CURR	10
BBSGEO	On-order stock at cost		MCW_BBSGEO	CURR	10
BBSGVO	On-order stock at retail		MCW_BBSGVO	CURR	10
UMSMAO	Sales margin		MCW_UMSMAO	DEC	4
UMSMAM	Sales margin with tax		MCW_UMSMAM	DEC	4
WESMAO	Goods receipt margin (vendor+GR(DC))		MCW_WESMAO	DEC	4
WESMAM	Goods receipt margin with tax (vendor+GR(DC))		MCW_WESMAM	DEC	4
JUWERT	Annual inventory turn (value)		MCW_JUWERT	DEC	4
JUMENG	Annual inventory turn (quantity)		MCW_JUMENG	DEC	4