SAP ABAP Table FRE_WALE_STY (Material to store assignment to promotion)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ WFRE_PI (Package) Connectivity with F&R

Basic Data

Table Category	INTTAB	Structure
Structure	FRE_WALE_STY	Table Relationship Diagram
Short Description	Material to store assignment to promotion

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Material to store assignment to promotion
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
4	ARTNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	MEBME	☐	W_MEBME	MEINS	UNIT	3	0	Sales unit	T006
6	KUNNR	☐	LOCNR	KUNNR	CHAR	10	0	Customer Number for Plant	KNA1
7	CLINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	KLAH
8	WALNR	☐	WA_WALNR	WA_NUM10	NUMC	10	0	Plant - material of promotion in message control
9	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
10	ERLIS	☐	ERLIS	ERLIS	CHAR	1	0	Error cat. after listing rule check
11	GENLI	☐	W_GENLI	FLAG	CHAR	1	0	Execute generation if listing check error detected
12	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
13	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
14	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
15	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
16	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
17	LIFNR	☐	W_LIFNR	LIFNR	CHAR	10	0	Vendor number	LFA1
18	LIFTY	☐	W_LIFTY	LIFTY	CHAR	1	0	Vendor Category - Retail
19	VZWRK	☐	W_VZWERK	WERKS	CHAR	4	0	Plant number for vendor number of DC	T001W
20	INFWK	☐	INFWK	XFELD	CHAR	1	0	Info record at plant level
21	VZEKO	☐	VZEKORG	EKORG	CHAR	4	0	Purchasing organization of distribution center	T024E
22	VZVKO	☐	VZVKORG	VKORG	CHAR	4	0	Sales organization of distribution center	TVKO
23	VZVTW	☐	VZVTWEG	VTWEG	CHAR	2	0	Distribution channel of distribution center	TVTW
24	VZSPA	☐	VZSPART	SPART	CHAR	2	0	Division of distribution center	TSPA
25	EXTLI	☐	W_EXTLI	LIFNR	CHAR	10	0	External vendor	LFA1
26	BZQFI	☐	W_BZQFI	BZQFA	CHAR	1	0	Supply Source Determination Status
27	BEKTB	☐	W_BEKTB	AAVIT	CHAR	4	0	Announcement category - plant	T626
28	BEKTV	☐	W_BEKTV	AAVIT	CHAR	4	0	Announcement category - distribution center	T626
29	ABDTB	☐	AFIDT	DATUM	DATS	8	0	Confirmation request date
30	RUDAB	☐	W_RUDAB	DATUM	DATS	8	0	Reply date plant
31	RUDAV	☐	W_RUDAV	DATUM	DATS	8	0	Reply date DC
32	RUSTB	☐	W_RUSTB	XFELD	CHAR	1	0	Status of reply to announcement - plant
33	RUSTV	☐	W_RUSTV	XFELD	CHAR	1	0	Status of reply to announcement - DC
34	BESTB	☐	W_BESTB	XFELD	CHAR	1	0	Confirmation can be carried out for plant
35	BESTV	☐	W_BESTV	XFELD	CHAR	1	0	Confirmation can be carried out for DC
36	AENDB	☐	W_AENDB	XFELD	CHAR	1	0	Send change to plant
37	AENDV	☐	W_AENDV	XFELD	CHAR	1	0	Send change to DC
38	PLEKP	☐	W_PLEKP_WALE	PREIS	CURR	11	2	Basic purchase price (gross) per plant/material
39	WAEEK	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
40	PLVKP	☐	W_PLVKP	PREIS	CURR	11	2	Sales price for promotion item
41	WAELA	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	TCURC
42	EKDAB	☐	W_EKDAB	DATUM	DATS	8	0	Purchase price conditions valid from
43	EKDBI	☐	W_EKDBI	DATUM	DATS	8	0	Purchase price conditions valid to
44	VKDAB	☐	W_VKDAB	DATUM	DATS	8	0	On Sale to Consumers From
45	VKDBI	☐	W_VKDBI	DATUM	DATS	8	0	On Sale To Consumers To
46	SPANE	☐	SPANE	WERTV6	CURR	11	2	Margin (net) in sales price calculation
47	SPABR	☐	SPABR	WERTV6	CURR	11	2	Margin (gross) in sales price calculation
48	AUFSG	☐	AUFSG	WERTV6	CURR	11	2	Actual Markup in Sales Price Calculation
49	VSPAN	☐	W_SPANE	WERTV6	CURR	11	2	Net warehouse margin
50	VSPAB	☐	W_SPABR	WERTV6	CURR	11	2	Gross warehouse margin
51	VAUFS	☐	W_AUFSG	WERTV6	CURR	11	2	Warehouse markup
52	VABGM	☐	W_MEBME	MEINS	UNIT	3	0	Sales unit	T006
53	VABGP	☐	W_VABGP	PREIS	CURR	11	2	Transfer price, distribution center
54	PARKZ	☐	W_PARKZ	W_PARKZ	CHAR	1	0	Price type indicator (gross, net)
55	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
56	VZEPE	☐	W_VZEPE	DEC5	DEC	5	0	Price unit Transfer price DC
57	VPEIN	☐	VPEIN	DEC5	DEC	5	0	Sales price unit
58	MEBPR	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
59	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
60	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
61	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
62	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
63	LIGEN	☐	W_LIGEN	LIGEN	CHAR	1	0	Listing generation status
64	AUGEN	☐	W_AUGEN	AKAST	CHAR	1	0	Allocation table creation status
65	VKGEN	☐	W_VKGEN	VKKPS	CHAR	1	0	Sales price generation status
66	EKGEN	☐	W_EKGEN	EKKPS	CHAR	1	0	Purchase price generation status
67	BEGEB	☐	W_BEGEB	BEKST	CHAR	1	0	Generation status of announcement - plant
68	BEGEV	☐	W_BEGEV	BEKST	CHAR	1	0	Announcement status - DC
69	BEDEB	☐	W_BEDEB	BEDEB	CHAR	1	0	Detailed status of promotion announcement - plant
70	BEDEV	☐	W_BEDEV	ABAST	CHAR	1	0	Detailed status of promotion announcement - DC
71	RELIF	☐	RELIF	XFELD	CHAR	1	0	Regular Vendor
72	ADGEN	☐	W_ADGEN	CHAR1	CHAR	1	0	Additionals maintained
73	WMNGE	☐	WMNGE	MENG13	QUAN	13	3	Quantity requested by store
74	AUFME	☐	W_BESTM	MENG13	QUAN	13	3	Corrected/confirmed allocation quantity for a promotion item
75	PABBM	☐	W_PABBM	MENGE	QUAN	13	3	Planned Sales Qty. of Promotion Material in Sales Units
76	MIAMG	☐	W_MIAMG	MENGE	QUAN	13	3	Minimum order qty for promotional material
77	EKPNN	☐	W_EKPNN	WERTV6	CURR	11	2	Purchase price (net/net)
78	VKPNN	☐	W_VKPNN	WERTV6	CURR	11	2	Sales price (net)
79	ECKPKZ	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
80	PAUFME	☐	W_PAUFME	MENG13	QUAN	13	3	Planned allocation quantity for promotion item for a plant
81	ALIVO	☐	ALIVO	DATUM	DATS	8	0	Starting date for activating DC transfer prices
82	ALIBI	☐	ALIBI	DATUM	DATS	8	0	Final date for activating DC transfer prices
83	EPRGR	☐	EPRGR	EPRGR	CHAR	6	0	Price point group	*
84	NVKP	☐	W_NVKP_WALE	PREIS	CURR	11	2	Standard sales price at plant level
85	SPGRU	☐	W_SPGRU	SPGRU	CHAR	1	0	Reason for promotion block
86	KUNNR_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
87	KUNNR_VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
88	KUNNR_TRIGGER	☐	FRE_DIF_TRIGGER	FRE_DIF_TRIGGER	CHAR	1	0	Trigger for DIF occurrence determination
89	LIFNR_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
90	LIFNR_VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
91	LIFNR_TRIGGER	☐	FRE_DIF_TRIGGER	FRE_DIF_TRIGGER	CHAR	1	0	Trigger for DIF occurrence determination

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FRE_WALE_STY	AKTHE	TWAT	AKTHE	KEY	1	CN
2	FRE_WALE_STY	AKTNR	WAKH	AKTNR	KEY	1	CN
3	FRE_WALE_STY	ARTNR	MARA	MATNR	KEY	1	CN
4	FRE_WALE_STY	BEKTB	T626	AAVIT
5	FRE_WALE_STY	BEKTV	T626	AAVIT
6	FRE_WALE_STY	CLINT	KLAH	CLINT
7	FRE_WALE_STY	EKGRP	T024	EKGRP		C	N
8	FRE_WALE_STY	EKORG	T024E	EKORG	KEY	1	CN
9	FRE_WALE_STY	EXTLI	LFA1	LIFNR
10	FRE_WALE_STY	KUNNR	KNA1	KUNNR
11	FRE_WALE_STY	LIFNR	LFA1	LIFNR	KEY	1	CN
12	FRE_WALE_STY	MANDT	T000	MANDT	KEY	1	CN
13	FRE_WALE_STY	MEBME	T006	MSEHI	KEY	1	CN
14	FRE_WALE_STY	MEBPR	T006	MSEHI	KEY	1	CN
15	FRE_WALE_STY	SPART	TSPA	SPART		C	N
16	FRE_WALE_STY	VABGM	T006	MSEHI
17	FRE_WALE_STY	VKORG	TVKO	VKORG	KEY	1	CN
18	FRE_WALE_STY	VTWEG	TVTW	VTWEG	KEY	1	CN
19	FRE_WALE_STY	VZEKO	T024E	EKORG		C	N
20	FRE_WALE_STY	VZSPA	TSPA	SPART		C	N
21	FRE_WALE_STY	VZVKO	TVKO	VKORG		C	N
22	FRE_WALE_STY	VZVTW	TVTW	VTWEG		C	N
23	FRE_WALE_STY	VZWRK	T001W	WERKS		C	N
24	FRE_WALE_STY	WAEEK	TCURC	WAERS	KEY	1	CN
25	FRE_WALE_STY	WAELA	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	617