WAKPD SAP (Screen Field String for Promotion Item Data) Structure details
Description: Screen Field String for Promotion Item Data
Structure field list including key, data, relationships and ABAP select examples
WAKPD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Screen Field String for Promotion Item Data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_WAKPD TYPE WAKPD.
The WAKPD table consists of various fields, each holding specific information or linking keys about Screen Field String for Promotion Item Data data available in SAP. These include MANDT (Client), AKTNR (COUPON), ARTNR (Material Number), MEBME (Sales unit).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP WAKPD structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
ARTNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MEBME | Sales unit | W_MEBME | UNIT | 3 | T006 | CUNIT | MEINS | ||
AKPOS | Promotion Item Number | W_AKPOS | NUMC | 6 | NUMC6 | ||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
AKTHE | Promotion theme | W_AKTHE | CHAR | 4 | TWAT | THEMA | |||
BZQFI | Supply Source Determination Status | W_BZQFI | CHAR | 1 | BZQFA | ||||
AKBSP | Item status, listing | W_AKBSP | CHAR | 1 | LISTSH | ||||
NBPOS | No. of modules with this material as an item | W_NBPOS | INT2 | 5 | INT2 | ||||
RESKZ | Check Against Listing Rules/Listing Conditions | W_LCHECK | CHAR | 1 | W_LCHECK | ||||
BEKTY | Promotion announcement category | W_BEKTY | CHAR | 4 | T626 | AAVIT | |||
SPDAT | Date on which promotion material is blocked for promotion | W_SPDAT | DATS | 8 | DATUM | ||||
SPGRU | Reason for promotion block | W_SPGRU | CHAR | 1 | SPGRU | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
AKLIZ | Planned delivery time for promotional goods | W_PLIFZ | DEC | 3 | DEC3 | ||||
PUMVP | Promotion Plan Mat. Sales Vol. at Promo. Sales Price | W_PUMVP | CURR | 13(2) | WERT | ||||
PUMEP | Promotion plan: mat. sales at PP in sales currency | W_PUMEP | CURR | 13(2) | WERT | ||||
PUMEN | Promotion plan: sales volume at purchase price (net/net) | W_PUMEN | CURR | 13(2) | WERT | ||||
PABBM | Planned Sales Qty. of Promotion Material in Sales Units | W_PABBM | QUAN | 13(3) | MENGE | ||||
PABLM | Planned Sales Qty of Promotion Material in Logistics Units | W_PABLM | QUAN | 13(3) | MENGE | ||||
AUFME | Promotion plan: Material allocation table quantity | W_AUFME | QUAN | 13(3) | MENGE | ||||
PLVKP | Sales price for promotion item | W_PLVKP | CURR | 11(2) | PREIS | ||||
VPEIN | Sales price unit | VPEIN | DEC | 5 | DEC5 | ||||
PLEKP | Purchase price for promotion item | W_PLEKP | CURR | 11(2) | PREIS | ||||
PLEKN | Basic purchase price: net/net - promotion item | W_PLEKN | CURR | 11(2) | PREIS | ||||
EPEIN | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
WAEEK | Purchase price currency | W_WAEEK | CUKY | 5 | TCURC | WAERS | |||
WAELA | Currency current promotion - planning | W_WAELA | CUKY | 5 | TCURC | WAERS | FWS | ||
MEINS | Base unit of measure | W_MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
MELOG | Logistics unit | W_MELOG | UNIT | 3 | T006 | CUNIT | MEINS | ||
MEBPR | Order Price Unit (Purchasing) | BBPRM | UNIT | 3 | T006 | CUNIT | MEINS | ||
MEAUF | Allocation table unit | W_MEAUF | UNIT | 3 | T006 | CUNIT | MEINS | ||
RGART | Return type for promotional material | W_RGART | CHAR | 1 | RGART | ||||
MIAMG | Minimum order qty for promotional material | W_MIAMG | QUAN | 13(3) | MENGE | ||||
NDISP | Replenishment indicator | W_NDISP | CHAR | 2 | Assigned to domain | CHAR2 | |||
FBDAT | Earliest Order Date | W_FADAT | DATS | 8 | DATUM | ||||
SBDAT | Latest Order Date | W_SADAT | DATS | 8 | DATUM | ||||
FLDAT | Earliest delivery date | W_FLDAT | DATS | 8 | DATUM | ||||
SLDAT | Latest delivery date | W_SLDAT | DATS | 8 | DATUM | ||||
APSTP | Item category of allocation table | APSTP | CHAR | 4 | T621 | APSTP | |||
BEDAT | Order date with vendor | W_BEDAT | DATS | 8 | DATUM | ||||
VREGE | Retail Promotion: Allocation Rule Number | VREGE | CHAR | 10 | SVKO | ALPHA | SBELN | BLN | |
ABELN | Allocation Table Number | ABELN | CHAR | 10 | AUKO | ALPHA | ABELN | ABE | |
ABELP | Item number of allocation table | ABELP | NUMC | 5 | AUPO | ABELP | |||
ETIAG | IS-R Labeling: material grouping (deactivated in 4.0) | W_ETIAG | CHAR | 18 | TWEA | ETIAG | |||
EKKPS | Maintenance status of purchase price conditions | W_EKKPS | CHAR | 1 | EKKPS | ||||
VKKPS | Maintenance status of sales price conditions | W_VKKPS | CHAR | 1 | VKKPS | ||||
EKKON | Create purchase price condition records | W_EKKON | CHAR | 1 | XFELD | ||||
VKKON | Create sales price condition records | W_VKKON | CHAR | 1 | XFELD | ||||
ACTIV | No. of successful price activations | W_ACTIV | INT1 | 3 | INT1 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
ECKPKZ | Indicates whether price point tables should override price | F_VKPKZ | CHAR | 1 | FLAG | ||||
VZKON | Create DC condition records | W_VZKON | CHAR | 1 | XFELD | ||||
VZKPS | Maintenance status of DC conditions | W_VZKPS | CHAR | 1 | VZKPS | ||||
EPRGR | Price Point Group, Promotion Item | W_EPRGR | CHAR | 6 | Assigned to domain | EPRGR | |||
NVKP | Standard sales price | W_NVKP | CURR | 11(2) | PREIS | ||||
VK_AKTIV_AB | Sales prices active from | W_VK_AKTIV_AB | DATS | 8 | DATS | ||||
VK_AKTIV_BI | Sales price active to | W_VK_AKTIV_BI | DATS | 8 | DATS | ||||
BATNR | Allocation material number | BSTARTNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
EKERV | Promotion: Purchase price determination sequence | W_EKERV | CHAR | 2 | TWEV | EKERV | |||
REB_VALUE | Value of Absolute Discount | REB_VALUE | CURR | 11(2) | WERT6 | ||||
REB_PERC | Percentage Discount | REB_PERC | DEC | 5(2) | REB_PERC | ||||
REB_STATUS | Discount Status | REB_STATUS | CHAR | 1 | REB_STATUS | ||||
NO_KALK | Price Activation w/o Price Calculation | NO_KALK | CHAR | 1 | XFELD | ||||
ASTRA | Retail Promotion: Allocation Strategy | W_ASTRA | CHAR | 4 | T627 | ASTRA | |||
OFFER_TYPE | Offer Type Price | RDM_OFFER_TYPE_PRICE | CHAR | 2 | RDM_OFFER_TYPE_PRICE | ||||
OFFER_TYPE_DSC | Offer Type Discount | RDM_OFFER_TYPE_DISCOUNT | CHAR | 2 | RDM_OFFER_TYPE_DISCOUNT | ||||
OFFER_ID | Offer ID for Price | WPM_OFFERID_PRICE | CHAR | 36 | ALPHA | WPM_OFFERID | |||
OFFER_ID_DSC | Offer ID for Discount | WPM_OFFERID_DISCOUNT | CHAR | 36 | ALPHA | WPM_OFFERID | |||
OFFER_PRDGRP | Product Group in Offer (Price) | WPM_OFFER_PRODUCT_GROUP_PRICE | NUMC | 3 | WPM_OFFER_PRODUCT_GROUP | ||||
OFFER_PRDGRP_DSC | Product Group in Offer (Discount) | WPM_OFFER_PRODUCT_GROUP_DSCNT | NUMC | 3 | WPM_OFFER_PRODUCT_GROUP | ||||
ITEM_CREAT_INDIC | Promotion Item Indicator for Transferred Materials | WPM_PROMO_ITEM | CHAR | 1 | XFELD | ||||
PABBM_OFFER_PRC | Planned sales qty in sales units for material in price offer | W_PABBM_OFFER_PRC | QUAN | 13(3) | MENGE | ||||
PABBM_OFFER_DSC | Planned sales qty in sales units of material in discnt offer | W_PABBM_OFFER_DSC | QUAN | 13(3) | MENGE | ||||
.INCLU--AP | 0 | ||||||||
ASTRA_VAR | Allocation Strategy Variant | ASTRA_VAR | CHAR | 14 | Assigned to domain | VARIANT | |||
SELKZ | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
SELBM | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
UPDKZ | Update indicator | UPDKZ_D | CHAR | 1 | UPDKZ | ||||
TXTL | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
AKTTT | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
RFOLG | Pointer to an entry in an internal table | W_TABIX | INT4 | 10 | W_TABIX | ||||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
PMATA | Pricing Reference Material | PMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
PMATR | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
CUOBF | Internal object number | CUOBM | NUMC | 18 | CUOBJ | ||||
WAE_EKWVK | Currency current promotion - planning | W_WAELA | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
EKWVK | Purchase price in sales price currency and sales unit | W_EKWVK | CURR | 11(2) | WERTV6 | ||||
KZADDI | Indicator: additionals are assigned | W_KZADDI | CHAR | 1 | XFELD | ||||
KZBAT | Indicator: item with allocation material | W_KZBAT | CHAR | 1 | XFELD | ||||
REB_SELKZ | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
PUMNP | Promotion Plan Material Invoiced Sales at Stand.Sales Prices | W_PUMNP | CURR | 13(2) | WERT | ||||
PUMRE | Promotion Plan Gross Revenue Material | W_PUMRE | CURR | 13(2) | WERT | ||||
PUMLO | Promotion Plan Invoiced Lost Sales Material | W_PUMLO | CURR | 13(2) | WERT | ||||
IGNORE_PMAT | Variant Price Allowed - Promotion-Internal Handling | WPM_IGNORE_PMAT | CHAR | 1 | XFELD | ||||
OFFER_TYPE_BBY | Material is part of bonus buy offer | WPM_OFFER_TYPE_BBY | CHAR | 1 | XFELD | ||||
OFFER_TYPE_GENERIC | Generic offer type | WPM_OFFER_TYPE_GENERIC | CHAR | 2 | RDM_OFFER_TYPE_GENERIC | ||||
OFFER_ID_GENERIC | Offer ID for Promotion | WPM_OFFERID | CHAR | 36 | ALPHA | WPM_OFFERID | |||
BBYNR | Bonus buy | BBYNR | CHAR | 12 | Assigned to domain | BBYNR | BBY | KONBBYH_H |
Key field | Non-key field |
How do I retrieve data from SAP structure WAKPD using ABAP code?
As WAKPD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on WAKPD as there is no data to select.How to access SAP table WAKPD
Within an ECC or HANA version of SAP you can also view further information about WAKPD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects