SAP ABAP Table S086 (Promotion)

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	S086	Table Relationship Diagram
Short Description	Promotion

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	AKTNR	☑	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
9	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	BTRKZ	☑	VLFKZ	VLFKZ	CHAR	1	0	Plant category
11	WGRU2	☑	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
12	WGRU1	☑	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
13	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
14	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
15	AKTYP	☑	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
16	AKTHE	☑	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
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	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
21	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
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	WESMNG	☐	MCW_WESMNG	MENGV15_3	QUAN	15	3	Goods receipt (vendor) quantity in BUn
27	WESGEO	☐	MCW_WESGEO	WERTV10	CURR	19	2	Goods receipt (vendor) at cost
28	WESGVO	☐	MCW_WESGVO	WERTV10	CURR	19	2	Goods receipt (vendor) at retail
29	WESGVP	☐	MCW_WESGVP	WERTV10	CURR	19	2	Goods receipt (vendor) at retail with tax
30	WESANZ	☐	MCW_WESANZ	MCZAEHLINT	INT4	10	0	Goods receipt (vendor) number of transactions
31	KMEMNG	☐	MCW_KMEMNG	MENGV15_3	QUAN	15	3	Goods receipt (distribution center) quantity in BUn
32	KMEGEO	☐	MCW_KMEGEO	WERTV10	CURR	19	2	Goods receipt (DC) at cost
33	KMEGVO	☐	MCW_KMEGVO	WERTV10	CURR	19	2	Goods receipt (DC) at retail
34	KMEGVP	☐	MCW_KMEGVP	WERTV10	CURR	19	2	Goods receipt (dist. center) at retail with tax
35	KMEANZ	☐	MCW_KMEANZ	MCZAEHLINT	INT4	10	0	Goods receipt (distribution center), no. of transactions
36	KMAMNG	☐	MCW_KMAMNG	MENGV15_3	QUAN	15	3	Goods issue (distribution center) quantity in BUn
37	KMAGEO	☐	MCW_KMAGEO	WERTV10	CURR	19	2	Goods issue (DC) at cost
38	KMAGVO	☐	MCW_KMAGVO	WERTV10	CURR	19	2	Goods issue (DC) at retail
39	KMAGVP	☐	MCW_KMAGVP	WERTV10	CURR	19	2	Goods issue (dist. center) at retail with tax
40	KMAANZ	☐	MCW_KMAANZ	MCZAEHLINT	INT4	10	0	Goods issue (distribution center), no. of transactions
41	BVLMNG	☐	MCW_BVLMNG	MENGV15_3	QUAN	15	3	Order volume quantity Retail
42	BVLGEO	☐	MCW_BVLGEO	WERTV10	CURR	19	2	Order volume at cost
43	BVLGVO	☐	MCW_BVLGVO	WERTV10	CURR	19	2	Order volume at retail
44	BVLGVP	☐	MCW_BVLGVP	WERTV10	CURR	19	2	Order volume at retail with tax
45	BVLANZ	☐	MCW_BVLANZ	MCZAEHLINT	INT4	10	0	Order volume, number of transactions
46	WESMAO	☐	MCW_WESMAO	PRZ32V	DEC	6	2	Goods receipt margin (vendor+GR(DC))
47	WESMAM	☐	MCW_WESMAM	PRZ32V	DEC	6	2	Goods receipt margin with tax (vendor+GR(DC))
48	UMSMAO	☐	MCW_UMSMAO	PRZ32V	DEC	6	2	Sales margin
49	UMSMAM	☐	MCW_UMSMAM	PRZ32V	DEC	6	2	Sales margin with tax
50	BVLMAO	☐	MCW_BVLMAO	PRZ32V	DEC	6	2	Order volume margin
51	BVLMAM	☐	MCW_BVLMAM	PRZ32V	DEC	6	2	Order volume margin with tax

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S086	AKTHE	TWAT	AKTHE
2	S086	AKTNR	WAKH	AKTNR
3	S086	AKTYP	TWTY	AKTYP
4	S086	BASME	T006	MSEHI
5	S086	HWAER	TCURC	WAERS
6	S086	MANDT	T000	MANDT
7	S086	MATKL	T023	MATKL
8	S086	MATNR	MARA	MATNR
9	S086	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in