SAP WAKP Promotion Item Data Table
Overview
WAKP is a standard SAP S/4HANA table that stores Promotion Item Data data. There are total 83 fields in the WAKP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WAKP belongs to Seasonal / Promotion Planning (LO-RFM-MD-PR) module and is located in the package Application development R/3 Promotions (WAKT).
In addition, following links provide an overview of foreign key relationships, if any, that link WAKP to other SAP tables and standard CDS views available based on WAKP table in S/4HANA 2020.
Techincal Settings of WAKP
Below are technical details of the table WAKP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WAKP Fields
The following table gives you an overview of the fields available in WAKP
| 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 |
| AKPOS | Promotion Item Number | W_AKPOS | NUMC | 6 | |
| SATNR | Cross-Plant Configurable Material | SATNR | MARA | CHAR | 40 |
| MATKL | Material Group | MATKL | T023 | CHAR | 9 |
| AKTHE | Promotion theme | W_AKTHE | TWAT | CHAR | 4 |
| BZQFI | Supply Source Determination Status | W_BZQFI | CHAR | 1 | |
| AKBSP | Item status listing | W_AKBSP | CHAR | 1 | |
| NBPOS | No. of modules with this material as an item | W_NBPOS | INT2 | 5 | |
| RESKZ | Check Against Listing Rules/Listing Conditions | W_LCHECK | CHAR | 1 | |
| BEKTY | Promotion announcement category | W_BEKTY | T626 | CHAR | 4 |
| SPDAT | Date on which promotion material is blocked for promotion | W_SPDAT | DATS | 8 | |
| SPGRU | Reason for promotion block | W_SPGRU | CHAR | 1 | |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVKOV | CHAR | 2 |
| AKLIZ | Planned delivery time for promotional goods | W_PLIFZ | DEC | 3 | |
| PUMVP | Promotion Plan Mat. Sales Vol. at Promo. Sales Price | W_PUMVP | CURR | 13 | |
| PUMEP | Promotion plan: mat. sales at PP in sales currency | W_PUMEP | CURR | 13 | |
| PUMEN | Promotion plan: sales volume at purchase price (net/net) | W_PUMEN | CURR | 13 | |
| PABBM | Planned Sales Qty. of Promotion Material in Sales Units | W_PABBM | QUAN | 13 | |
| PABLM | Planned Sales Qty of Promotion Material in Logistics Units | W_PABLM | QUAN | 13 | |
| AUFME | Promotion plan: Material allocation table quantity | W_AUFME | QUAN | 13 | |
| PLVKP | Sales price for promotion item | W_PLVKP | CURR | 11 | |
| VPEIN | Sales price unit | VPEIN | DEC | 5 | |
| PLEKP | Purchase price for promotion item | W_PLEKP | CURR | 11 | |
| PLEKN | Basic purchase price: net/net - promotion item | W_PLEKN | CURR | 11 | |
| EPEIN | Price unit | EPEIN | DEC | 5 | |
| WAEEK | Purchase price currency | W_WAEEK | TCURC | CUKY | 5 |
| WAELA | Currency Current Promotion - Planning | W_WAELA | TCURC | CUKY | 5 |
| MEINS | Base unit of measure | W_MEINS | T006 | UNIT | 3 |
| MELOG | Logistics unit | W_MELOG | T006 | UNIT | 3 |
| MEBPR | Order Price Unit (Purchasing) | BBPRM | T006 | UNIT | 3 |
| MEAUF | Allocation table unit | W_MEAUF | T006 | UNIT | 3 |
| RGART | Return type for promotional material | W_RGART | CHAR | 1 | |
| MIAMG | Minimum order qty for promotional material | W_MIAMG | QUAN | 13 | |
| NDISP | Replenishment indicator | W_NDISP | CHAR | 2 | |
| FBDAT | Earliest Order Date | W_FADAT | DATS | 8 | |
| SBDAT | Latest Order Date | W_SADAT | DATS | 8 | |
| FLDAT | Earliest delivery date | W_FLDAT | DATS | 8 | |
| SLDAT | Latest delivery date | W_SLDAT | DATS | 8 | |
| APSTP | Item category of allocation table | APSTP | T621 | CHAR | 4 |
| BEDAT | Order Date with Supplier | W_BEDAT | DATS | 8 | |
| VREGE | Retail Promotion: Allocation Rule Number | VREGE | SVKO | CHAR | 10 |
| ABELN | Allocation Table | ABELN | AUKO | CHAR | 10 |
| ABELP | Allocation Table Item | ABELP | AUPO | NUMC | 5 |
| ETIAG | IS-R Labeling: material grouping (deactivated in 4.0) | W_ETIAG | TWEA | CHAR | 18 |
| EKKPS | Maintenance status of purchase price conditions | W_EKKPS | CHAR | 1 | |
| VKKPS | Maintenance status of sales price conditions | W_VKKPS | CHAR | 1 | |
| EKKON | Create purchase price condition records | W_EKKON | CHAR | 1 | |
| VKKON | Create sales price condition records | W_VKKON | CHAR | 1 | |
| ACTIV | No. of successful price activations | W_ACTIV | INT1 | 3 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| ECKPKZ | Indicates whether price point tables should override price | F_VKPKZ | CHAR | 1 | |
| VZKON | Create DC condition records | W_VZKON | CHAR | 1 | |
| VZKPS | Maintenance status of DC conditions | W_VZKPS | CHAR | 1 | |
| EPRGR | Price Point Group Promotion Item | W_EPRGR | * | CHAR | 6 |
| NVKP | Standard sales price | W_NVKP | CURR | 11 | |
| VK_AKTIV_AB | Sales prices active from | W_VK_AKTIV_AB | DATS | 8 | |
| VK_AKTIV_BI | Sales price active to | W_VK_AKTIV_BI | DATS | 8 | |
| BATNR | Allocation material number | BSTARTNR | MARA | CHAR | 40 |
| EKERV | Promotion: Purchase price determination sequence | W_EKERV | TWEV | CHAR | 2 |
| REB_VALUE | Value of Absolute Discount | REB_VALUE | CURR | 11 | |
| REB_PERC | Percentage Discount | REB_PERC | DEC | 5 | |
| REB_STATUS | Discount Status | REB_STATUS | CHAR | 1 | |
| NO_KALK | Price Activation w/o Price Calculation | NO_KALK | CHAR | 1 | |
| ASTRA | Retail Promotion: Allocation Strategy | W_ASTRA | T627 | CHAR | 4 |
| OFFER_TYPE | Offer Type Price | RDM_OFFER_TYPE_PRICE | CHAR | 2 | |
| OFFER_TYPE_DSC | Offer Type Discount | RDM_OFFER_TYPE_DISCOUNT | CHAR | 2 | |
| OFFER_ID | Offer ID for Price | WPM_OFFERID_PRICE | CHAR | 36 | |
| OFFER_ID_DSC | Offer ID for Discount | WPM_OFFERID_DISCOUNT | CHAR | 36 | |
| OFFER_PRDGRP | Product Group in Offer (Price) | WPM_OFFER_PRODUCT_GROUP_PRICE | NUMC | 3 | |
| OFFER_PRDGRP_DSC | Product Group in Offer (Discount) | WPM_OFFER_PRODUCT_GROUP_DSCNT | NUMC | 3 | |
| ITEM_CREAT_INDIC | Promotion Item Indicator for Transferred Materials | WPM_PROMO_ITEM | CHAR | 1 | |
| PABBM_OFFER_PRC | Planned sales qty in sales units for material in price offer | W_PABBM_OFFER_PRC | QUAN | 13 | |
| PABBM_OFFER_DSC | Planned sales qty in sales units of material in discnt offer | W_PABBM_OFFER_DSC | QUAN | 13 | |
| ASTRA_VAR | Allocation Strategy Variant | ASTRA_VAR | * | CHAR | 14 |
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 WAKP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WAKP | ABELN | 1: CN | AUKO |
| WAKP | ABELP | : | AUPO |
| WAKP | AKTHE | C: CN | TWAT |
| WAKP | AKTNR | 1: CN | WAKH |
| WAKP | APSTP | 1: CN | T621 |
| WAKP | ARTNR | 1: CN | MARA |
| WAKP | ASTRA | : | T627 |
| WAKP | BATNR | 1: CN | MARA |
| WAKP | BEKTY | C: N | T626 |
| WAKP | EKERV | : | TWEV |
| WAKP | EKGRP | 1: CN | T024 |
| WAKP | EKORG | 1: CN | T024E |
| WAKP | ETIAG | C: CN | TWEA |
| WAKP | MANDT | 1: CN | T000 |
| WAKP | MATKL | C: N | T023 |
| WAKP | MEAUF | : | T006 |
| WAKP | MEBME | C: N | T006 |
| WAKP | MEBPR | 1: CN | T006 |
| WAKP | MEINS | C: N | T006 |
| WAKP | MELOG | 1: CN | T006 |
| WAKP | SATNR | 1: CN | MARA |
| WAKP | VKORG | 1: CN | TVKO |
| WAKP | VREGE | C: N | SVKO |
| WAKP | VTWEG | 1: CN | TVKOV |
| WAKP | WAEEK | 1: CN | TCURC |
| WAKP | WAELA | 1: CN | TCURC |