SAP ABAP Table WAKL3 (Structure for Report Promotion: Material-Customer (WALE))

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	WAKL3	Table Relationship Diagram
Short Description	Structure for Report Promotion: Material-Customer (WALE)

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

History

Last changed by/on	SAP	20130529
SAP Release Created in