S126 - Open Variants - Basis 1

Open Variants - Basis 1 information is stored in SAP table S126.
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 S126

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
VRSIO	Version number in the information structure	X	VRSIO	CHAR	6
SPMON	Period to analyze - month	X	SPMON	NUMC	12
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
SPWOC	Period to analyze - week	X	SPWOC	NUMC	12
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	12
VBELN	Sales Document	X	VBELN_VA	CHAR	20
POSNR	Sales Document Item	X	POSNR_VA	NUMC	12
CUOBJ	Configuration	X	CUOBJ_VA	NUMC	36
PERIV	Fiscal Year Variant		PERIV	CHAR	4
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
BASME	Base Unit of Measure		MEINS	UNIT	6	T006
STWAE	Statistics Currency		STWAE	CUKY	10	TCURC
MCUPD	Indicator whether statistical record was updated		MCUPD	CHAR	2
VKORG	Sales Organization		VKORG	CHAR	8	TVKO
VTWEG	Distribution Channel		VTWEG	CHAR	4	TVKOV
SPART	Division		SPART	CHAR	4	TSPA
KUNNR	Sold-to Party		KUNAG	CHAR	20	KNA1
WERKS	Plant		WERKS_D	CHAR	8	T001W
MATNR	Material Number		MATNR	CHAR	80	MARA
AEMENGE	Incoming Orders Quantity		MC_AEMENGE	QUAN	8
AEMENGE_D	Quantity of incoming orders - delata updating		AEMENGE_D	QUAN	8
AENETWR	Net Value of Incoming Orders		MC_AENETWR	CURR	10
AENETWR_D	Net value of incoming orders - delta updating		AENETWR_D	CURR	10
AEKZWI1	Incoming orders: gross		MC_AEKZWI1	CURR	9
AEKZWI1_D	Gross incoming orders - delta updating		AEKZWI1_D	CURR	9
AEKZWI2	Incoming orders: net 1		MC_AEKZWI2	CURR	9
AEKZWI2_D	Net incoming orders 1 - delta updating		AEKZWI2_D	CURR	9
AEKZWI3	Incoming orders: net 2		MC_AEKZWI3	CURR	9
AEKZWI3_D	Net incoming orders 2 - delta updating		AEKZWI3_D	CURR	9
AEKZWI4	Incoming orders: freight		MC_AEKZWI4	CURR	9
AEKZWI4_D	Incoming orders (freight) - delta updating		AEKZWI4_D	CURR	9
AEKZWI5	Incoming orders: pricing subtotal 5		MC_AEKZWI5	CURR	9
AEKZWI5_D	Incoming orders PrSub 5 - delta updating		AEKZWI5_D	CURR	9
AEKZWI6	Incoming orders: pricing subtotal 6		MC_AEKZWI6	CURR	9
AEKZWI6_D	Incoming orders PrSub 6 - delta updating		AEKZWI6_D	CURR	9
AEMENGB	Qty. incoming orders based on confirm. date of sched. line		AEMENGB	QUAN	8
AEMENGB_D	QtyIO based on confirmation date of sched. line - DeltaUpdat		AEMENGB_D	QUAN	8
OEIMEB	Open order qty. based on confirmation date of sched. line		OEIMEB	QUAN	8
OEIMEB_D	Open order quantity based on conf. date of sched. line-delta		OEIMEB_D	QUAN	8
OEIMEW	Open order qty. based on desired del. date of sched. line		OEIMEW	QUAN	8
OEIMEW_D	Open order qty. based on desired del.date of sch.line- delta		OEIMEW_D	QUAN	8
OEIWEB	Open order value based on confirmation date of sched. line		OEIWEB	CURR	10
OEIWEB_D	Open order val. based on conf. date of sched. line - delta		OEIWEB_D	CURR	10
OEIWEW	Open order value based on desired del. date of sched. line		OEIWEW	CURR	10
OEIWEW_D	Open ord. val. based on desired del. date sched.line - delta		OEIWEW_D	CURR	10
LGMNG	Delivery quantity in base unit of measure		MC_LGMNG	QUAN	8
LGMNG_D	Delivery qty in base unit of measure - Delta update		MC_LGMNG_D	QUAN	8
UMNETWR	Net Value of Invoiced Sales		MC_UMNETWR	CURR	10
UMNETWR_D	Invoiced sales net value - Delta update		UMNETWR_D	CURR	10