1. Home
  2. Resources
  3. SAP Tables
  4. WALE - Material to store assignment to promotion

SAP Table WALE

Material to store assignment to promotion

WALE (Material to store assignment to promotion) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WALE to other SAP tables.

WALE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AKTNR Promotion WAKTION WAKH CHAR 10 0
ARTNR Material Number MATNR MARA CHAR 18 0
MEBME Sales unit W_MEBME T006 UNIT 3 0
KUNNR Customer Number for Plant LOCNR KNA1 CHAR 10 0
CLINT Internal Class Number CLINT KLAH NUMC 10 0
WALNR Plant - material of promotion in message control WA_WALNR NUMC 10 0
AKTHE Promotion theme W_AKTHE TWAT CHAR 4 0
ERLIS Error cat. after listing rule check ERLIS CHAR 1 0
GENLI Execute generation if listing check error detected W_GENLI CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
LIFNR Vendor number W_LIFNR LFA1 CHAR 10 0
LIFTY Vendor Category - Retail W_LIFTY CHAR 1 0
A External vendor
B Internal vendor - distribution center
C Internal vendor - store
VZWRK Plant number for vendor number of DC W_VZWERK T001W CHAR 4 0
INFWK Info record at plant level INFWK CHAR 1 0
X Yes
NULL No
VZEKO Purchasing organization of distribution center VZEKORG T024E CHAR 4 0
VZVKO Sales organization of distribution center VZVKORG TVKO CHAR 4 0
VZVTW Distribution channel of distribution center VZVTWEG TVTW CHAR 2 0
VZSPA Division of distribution center VZSPART TSPA CHAR 2 0
EXTLI External vendor W_EXTLI LFA1 CHAR 10 0
BZQFI Supply Source Determination Status W_BZQFI CHAR 1 0
NULL Supply source determin. not yet carried out
A Supply source determin. not carried out for all plants
B Supply source determ. carried out for all plants
C Supply source determin. partial (old)
D Supply source determin. faulty for at least one plant (old)
BEKTB Announcement category - plant W_BEKTB T626 CHAR 4 0
BEKTV Announcement category - distribution center W_BEKTV T626 CHAR 4 0
ABDTB Confirmation request date AFIDT DATS 8 0
RUDAB Reply date plant W_RUDAB DATS 8 0
RUDAV Reply date DC W_RUDAV DATS 8 0
RUSTB Status of reply to announcement - plant W_RUSTB CHAR 1 0
X Yes
NULL No
RUSTV Status of reply to announcement - DC W_RUSTV CHAR 1 0
X Yes
NULL No
BESTB Confirmation can be carried out for plant W_BESTB CHAR 1 0
X Yes
NULL No
BESTV Confirmation can be carried out for DC W_BESTV CHAR 1 0
X Yes
NULL No
AENDB Send change to plant W_AENDB CHAR 1 0
X Yes
NULL No
AENDV Send change to DC W_AENDV CHAR 1 0
X Yes
NULL No
PLEKP Basic purchase price (gross) per plant/material W_PLEKP_WALE CURR 11 2
WAEEK Purchase price currency W_WAEEK TCURC CUKY 5 0
PLVKP Sales price for promotion item W_PLVKP CURR 11 2
WAELA Currency current promotion - planning W_WAELA TCURC CUKY 5 0
EKDAB Purchase price conditions valid from W_EKDAB DATS 8 0
EKDBI Purchase price conditions valid to W_EKDBI DATS 8 0
VKDAB On Sale to Consumers From W_VKDAB DATS 8 0
VKDBI On Sale To Consumers To W_VKDBI DATS 8 0
SPANE Margin (net) in sales price calculation SPANE CURR 11 2
SPABR Margin (gross) in sales price calculation SPABR CURR 11 2
AUFSG Actual Markup in Sales Price Calculation AUFSG CURR 11 2
VSPAN Net warehouse margin W_SPANE CURR 11 2
VSPAB Gross warehouse margin W_SPABR CURR 11 2
VAUFS Warehouse markup W_AUFSG CURR 11 2
VABGM Sales unit W_MEBME T006 UNIT 3 0
VABGP Transfer price, distribution center W_VABGP CURR 11 2
PARKZ Price type indicator (gross, net) W_PARKZ CHAR 1 0
B Gross
N Net
EPEIN Price Unit EPEIN DEC 5 0
VZEPE Price unit Transfer price DC W_VZEPE DEC 5 0
VPEIN Sales price unit VPEIN DEC 5 0
MEBPR Order Price Unit (Purchasing) BBPRM T006 UNIT 3 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
LIGEN Listing generation status W_LIGEN CHAR 1 0
AUGEN Allocation table creation status W_AUGEN CHAR 1 0
NULL Alloc tbl not generated
A Alloc tbl partially generated
B Alloc tbl generated for all items
VKGEN Sales price generation status W_VKGEN CHAR 1 0
NULL Not active
A Sales price activated, conditions not created
B Sales price activated, conditions created
C Sales price changed at item level, not activated
D Error during activation
E Sales price changed at plant level, not activated
F Sales price deactivated, condition deleted
EKGEN Purchase price generation status W_EKGEN CHAR 1 0
NULL Not active
A Purchase price activated, conditions not created
B Purchase price activated, conditions created
C Purchase price changed at item level, not activated
D Error during activation
E Purchase price changed at plant level, not activated
F Purchase price deactivated, condition deleted
BEGEB Generation status of announcement - plant W_BEGEB CHAR 1 0
NULL Announcement not made
A Announcement partially made
B Announcement made
BEGEV Announcement status - DC W_BEGEV CHAR 1 0
NULL Announcement not made
A Announcement partially made
B Announcement made
BEDEB Detailed status of promotion announcement - plant W_BEDEB CHAR 1 0
NULL No announcement made
1 Announcement made, print open
2 Request created, reply open, no reminder necessary
3 Request created, reply open, reminder necessary
4 Request created, reminder created, reply open
5 Request created, reply received, confirmation open
6 Request created, reply received, confirmed qty missing
9 Completely created
BEDEV Detailed status of promotion announcement - DC W_BEDEV CHAR 1 0
NULL Not Relevant
1 Not created
2 Request created, reply open, no reminder necessary
3 Request created, reply open, reminder necessary
4 Request created, reminder created, reply open
5 Request created, reply received, confirmation open
6 Request created, reply received, confirmed qty missing
9 Completely created
RELIF Regular Vendor RELIF CHAR 1 0
X Yes
NULL No
ADGEN Additionals maintained W_ADGEN CHAR 1 0
WMNGE Quantity requested by store WMNGE QUAN 13 3
AUFME Corrected/confirmed allocation quantity for a promotion item W_BESTM QUAN 13 3
PABBM Planned Sales Qty. of Promotion Material in Sales Units W_PABBM QUAN 13 3
MIAMG Minimum order qty for promotional material W_MIAMG QUAN 13 3
EKPNN Purchase price (net/net) W_EKPNN CURR 11 2
VKPNN Sales price (net) W_VKPNN CURR 11 2
ECKPKZ Indicates whether price point tables should override price F_VKPKZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
PAUFME Planned allocation quantity for promotion item for a plant W_PAUFME QUAN 13 3
ALIVO Starting date for activating DC transfer prices ALIVO DATS 8 0
ALIBI Final date for activating DC transfer prices ALIBI DATS 8 0
EPRGR Price point group EPRGR CHAR 6 0
NVKP Standard sales price at plant level W_NVKP_WALE CURR 11 2
SPGRU Reason for promotion block W_SPGRU CHAR 1 0
A Delivery difficulties
B Procurement unclear
C Material damaged
D Other
F Plant deleted

