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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WAKT (Package) Application development R/3 Promotions

Basic Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in