SAP WAEL Delivery Phases in Retail Promotion Table
Overview
WAEL is a standard SAP S/4HANA table that stores Delivery Phases in Retail Promotion data. There are total 17 fields in the WAEL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WAEL belongs to Seasonal / Promotion Planning (LO-RFM-MD-PR) module and is located in the package Application Development ADD_ON Promotion (WAKT_ADD_ON).
In addition, following links provide an overview of foreign key relationships, if any, that link WAEL to other SAP tables and standard CDS views available based on WAEL table in S/4HANA 2020.
Techincal Settings of WAEL
Below are technical details of the table WAEL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WAEL Fields
The following table gives you an overview of the fields available in WAEL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AKTNR | Promotion | WAKTION | WAKH | CHAR | 10 |
| ARTNR | Material Number | MATNR | MARA | CHAR | 40 |
| MEBME | Sales unit | W_MEBME | T006 | UNIT | 3 |
| KUNNR | Customer Number for Plant | LOCNR | KNA1 | CHAR | 10 |
| LWNUM | Serial number | LFNR3 | NUMC | 3 | |
| WERKS | Plant in SAP Retail (store/DC) | WERKW | * | CHAR | 4 |
| WEDAT | Delivery date | LFDAT | DATS | 8 | |
| WETYP | Date type (day week month interval) | PRGRS | CHAR | 1 | |
| WEUZT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | |
| WEPRZ | Delivery phase in percent of total qty | LWPRZ | NUMC | 3 | |
| AUFME | Corrected/confirmed allocation quantity for a promotion item | W_BESTM | QUAN | 13 | |
| WMNGE | Quantity requested by store | WMNGE | QUAN | 13 | |
| PAUFME | Planned allocation quantity for promotion item for a plant | W_PAUFME | QUAN | 13 | |
| PABBM | Planned Sales Qty. of Promotion Material in Sales Units | W_PABBM | QUAN | 13 | |
| VLFKZ | Plant category | VLFKZ | CHAR | 1 | |
| RUSTB | Status of reply to announcement - plant | W_RUSTB | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WAEL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WAEL | AKTNR | 1: CN | WAKH |
| WAEL | ARTNR | 1: CN | MARA |
| WAEL | KUNNR | : | KNA1 |
| WAEL | MANDT | 1: CN | T000 |
| WAEL | MEBME | 1: CN | T006 |