SAP ABAP Table S126 (Open Variants - Basis 1)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S126	Table Relationship Diagram
Short Description	Open Variants - Basis 1

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	VBELN	☑	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
9	POSNR	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
10	CUOBJ	☑	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
11	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
12	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
13	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
14	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
15	MCUPD	☐	MCUPD	X	CHAR	1	0	Indicator whether statistical record was updated
16	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
17	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
18	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
19	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
20	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
21	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
22	AEMENGE	☐	MC_AEMENGE	MENGV15_3	QUAN	15	3	Incoming orders quantity
23	AEMENGE_D	☐	AEMENGE_D	MENGV15_3	QUAN	15	3	Quantity of incoming orders - delata updating
24	AENETWR	☐	MC_AENETWR	WERTV10	CURR	19	2	Net value of incoming orders
25	AENETWR_D	☐	AENETWR_D	WERTV10	CURR	19	2	Net value of incoming orders - delta updating
26	AEKZWI1	☐	MC_AEKZWI1	WERTV9	CURR	17	2	Incoming orders: gross
27	AEKZWI1_D	☐	AEKZWI1_D	WERTV9	CURR	17	2	Gross incoming orders - delta updating
28	AEKZWI2	☐	MC_AEKZWI2	WERTV9	CURR	17	2	Incoming orders: net 1
29	AEKZWI2_D	☐	AEKZWI2_D	WERTV9	CURR	17	2	Net incoming orders 1 - delta updating
30	AEKZWI3	☐	MC_AEKZWI3	WERTV9	CURR	17	2	Incoming orders: net 2
31	AEKZWI3_D	☐	AEKZWI3_D	WERTV9	CURR	17	2	Net incoming orders 2 - delta updating
32	AEKZWI4	☐	MC_AEKZWI4	WERTV9	CURR	17	2	Incoming orders: freight
33	AEKZWI4_D	☐	AEKZWI4_D	WERTV9	CURR	17	2	Incoming orders (freight) - delta updating
34	AEKZWI5	☐	MC_AEKZWI5	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 5
35	AEKZWI5_D	☐	AEKZWI5_D	WERTV9	CURR	17	2	Incoming orders PrSub 5 - delta updating
36	AEKZWI6	☐	MC_AEKZWI6	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 6
37	AEKZWI6_D	☐	AEKZWI6_D	WERTV9	CURR	17	2	Incoming orders PrSub 6 - delta updating
38	AEMENGB	☐	AEMENGB	MENGV15_3	QUAN	15	3	Qty. incoming orders based on confirm. date of sched. line
39	AEMENGB_D	☐	AEMENGB_D	MENGV15_3	QUAN	15	3	QtyIO based on confirmation date of sched. line - DeltaUpdat
40	OEIMEB	☐	OEIMEB	MENGV15_3	QUAN	15	3	Open order qty. based on confirmation date of sched. line
41	OEIMEB_D	☐	OEIMEB_D	MENGV15_3	QUAN	15	3	Open order quantity based on conf. date of sched. line-delta
42	OEIMEW	☐	OEIMEW	MENGV15_3	QUAN	15	3	Open order qty. based on desired del. date of sched. line
43	OEIMEW_D	☐	OEIMEW_D	MENGV15_3	QUAN	15	3	Open order qty. based on desired del.date of sch.line- delta
44	OEIWEB	☐	OEIWEB	WERTV10	CURR	19	2	Open order value based on confirmation date of sched. line
45	OEIWEB_D	☐	OEIWEB_D	WERTV10	CURR	19	2	Open order val. based on conf. date of sched. line - delta
46	OEIWEW	☐	OEIWEW	WERTV10	CURR	19	2	Open order value based on desired del. date of sched. line
47	OEIWEW_D	☐	OEIWEW_D	WERTV10	CURR	19	2	Open ord. val. based on desired del. date sched.line - delta
48	LGMNG	☐	MC_LGMNG	MENGV15_3	QUAN	15	3	Delivery quantity in base unit of measure
49	LGMNG_D	☐	MC_LGMNG_D	MENGV15_3	QUAN	15	3	Delivery qty in base unit of measure - Delta update
50	UMNETWR	☐	MC_UMNETWR	WERTV10	CURR	19	2	Net value of invoiced sales
51	UMNETWR_D	☐	UMNETWR_D	WERTV10	CURR	19	2	Invoiced sales net value - Delta update

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S126	BASME	T006	MSEHI
2	S126	KUNNR	KNA1	KUNNR
3	S126	MANDT	T000	MANDT
4	S126	MATNR	MARA	MATNR
5	S126	POSNR	VBUP	POSNR
6	S126	SPART	TSPA	SPART
7	S126	STWAE	TCURC	WAERS
8	S126	VBELN	VBUK	VBELN
9	S126	VKORG	TVKO	VKORG
10	S126	VTWEG	TVKOV	VTWEG
11	S126	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in