SAP ABAP Table S128 (Open Variants - SIS)

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	S128	Table Relationship Diagram
Short Description	Open Variants - SIS

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

History

Last changed by/on	SAP	20050411
SAP Release Created in