SAP ABAP Table S410 (SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIF (Package) MRN Marketing Retail Networks

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S410	Table Relationship Diagram
Short Description	SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR

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	OIPBLP	☑	OIF_PBLNRP	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
9	KUNNR	☑	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
10	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
11	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
12	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
13	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
15	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
16	STWAE	☐	WAERS_V	WAERS	CUKY	5	0	Statistics currency	*
17	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
18	AENETWR	☐	MC_AENETWR	WERTV10	CURR	19	2	Net value of incoming orders
19	UMNETWR	☐	MC_UMNETWR	WERTV10	CURR	19	2	Net value of invoiced sales
20	OAUWE	☐	MC_OAUWE	WERTV10	CURR	19	2	Open net value of orders
21	RENETWR	☐	MC_RENETWR	WERTV10	CURR	19	2	Net value of incoming returns
22	GUNETWR	☐	MC_GUNETWR	WERTV10	CURR	19	2	Net value of credit memos
23	AEMENGE	☐	MC_AEMENGE	MENGV15_3	QUAN	15	3	Incoming orders quantity
24	UMMENGE	☐	MC_UMMENGE	MENGV15_3	QUAN	15	3	Sales quantity
25	OAUME	☐	MC_OAUME	MENGV15_3	QUAN	15	3	Open orders quantity in base unit of measure
26	REMENGE	☐	MC_REMENGE	MENGV15_3	QUAN	15	3	Returns Quantity
27	GUMENGE	☐	MC_GUMENGE	MENGV15_3	QUAN	15	3	Credit memos quantity
28	ANZAUPOS	☐	MC_ANZAUPO	MCZAEHLER	DEC	9	0	Number of order items
29	ANZREPOS	☐	MC_ANZREPO	MCZAEHLER	DEC	9	0	No.of returns items
30	AEWAVWR	☐	MC_AEWAVWR	WERTV10	CURR	19	2	Cost of incoming orders
31	UMWAVWR	☐	MC_UMWAVWR	WERTV10	CURR	19	2	Cost of invoiced sales
32	REWAVWR	☐	MC_REWAVWR	WERTV10	CURR	19	2	Incoming returns: cost
33	GUWAVWR	☐	MC_GUWAVWR	WERTV10	CURR	19	2	Credit memos: cost
34	AEKZWI1	☐	MC_AEKZWI1	WERTV9	CURR	17	2	Incoming orders: gross
35	UMKZWI1	☐	MC_UMKZWI1	WERTV9	CURR	17	2	Invoiced sales: gross
36	REKZWI1	☐	MC_REKZWI1	WERTV9	CURR	17	2	Incoming returns: gross
37	GUKZWI1	☐	MC_GUKZWI1	WERTV9	CURR	17	2	Credit memos: gross
38	AEKZWI2	☐	MC_AEKZWI2	WERTV9	CURR	17	2	Incoming orders: net 1
39	UMKZWI2	☐	MC_UMKZWI2	WERTV9	CURR	17	2	Invoiced sales: net 1
40	REKZWI2	☐	MC_REKZWI2	WERTV9	CURR	17	2	Incoming returns: net 1
41	GUKZWI2	☐	MC_GUKZWI2	WERTV9	CURR	17	2	Credit memos: net 1
42	AEKZWI3	☐	MC_AEKZWI3	WERTV9	CURR	17	2	Incoming orders: net 2
43	UMKZWI3	☐	MC_UMKZWI3	WERTV9	CURR	17	2	Invoiced sales: net 2
44	REKZWI3	☐	MC_REKZWI3	WERTV9	CURR	17	2	Incoming returns: net 2
45	GUKZWI3	☐	MC_GUKZWI3	WERTV9	CURR	17	2	Credit memos: net 2
46	AEKZWI4	☐	MC_AEKZWI4	WERTV9	CURR	17	2	Incoming orders: freight
47	UMKZWI4	☐	MC_UMKZWI4	WERTV9	CURR	17	2	Invoice freight charges
48	REKZWI4	☐	MC_REKZWI4	WERTV9	CURR	17	2	Incoming returns: freight
49	GUKZWI4	☐	MC_GUKZWI4	WERTV9	CURR	17	2	Credit memos: freight
50	AEKZWI5	☐	MC_AEKZWI5	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 5
51	UMKZWI5	☐	MC_UMKZWI5	WERTV9	CURR	17	2	Billing document: pricing subtotal 5
52	REKZWI5	☐	MC_REKZWI5	WERTV9	CURR	17	2	Incoming returns: pricing subtotal 5
53	GUKZWI5	☐	MC_GUKZWI5	WERTV9	CURR	17	2	Credit memos: pricing subtotal 5
54	AEKZWI6	☐	MC_AEKZWI6	WERTV9	CURR	17	2	Incoming orders: pricing subtotal 6
55	UMKZWI6	☐	MC_UMKZWI6	WERTV9	CURR	17	2	Billing document: pricing subtotal 6
56	REKZWI6	☐	MC_REKZWI6	WERTV9	CURR	17	2	Incoming returns: pricing subtotal 6
57	GUKZWI6	☐	MC_GUKZWI6	WERTV9	CURR	17	2	Credit memos: pricing subtotal 6

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S410	KUNNR	KNA1	KUNNR	KEY	1	CN
2	S410	MANDT	T000	MANDT	KEY	1	CN
3	S410	MATNR	MARA	MATNR	KEY	1	CN
4	S410	OIPBLP	OIFSPBL	PBLNR		1	CN
5	S410	PERIV	T009	PERIV	REF	C	CN
6	S410	SPART	TSPA	SPART	KEY	1	CN
7	S410	VKORG	TVKO	VKORG	KEY	1	CN
8	S410	VTWEG	TVTW	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in