SAP ABAP Table S218 (MAP: AvgRetail BUP)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MAP (Application Component) Merchandise and Assortment Planning
     ⤷ WIS_PLAN (Package) Retail: Planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S218	Table Relationship Diagram
Short Description	MAP: AvgRetail BUP

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	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
3	WGRU2	☑	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
4	WGRU1	☑	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
5	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
6	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	AVGWS	☑	WISP_AVGWS	WAERS	CUKY	5	0	Currency Key for Average Retail	TCURC
9	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
10	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
11	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
12	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
13	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
14	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
15	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
16	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
17	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
18	AVGWS_D	☐	WISP_AVGW1	WAERS	CUKY	5	0	Memory Currency 1 in Currency Fields for Average Retail	TCURC
19	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
20	UBMVPM	☐	MCW_UBMVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, minus, quantity
21	UBPVPM	☐	MCW_UBPVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, plus, quantity
22	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
23	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
24	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
25	PRSNLS	☐	MCW_PRSNLS	WERTV10	CURR	19	2	Sales deviation during sales
26	UBPGVO	☐	MCW_UBPGVO	WERTV10	CURR	19	2	Revaluation at retail, plus
27	UBPGVP	☐	MCW_UBPGVP	WERTV10	CURR	19	2	Revaluation at retail, plus, at retail with tax
28	UBMGVO	☐	MCW_UBMGVO	WERTV10	CURR	19	2	Revaluation at retail, minus
29	UBMGVP	☐	MCW_UBMGVP	WERTV10	CURR	19	2	Revaluation at retail, minus, at retail with tax
30	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
31	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
32	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
33	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
34	LIFNR	☐	MCW_RLIFN	LIFNR	CHAR	10	0	Account number of regular vendor	LFA1
35	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
36	UMMENGE	☐	MC_UMMENGE	MENGV15_3	QUAN	15	3	Sales quantity

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S218	AVGWS	TCURC	WAERS	KEY
2	S218	AVGWS_D	TCURC	WAERS
3	S218	BASME	T006	MSEHI
4	S218	LIFNR	LFA1	LIFNR
5	S218	MANDT	T000	MANDT	KEY
6	S218	MATKL	T023	MATKL	KEY
7	S218	MATNR	MARA	MATNR	KEY
8	S218	MEINS	T006	MSEHI
9	S218	PLGTP	TWPT	PLGTP
10	S218	VRKME	T006	MSEHI
11	S218	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20050411
SAP Release Created in	46C