1. Home
  2. Resources
  3. SAP Tables
  4. WALED - Processing of records in WALE table

SAP Table WALED

Processing of records in WALE table

WALED (Processing of records in WALE table) 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 WALED to other SAP tables.

WALED 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
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
UPDKZ Update indicator UPDKZ_D CHAR 1 0
P_WAKP Pointer to an entry in an internal table W_TABIX INT4 10 0
P_WAGU Pointer to an entry in an internal table W_TABIX INT4 10 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
SATNR Cross-Plant Configurable Material SATNR CHAR 18 0
PMATA Pricing Reference Material PMATN CHAR 18 0
EKKPS Maintenance status of purchase price conditions W_EKKPS 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
VKKPS Maintenance status of sales price conditions W_VKKPS 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
KALKE Activation type for sales prices W_AKTART CHAR 1 0
1 Plant
2 Plant group
KALKR Reference record for price calculation is used W_KALKR CHAR 1 0
X Yes
NULL No
IMNGU Confirmed qty of plant IMNGU QUAN 13 3
PMNGU Planned allocation quantity for an allocation table item W_PMNGU QUAN 13 3
MEAUF Allocation table unit W_MEAUF UNIT 3 0
VZKPS Maintenance status of DC conditions W_VZKPS CHAR 1 0
NULL Not active
A DC price active, condition not created
B DC price active, condition created
D Error during activation
F DC price deactivated, condition deleted
ADDEL Additional deleted W_ADDEL CHAR 1 0
REB_STATUS Discount Status REB_STATUS CHAR 1 0
A In planning
B Activated
C Deactivated
D Incorrect

WALED foreign key relationships

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