SAP Table WALE
Material to store assignment to promotion
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table WALE (Material to store assignment to promotion) is a standard table in SAP ERP. It belongs to the package WAKT.
Technical Information
| Table | WALE |
| Short Text | Material to store assignment to promotion |
| Package | WAKT |
| Table Type | Transparent Table |
Fields for Table WALE
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| ARTNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| MEBME | ✔ | Sales unit | W_MEBME | UNIT | 3 | T006 |
| KUNNR | ✔ | Customer Number for Plant | LOCNR | CHAR | 10 | KNA1 |
| CLINT | ✔ | Internal Class Number | CLINT | NUMC | 10 | KLAH |
| WALNR | Plant - material of promotion in message control | WA_WALNR | NUMC | 10 | ||
| AKTHE | Promotion theme | W_AKTHE | CHAR | 4 | TWAT | |
| ERLIS | Error cat. after listing rule check | ERLIS | CHAR | 1 | ||
| GENLI | Execute generation if listing check error detected | W_GENLI | CHAR | 1 | ||
| VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | |
| SPART | Division | SPART | CHAR | 2 | TSPA | |
| EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | |
| EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | |
| LIFNR | Vendor number | W_LIFNR | CHAR | 10 | LFA1 | |
| LIFTY | Vendor Category - Retail | W_LIFTY | CHAR | 1 | ||
| VZWRK | Plant number for vendor number of DC | W_VZWERK | CHAR | 4 | T001W | |
| INFWK | Info record at plant level | INFWK | CHAR | 1 | ||
| VZEKO | Purchasing organization of distribution center | VZEKORG | CHAR | 4 | T024E | |
| VZVKO | Sales organization of distribution center | VZVKORG | CHAR | 4 | TVKO | |
| VZVTW | Distribution channel of distribution center | VZVTWEG | CHAR | 2 | TVTW | |
| VZSPA | Division of distribution center | VZSPART | CHAR | 2 | TSPA | |
| EXTLI | External vendor | W_EXTLI | CHAR | 10 | LFA1 | |
| BZQFI | Supply Source Determination Status | W_BZQFI | CHAR | 1 | ||
| BEKTB | Announcement category - plant | W_BEKTB | CHAR | 4 | T626 | |
| BEKTV | Announcement category - distribution center | W_BEKTV | CHAR | 4 | T626 | |
| ABDTB | Confirmation request date | AFIDT | DATS | 8 | ||
| RUDAB | Reply date plant | W_RUDAB | DATS | 8 | ||
| RUDAV | Reply date DC | W_RUDAV | DATS | 8 | ||
| RUSTB | Status of reply to announcement - plant | W_RUSTB | CHAR | 1 | ||
| RUSTV | Status of reply to announcement - DC | W_RUSTV | CHAR | 1 | ||
| BESTB | Confirmation can be carried out for plant | W_BESTB | CHAR | 1 | ||
| BESTV | Confirmation can be carried out for DC | W_BESTV | CHAR | 1 | ||
| AENDB | Send change to plant | W_AENDB | CHAR | 1 | ||
| AENDV | Send change to DC | W_AENDV | CHAR | 1 | ||
| PLEKP | Basic purchase price (gross) per plant/material | W_PLEKP_WALE | CURR | 11 | ||
| WAEEK | Purchase price currency | W_WAEEK | CUKY | 5 | TCURC | |
| PLVKP | Sales price for promotion item | W_PLVKP | CURR | 11 | ||
| WAELA | Currency current promotion - planning | W_WAELA | CUKY | 5 | TCURC | |
| EKDAB | Purchase price conditions valid from | W_EKDAB | DATS | 8 | ||
| EKDBI | Purchase price conditions valid to | W_EKDBI | DATS | 8 | ||
| VKDAB | On Sale to Consumers From | W_VKDAB | DATS | 8 | ||
| VKDBI | On Sale To Consumers To | W_VKDBI | DATS | 8 | ||
| SPANE | Margin (net) in sales price calculation | SPANE | CURR | 11 | ||
| SPABR | Margin (gross) in sales price calculation | SPABR | CURR | 11 | ||
| AUFSG | Actual Markup in Sales Price Calculation | AUFSG | CURR | 11 | ||
| VSPAN | Net warehouse margin | W_SPANE | CURR | 11 | ||
| VSPAB | Gross warehouse margin | W_SPABR | CURR | 11 | ||
| VAUFS | Warehouse markup | W_AUFSG | CURR | 11 | ||
| VABGM | Sales unit | W_MEBME | UNIT | 3 | T006 | |
| VABGP | Transfer price, distribution center | W_VABGP | CURR | 11 | ||
| PARKZ | Price type indicator (gross, net) | W_PARKZ | CHAR | 1 | ||
| EPEIN | Price Unit | EPEIN | DEC | 5 | ||
| VZEPE | Price unit Transfer price DC | W_VZEPE | DEC | 5 | ||
| VPEIN | Sales price unit | VPEIN | DEC | 5 | ||
| MEBPR | Order Price Unit (Purchasing) | BBPRM | UNIT | 3 | T006 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | ||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | ||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | ||
| AEDAT | Changed On | AEDAT | DATS | 8 | ||
| LIGEN | Listing generation status | W_LIGEN | CHAR | 1 | ||
| AUGEN | Allocation table creation status | W_AUGEN | CHAR | 1 | ||
| VKGEN | Sales price generation status | W_VKGEN | CHAR | 1 | ||
| EKGEN | Purchase price generation status | W_EKGEN | CHAR | 1 | ||
| BEGEB | Generation status of announcement - plant | W_BEGEB | CHAR | 1 | ||
| BEGEV | Announcement status - DC | W_BEGEV | CHAR | 1 | ||
| BEDEB | Detailed status of promotion announcement - plant | W_BEDEB | CHAR | 1 | ||
| BEDEV | Detailed status of promotion announcement - DC | W_BEDEV | CHAR | 1 | ||
| RELIF | Regular Vendor | RELIF | CHAR | 1 | ||
| ADGEN | Additionals maintained | W_ADGEN | CHAR | 1 | ||
| WMNGE | Quantity requested by store | WMNGE | QUAN | 13 | ||
| AUFME | Corrected/confirmed allocation quantity for a promotion item | W_BESTM | QUAN | 13 | ||
| PABBM | Planned Sales Qty. of Promotion Material in Sales Units | W_PABBM | QUAN | 13 | ||
| MIAMG | Minimum order qty for promotional material | W_MIAMG | QUAN | 13 | ||
| EKPNN | Purchase price (net/net) | W_EKPNN | CURR | 11 | ||
| VKPNN | Sales price (net) | W_VKPNN | CURR | 11 | ||
| ECKPKZ | Indicates whether price point tables should override price | F_VKPKZ | CHAR | 1 | ||
| PAUFME | Planned allocation quantity for promotion item for a plant | W_PAUFME | QUAN | 13 | ||
| ALIVO | Starting date for activating DC transfer prices | ALIVO | DATS | 8 | ||
| ALIBI | Final date for activating DC transfer prices | ALIBI | DATS | 8 | ||
| EPRGR | Price point group | EPRGR | CHAR | 6 | * | |
| NVKP | Standard sales price at plant level | W_NVKP_WALE | CURR | 11 | ||
| SPGRU | Reason for promotion block | W_SPGRU | CHAR | 1 |