SAP ABAP Table S127 (Open Variants - Basis 2)

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	S127	Table Relationship Diagram
Short Description	Open Variants - Basis 2

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	ATINN	☑	ATINN	ATINN	NUMC	10	0	Internal characteristic	*
12	ATWRT	☑	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
13	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
14	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
15	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
16	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
17	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
18	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
19	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
20	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
21	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
22	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
23	KLART	☐	KLASSENART	KLASSENART	CHAR	3	0	Class Type	TCLA
24	AEMENGE	☐	MC_AEMENGE	MENGV15_3	QUAN	15	3	Incoming orders quantity
25	AEFREQ	☐	MC_AEFREQ	DECV15_3	DEC	15	3	Incoming orders: frequency
26	AENETWR	☐	MC_AENETWR	WERTV10	CURR	19	2	Net value of incoming orders
27	AEKZWI1	☐	MC_AEKZWI1	WERTV9	CURR	17	2	Incoming orders: gross
28	AEKZWI2	☐	MC_AEKZWI2	WERTV9	CURR	17	2	Incoming orders: net 1
29	AEKZWI3	☐	MC_AEKZWI3	WERTV9	CURR	17	2	Incoming orders: net 2
30	AEKZWI4	☐	MC_AEKZWI4	WERTV9	CURR	17	2	Incoming orders: freight
31	AEKZWI5	☐	MC_AEKZWI5	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 5
32	AEKZWI6	☐	MC_AEKZWI6	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 6
33	AEMENGB	☐	AEMENGB	MENGV15_3	QUAN	15	3	Qty. incoming orders based on confirm. date of sched. line
34	AEFREQB	☐	MC_AEFREQB	DECV15_3	DEC	15	3	Incoming orders: frequency acc. to conf. date of sched. line
35	OEIMEB	☐	OEIMEB	MENGV15_3	QUAN	15	3	Open order qty. based on confirmation date of sched. line
36	OEFREQB	☐	MC_OEFREQB	DECV15_3	DEC	15	3	Open incoming orders: freq acc. to conf. date of sched. line
37	OEIMEW	☐	OEIMEW	MENGV15_3	QUAN	15	3	Open order qty. based on desired del. date of sched. line
38	OEFREQW	☐	MC_OEFREQW	DECV15_3	DEC	15	3	Open incoming orders: freq acc. to desired dlv. date of SL
39	OEIWEB	☐	OEIWEB	WERTV10	CURR	19	2	Open order value based on confirmation date of sched. line
40	OEIWEW	☐	OEIWEW	WERTV10	CURR	19	2	Open order value based on desired del. date of sched. line
41	LGMNG	☐	MC_LGMNG	MENGV15_3	QUAN	15	3	Delivery quantity in base unit of measure
42	LGFREQ	☐	MC_LGFREQ	DECV15_3	DEC	15	3	Delivery frequency in base unit of measure
43	UMNETWR	☐	MC_UMNETWR	WERTV10	CURR	19	2	Net value of invoiced sales

Foreign Keys

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

History

Last changed by/on	SAP	20050411
SAP Release Created in