WALE - Material to store assignment to promotion

Material to store assignment to promotion information is stored in SAP table WALE.
It is part of development package WAKT in software component LO-RFM-MD-PR. This development package consists of objects that can be grouped under "Application development R/3 Promotions".

Fields for table WALE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
AKTNR	Promotion	X	WAKTION	CHAR	20	WAKH
ARTNR	Material Number	X	MATNR	CHAR	80	MARA
MEBME	Sales unit	X	W_MEBME	UNIT	6	T006
KUNNR	Customer Number for Plant	X	LOCNR	CHAR	20	KNA1
CLINT	Internal Class Number	X	CLINT	NUMC	20	KLAH
WALNR	Plant - material of promotion in message control		WA_WALNR	NUMC	20
AKTHE	Promotion theme		W_AKTHE	CHAR	8	TWAT
ERLIS	Error cat. after listing rule check		ERLIS	CHAR	2
GENLI	Execute generation if listing check error detected		W_GENLI	CHAR	2
VKORG	Sales Organization		VKORG	CHAR	8	TVKO
VTWEG	Distribution Channel		VTWEG	CHAR	4	TVTW
SPART	Division		SPART	CHAR	4	TSPA
EKORG	Purchasing organization		EKORG	CHAR	8	T024E
EKGRP	Purchasing Group		EKGRP	CHAR	6	T024
LIFNR	Supplier Number		W_LIFNR	CHAR	20	LFA1
LIFTY	Supplier Category - Retail		W_LIFTY	CHAR	2
VZWRK	Plant Number for Supplier Number of DC		W_VZWERK	CHAR	8	T001W
INFWK	Info record at plant level		INFWK	CHAR	2
VZEKO	Purchasing organization of distribution center		VZEKORG	CHAR	8	T024E
VZVKO	Sales organization of distribution center		VZVKORG	CHAR	8	TVKO
VZVTW	Distribution channel of distribution center		VZVTWEG	CHAR	4	TVTW
VZSPA	Division of distribution center		VZSPART	CHAR	4	TSPA
EXTLI	External Supplier		W_EXTLI	CHAR	20	LFA1
BZQFI	Supply Source Determination Status		W_BZQFI	CHAR	2
BEKTB	Announcement category - plant		W_BEKTB	CHAR	8	T626
BEKTV	Announcement category - distribution center		W_BEKTV	CHAR	8	T626
ABDTB	Confirmation request date		AFIDT	DATS	16
RUDAB	Reply date plant		W_RUDAB	DATS	16
RUDAV	Reply date DC		W_RUDAV	DATS	16
RUSTB	Status of reply to announcement - plant		W_RUSTB	CHAR	2
RUSTV	Status of reply to announcement - DC		W_RUSTV	CHAR	2
BESTB	Confirmation can be carried out for plant		W_BESTB	CHAR	2
BESTV	Confirmation can be carried out for DC		W_BESTV	CHAR	2
AENDB	Send change to plant		W_AENDB	CHAR	2
AENDV	Send change to DC		W_AENDV	CHAR	2
PLEKP	Basic purchase price (gross) per plant/material		W_PLEKP_WALE	CURR	6
WAEEK	Purchase price currency		W_WAEEK	CUKY	10	TCURC
PLVKP	Sales price for promotion item		W_PLVKP	CURR	6
WAELA	Currency Current Promotion - Planning		W_WAELA	CUKY	10	TCURC
EKDAB	Purchase price conditions valid from		W_EKDAB	DATS	16
EKDBI	Purchase price conditions valid to		W_EKDBI	DATS	16
VKDAB	On Sale to Consumers From		W_VKDAB	DATS	16
VKDBI	On Sale To Consumers To		W_VKDBI	DATS	16
SPANE	Margin (net) in sales price calculation		SPANE	CURR	6
SPABR	Margin (gross) in sales price calculation		SPABR	CURR	6
AUFSG	Actual Markup in Sales Price Calculation		AUFSG	CURR	6
VSPAN	Net warehouse margin		W_SPANE	CURR	6
VSPAB	Gross warehouse margin		W_SPABR	CURR	6
VAUFS	Warehouse markup		W_AUFSG	CURR	6
VABGM	Sales unit		W_MEBME	UNIT	6	T006
VABGP	Transfer price, distribution center		W_VABGP	CURR	6
PARKZ	Price type indicator (gross, net)		W_PARKZ	CHAR	2
EPEIN	Price unit		EPEIN	DEC	3
VZEPE	Price unit Transfer price DC		W_VZEPE	DEC	3
VPEIN	Sales price unit		VPEIN	DEC	3
MEBPR	Order Price Unit (Purchasing)		BBPRM	UNIT	6	T006
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
ERDAT	Date on which the record was created		ERDAT	DATS	16
AENAM	Name of Person Who Changed Object		AENAM	CHAR	24
AEDAT	Last Changed On		AEDAT	DATS	16
LIGEN	Listing generation status		W_LIGEN	CHAR	2
AUGEN	Allocation table creation status		W_AUGEN	CHAR	2
VKGEN	Sales price generation status		W_VKGEN	CHAR	2
EKGEN	Purchase price generation status		W_EKGEN	CHAR	2
BEGEB	Generation status of announcement - plant		W_BEGEB	CHAR	2
BEGEV	Announcement status - DC		W_BEGEV	CHAR	2
BEDEB	Detailed status of promotion announcement - plant		W_BEDEB	CHAR	2
BEDEV	Detailed status of promotion announcement - DC		W_BEDEV	CHAR	2
RELIF	Regular Supplier		RELIF	CHAR	2
ADGEN	Additionals maintained		W_ADGEN	CHAR	2
WMNGE	Quantity requested by store		WMNGE	QUAN	7
AUFME	Corrected/confirmed allocation quantity for a promotion item		W_BESTM	QUAN	7
PABBM	Planned Sales Qty. of Promotion Material in Sales Units		W_PABBM	QUAN	7
MIAMG	Minimum order qty for promotional material		W_MIAMG	QUAN	7
EKPNN	Purchase price (net/net)		W_EKPNN	CURR	6
VKPNN	Sales price (net)		W_VKPNN	CURR	6
ECKPKZ	Indicates whether price point tables should override price		F_VKPKZ	CHAR	2
PAUFME	Planned allocation quantity for promotion item for a plant		W_PAUFME	QUAN	7
ALIVO	Starting date for activating DC transfer prices		ALIVO	DATS	16
ALIBI	Final date for activating DC transfer prices		ALIBI	DATS	16
EPRGR	Price point group		EPRGR	CHAR	12	*
NVKP	Standard sales price at plant level		W_NVKP_WALE	CURR	6
SPGRU	Reason for promotion block		W_SPGRU	CHAR	2