WALE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WALE AKTHE WALE MANDT TWAT Promotion themes, IS-R MANDT
WALE AKTHE WALE AKTHE TWAT Promotion themes, IS-R AKTHE
WALE AKTNR WALE AKTNR WAKH Promotion Header Data, IS-R AKTNR
WALE AKTNR WALE MANDT WAKH Promotion Header Data, IS-R MANDT
WALE ARTNR WALE MANDT MARA General Material Data MANDT
WALE ARTNR WALE ARTNR MARA General Material Data MATNR
WALE BEKTB WALE MANDT T626 Allocation Table Notification Categories MANDT
WALE BEKTB WALE BEKTB T626 Allocation Table Notification Categories AAVIT
WALE BEKTV WALE MANDT T626 Allocation Table Notification Categories MANDT
WALE BEKTV WALE BEKTV T626 Allocation Table Notification Categories AAVIT
WALE CLINT WALE MANDT KLAH Class Header Data MANDT
WALE CLINT WALE CLINT KLAH Class Header Data CLINT
WALE EKGRP WALE MANDT T024 Purchasing Groups MANDT
WALE EKGRP WALE EKGRP T024 Purchasing Groups EKGRP
WALE EKORG WALE EKORG T024E Purchasing Organizations EKORG
WALE EKORG WALE MANDT T024E Purchasing Organizations MANDT
WALE EXTLI WALE MANDT LFA1 Vendor Master (General Section) MANDT
WALE EXTLI WALE EXTLI LFA1 Vendor Master (General Section) LIFNR
WALE KUNNR WALE MANDT KNA1 General Data in Customer Master MANDT
WALE KUNNR WALE KUNNR KNA1 General Data in Customer Master KUNNR
WALE LIFNR WALE MANDT LFA1 Vendor Master (General Section) MANDT
WALE LIFNR WALE LIFNR LFA1 Vendor Master (General Section) LIFNR
WALE MANDT WALE MANDT T000 Clients MANDT
WALE MEBME WALE MANDT T006 Units of Measurement MANDT
WALE MEBME WALE MEBME T006 Units of Measurement MSEHI
WALE MEBPR WALE MEBPR T006 Units of Measurement MSEHI
WALE MEBPR WALE MANDT T006 Units of Measurement MANDT
WALE SPART WALE MANDT TSPA Organizational Unit: Sales Divisions MANDT
WALE SPART WALE SPART TSPA Organizational Unit: Sales Divisions SPART
WALE VABGM WALE MANDT T006 Units of Measurement MANDT
WALE VABGM WALE VABGM T006 Units of Measurement MSEHI
WALE VKORG WALE VKORG TVKO Organizational Unit: Sales Organizations VKORG
WALE VKORG WALE MANDT TVKO Organizational Unit: Sales Organizations MANDT
WALE VTWEG WALE MANDT TVTW Organizational Unit: Distribution Channels MANDT
WALE VTWEG WALE VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
WALE VZEKO WALE MANDT T024E Purchasing Organizations MANDT
WALE VZEKO WALE VZEKO T024E Purchasing Organizations EKORG
WALE VZSPA WALE MANDT TSPA Organizational Unit: Sales Divisions MANDT
WALE VZSPA WALE VZSPA TSPA Organizational Unit: Sales Divisions SPART
WALE VZVKO WALE MANDT TVKO Organizational Unit: Sales Organizations MANDT
WALE VZVKO WALE VZVKO TVKO Organizational Unit: Sales Organizations VKORG
WALE VZVTW WALE MANDT TVTW Organizational Unit: Distribution Channels MANDT
WALE VZVTW WALE VZVTW TVTW Organizational Unit: Distribution Channels VTWEG
WALE VZWRK WALE MANDT T001W Plants/Branches MANDT
WALE VZWRK WALE VZWRK T001W Plants/Branches WERKS
WALE WAEEK WALE MANDT TCURC Currency Codes MANDT
WALE WAEEK WALE WAEEK TCURC Currency Codes WAERS
WALE WAELA WALE WAELA TCURC Currency Codes WAERS
WALE WAELA WALE MANDT TCURC Currency Codes MANDT