SAP ABAP Table WAKL2 (Structure for Report Promotion: Material-Customer (WAGU))

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	WAKL2	Table Relationship Diagram
Short Description	Structure for Report Promotion: Material-Customer (WAGU)

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	FILNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	*
2	NAME1	☐	W_WKBEZ	TEXT30	CHAR	30	0	Plant description
3	CLASS	☐	W_FILGR	KLASSE	CHAR	18	0	Plant grouping, sales promotion
4	.INCLUDE	☐				0	0	Validity of plant groups - IS-R
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
7	CLINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	KLAH
8	AVKVO	☐	W_AVKVO	DATUM	DATS	8	0	Start of promotion sales
9	AVKBI	☐	W_AVKBI	DATUM	DATS	8	0	End of promotion sales - IS-R
10	ALIVO	☐	W_ALIVO	DATUM	DATS	8	0	Start of promotion listing
11	ALIBI	☐	W_ALIBI	DATUM	DATS	8	0	End of promotion listing
12	AWEFI	☐	W_AWEFI	DATUM	DATS	8	0	Goods receipt promotional merchandise in plant
13	ETIAG	☐	W_ETIAG	ETIAG	CHAR	18	0	IS-R Labeling: material grouping (deactivated in 4.0)	TWEA
14	BEKTY	☐	W_BEKTY	AAVIT	CHAR	4	0	Promotion announcement category	T626
15	ABEKM	☐	W_ABEKM	DATUM	DATS	8	0	Announcement date of the promotion
16	STBEK	☐	W_STBEK	BEKST	CHAR	1	0	Promotion announcement status
17	RUDAT	☐	W_RUDAT	DATUM	DATS	8	0	Latest date for replying to promotion announcement
18	NBSZO	☐	W_NBSZO	INT2	INT2	5	0	No. of plant group to module assignments
19	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
21	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
22	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
23	FADAT	☐	W_FADAT	DATUM	DATS	8	0	Earliest Order Date
24	SADAT	☐	W_SADAT	DATUM	DATS	8	0	Latest Order Date
25	FLDAT	☐	W_FLDAT	DATUM	DATS	8	0	Earliest delivery date
26	SLDAT	☐	W_SLDAT	DATUM	DATS	8	0	Latest delivery date
27	KLART	☐	W_KLART	KLASSENART	CHAR	3	0	Class type	TWRF16
28	VLGNR	☐	W_VLGNR	KUNNR	CHAR	10	0	Customer no. of reference plant	KNA1
29	VKORG	☐	W_VERKORG	VKORG	CHAR	4	0	Sales organization	TVKO
30	VTWEG	☐	W_VERTWEG	VTWEG	CHAR	2	0	Distribution channel	TVKOV
31	KALKE	☐	W_AKTART	AKTART	CHAR	1	0	Activation type for sales prices
32	.INCLU--AP	☐				0	0	Additional Fields for Add-On Seasonal Procurement
33	STPLGR	☐	WRF_STPLGR	WRF_STPLGR	CHAR	1	0	Status of Plant Group

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WAKL2	AKTNR	WAKH	AKTNR	KEY	1	CN
2	WAKL2	BEKTY	T626	AAVIT		C	N
3	WAKL2	CLINT	KLAH	CLINT	KEY	1	CN
4	WAKL2	ETIAG	TWEA	ARTGR		C	N
5	WAKL2	KLART	TWRF16	KLART		1	N
6	WAKL2	MANDT	T000	MANDT	KEY	1	CN
7	WAKL2	VKORG	TVKO	VKORG		1	CN
8	WAKL2	VLGNR	KNA1	KUNNR		1	CN
9	WAKL2	VTWEG	TVKOV	VTWEG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in