1. Home
  2. Resources
  3. SAP Tables
  4. WAKPD - Screen Field String for Promotion Item Data

SAP Table WAKPD

Screen Field String for Promotion Item Data

WAKPD (Screen Field String for Promotion Item Data) 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 WAKPD to other SAP tables.

WAKPD 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
AKPOS Promotion Item Number W_AKPOS NUMC 6 0
SATNR Cross-Plant Configurable Material SATNR MARA CHAR 18 0
MATKL Material Group MATKL T023 CHAR 9 0
AKTHE Promotion theme W_AKTHE TWAT CHAR 4 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)
AKBSP Item status, listing W_AKBSP CHAR 1 0
NULL Listing not carried out
B Listing carried out
NBPOS No. of modules with this material as an item W_NBPOS INT2 5 0
RESKZ Check Against Listing Rules/Listing Conditions W_LCHECK CHAR 1 0
NULL No check against listing rules/listing conditions
X Check against listing rules
Y Check against listing conditions
BEKTY Promotion announcement category W_BEKTY T626 CHAR 4 0
SPDAT Date on which promotion material is blocked for promotion W_SPDAT DATS 8 0
SPGRU Reason for promotion block W_SPGRU CHAR 1 0
A Delivery difficulties
B Procurement unclear
C Material damaged
D Other
F Plant deleted
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
AKLIZ Planned delivery time for promotional goods W_PLIFZ DEC 3 0
PUMVP Promotion Plan Mat. Sales Vol. at Promo. Sales Price W_PUMVP CURR 13 2
PUMEP Promotion plan: mat. sales at PP in sales currency W_PUMEP CURR 13 2
PUMEN Promotion plan: sales volume at purchase price (net/net) W_PUMEN CURR 13 2
PABBM Planned Sales Qty. of Promotion Material in Sales Units W_PABBM QUAN 13 3
PABLM Planned Sales Qty of Promotion Material in Logistics Units W_PABLM QUAN 13 3
AUFME Promotion plan: Material allocation table quantity W_AUFME QUAN 13 3
PLVKP Sales price for promotion item W_PLVKP CURR 11 2
VPEIN Sales price unit VPEIN DEC 5 0
PLEKP Purchase price for promotion item W_PLEKP CURR 11 2
PLEKN Basic purchase price: net/net - promotion item W_PLEKN CURR 11 2
EPEIN Price Unit EPEIN DEC 5 0
WAEEK Purchase price currency W_WAEEK TCURC CUKY 5 0
WAELA Currency current promotion - planning W_WAELA TCURC CUKY 5 0
MEINS Base unit of measure W_MEINS T006 UNIT 3 0
MELOG Logistics unit W_MELOG T006 UNIT 3 0
MEBPR Order Price Unit (Purchasing) BBPRM T006 UNIT 3 0
MEAUF Allocation table unit W_MEAUF T006 UNIT 3 0
RGART Return type for promotional material W_RGART CHAR 1 0
1 No return
2 Return to DC
3 Return to vendor
MIAMG Minimum order qty for promotional material W_MIAMG QUAN 13 3
NDISP Replenishment indicator W_NDISP CHAR 2 0
FBDAT Earliest Order Date W_FADAT DATS 8 0
SBDAT Latest Order Date W_SADAT DATS 8 0
FLDAT Earliest delivery date W_FLDAT DATS 8 0
SLDAT Latest delivery date W_SLDAT DATS 8 0
APSTP Item category of allocation table APSTP T621 CHAR 4 0
BEDAT Order date with vendor W_BEDAT DATS 8 0
VREGE Retail Promotion: Allocation Rule Number VREGE SVKO CHAR 10 0
ABELN Allocation Table Number ABELN AUKO CHAR 10 0
ABELP Item number of allocation table ABELP AUPO NUMC 5 0
ETIAG IS-R Labeling: material grouping (deactivated in 4.0) W_ETIAG TWEA 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
EKKON Create purchase price condition records W_EKKON CHAR 1 0
X Yes
NULL No
VKKON Create sales price condition records W_VKKON CHAR 1 0
X Yes
NULL No
ACTIV No. of successful price activations W_ACTIV INT1 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
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
VZKON Create DC condition records W_VZKON CHAR 1 0
X Yes
NULL No
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
EPRGR Price Point Group, Promotion Item W_EPRGR CHAR 6 0
NVKP Standard sales price W_NVKP CURR 11 2
VK_AKTIV_AB Sales prices active from W_VK_AKTIV_AB DATS 8 0
VK_AKTIV_BI Sales price active to W_VK_AKTIV_BI DATS 8 0
BATNR Allocation material number BSTARTNR MARA CHAR 18 0
EKERV Promotion: Purchase price determination sequence W_EKERV TWEV CHAR 2 0
REB_VALUE Value of Absolute Discount REB_VALUE CURR 11 2
REB_PERC Percentage Discount REB_PERC DEC 5 2
REB_STATUS Discount Status REB_STATUS CHAR 1 0
A In planning
B Activated
C Deactivated
D Incorrect
NO_KALK Price Activation w/o Price Calculation NO_KALK CHAR 1 0
X Yes
NULL No
ASTRA Retail Promotion: Allocation Strategy W_ASTRA T627 CHAR 4 0
OFFER_TYPE Offer Type Price RDM_OFFER_TYPE_PRICE CHAR 2 0
01 Standard Sales Price
02 Promotion Sales Price
OFFER_TYPE_DSC Offer Type Discount RDM_OFFER_TYPE_DISCOUNT CHAR 2 0
03 Absolute Discount
04 Percentage Discount
OFFER_ID Offer ID for Price WPM_OFFERID_PRICE CHAR 36 0
OFFER_ID_DSC Offer ID for Discount WPM_OFFERID_DISCOUNT CHAR 36 0
OFFER_PRDGRP Product Group in Offer (Price) WPM_OFFER_PRODUCT_GROUP_PRICE NUMC 3 0
OFFER_PRDGRP_DSC Product Group in Offer (Discount) WPM_OFFER_PRODUCT_GROUP_DSCNT NUMC 3 0
ITEM_CREAT_INDIC Promotion Item Indicator for Transferred Materials WPM_PROMO_ITEM CHAR 1 0
X Yes
NULL No
PABBM_OFFER_PRC Planned sales qty in sales units for material in price offer W_PABBM_OFFER_PRC QUAN 13 3
PABBM_OFFER_DSC Planned sales qty in sales units of material in discnt offer W_PABBM_OFFER_DSC QUAN 13 3
ASTRA_VAR Allocation Strategy Variant ASTRA_VAR CHAR 14 0
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
SELBM 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
TXTL Checkbox XFELD CHAR 1 0
X Yes
NULL No
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
AKTTT Description BEZEI20 CHAR 20 0
RFOLG 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
PMATA Pricing Reference Material PMATN CHAR 18 0
PMATR Checkbox XFELD CHAR 1 0
X Yes
NULL No
CUOBF Internal object number CUOBM NUMC 18 0
WAE_EKWVK Currency current promotion - planning W_WAELA CUKY 5 0
EKWVK Purchase price in sales price currency and sales unit W_EKWVK CURR 11 2
KZADDI Indicator: additionals are assigned W_KZADDI CHAR 1 0
X Yes
NULL No
KZBAT Indicator: item with allocation material W_KZBAT CHAR 1 0
X Yes
NULL No
REB_SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
PUMNP Promotion Plan Material Invoiced Sales at Stand.Sales Prices W_PUMNP CURR 13 2
PUMRE Promotion Plan Gross Revenue Material W_PUMRE CURR 13 2
PUMLO Promotion Plan Invoiced Lost Sales Material W_PUMLO CURR 13 2
IGNORE_PMAT Variant Price Allowed - Promotion-Internal Handling WPM_IGNORE_PMAT CHAR 1 0
X Yes
NULL No
OFFER_TYPE_BBY Material is part of bonus buy offer WPM_OFFER_TYPE_BBY CHAR 1 0
X Yes
NULL No
OFFER_TYPE_GENERIC Generic offer type WPM_OFFER_TYPE_GENERIC CHAR 2 0
01 Offer Price
02 Offer Discount
03 Bonus Buy
04 Multiple
OFFER_ID_GENERIC Offer ID for Promotion WPM_OFFERID CHAR 36 0
BBYNR Bonus buy BBYNR CHAR 12 0

WAKPD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WAKPD ABELN WAKPD MANDT AUKO Allocation Table Document Header MANDT
WAKPD ABELN WAKPD ABELN AUKO Allocation Table Document Header ABELN
WAKPD ABELP WAKPD MANDT AUPO Allocation Table Document Item MANDT
WAKPD ABELP WAKPD ABELN AUPO Allocation Table Document Item ABELN
WAKPD ABELP WAKPD ABELP AUPO Allocation Table Document Item ABELP
WAKPD AKTHE WAKPD MANDT TWAT Promotion themes, IS-R MANDT
WAKPD AKTHE WAKPD AKTHE TWAT Promotion themes, IS-R AKTHE
WAKPD AKTNR WAKPD MANDT WAKH Promotion Header Data, IS-R MANDT
WAKPD AKTNR WAKPD AKTNR WAKH Promotion Header Data, IS-R AKTNR
WAKPD APSTP WAKPD MANDT T621 Item Categories for Allocation Tables MANDT
WAKPD APSTP WAKPD APSTP T621 Item Categories for Allocation Tables APSTP
WAKPD ARTNR WAKPD ARTNR MARA General Material Data MATNR
WAKPD ARTNR WAKPD MANDT MARA General Material Data MANDT
WAKPD ASTRA WAKPD MANDT T627 Allocation Strategy: Allocation Table MANDT
WAKPD ASTRA WAKPD ASTRA T627 Allocation Strategy: Allocation Table ASTRA
WAKPD BATNR WAKPD MANDT MARA General Material Data MANDT
WAKPD BATNR WAKPD BATNR MARA General Material Data MATNR
WAKPD BEKTY WAKPD MANDT T626 Allocation Table Notification Categories MANDT
WAKPD BEKTY WAKPD BEKTY T626 Allocation Table Notification Categories AAVIT
WAKPD EKERV WAKPD MANDT TWEV Pricing: Determination procedure MANDT
WAKPD EKERV 'M' TWEV Pricing: Determination procedure KAPPL
WAKPD EKERV WAKPD EKERV TWEV Pricing: Determination procedure EKERV
WAKPD EKGRP WAKPD EKGRP T024 Purchasing Groups EKGRP
WAKPD EKGRP WAKPD MANDT T024 Purchasing Groups MANDT
WAKPD EKORG WAKPD MANDT T024E Purchasing Organizations MANDT
WAKPD EKORG WAKPD EKORG T024E Purchasing Organizations EKORG
WAKPD ETIAG WAKPD ETIAG TWEA IS-R Labeling: Check Table Material Groups ARTGR
WAKPD ETIAG WAKPD MANDT TWEA IS-R Labeling: Check Table Material Groups MANDT
WAKPD MANDT WAKPD MANDT T000 Clients MANDT
WAKPD MATKL WAKPD MANDT T023 Material Groups MANDT
WAKPD MATKL WAKPD MATKL T023 Material Groups MATKL
WAKPD MEAUF WAKPD MANDT T006 Units of Measurement MANDT
WAKPD MEAUF WAKPD MEAUF T006 Units of Measurement MSEHI
WAKPD MEBME WAKPD MANDT T006 Units of Measurement MANDT
WAKPD MEBME WAKPD MEBME T006 Units of Measurement MSEHI
WAKPD MEBPR WAKPD MANDT T006 Units of Measurement MANDT
WAKPD MEBPR WAKPD MEBPR T006 Units of Measurement MSEHI
WAKPD MEINS WAKPD MANDT T006 Units of Measurement MANDT
WAKPD MEINS WAKPD MEINS T006 Units of Measurement MSEHI
WAKPD MELOG WAKPD MANDT T006 Units of Measurement MANDT
WAKPD MELOG WAKPD MELOG T006 Units of Measurement MSEHI
WAKPD SATNR WAKPD MANDT MARA General Material Data MANDT
WAKPD SATNR WAKPD SATNR MARA General Material Data MATNR
WAKPD VKORG WAKPD MANDT TVKO Organizational Unit: Sales Organizations MANDT
WAKPD VKORG WAKPD VKORG TVKO Organizational Unit: Sales Organizations VKORG
WAKPD VREGE WAKPD MANDT SVKO Allocation Rule / IS-R Allocation MANDT
WAKPD VREGE WAKPD VREGE SVKO Allocation Rule / IS-R Allocation SBELN
WAKPD VTWEG WAKPD VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
WAKPD VTWEG WAKPD VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
WAKPD VTWEG WAKPD MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
WAKPD WAEEK WAKPD MANDT TCURC Currency Codes MANDT
WAKPD WAEEK WAKPD WAEEK TCURC Currency Codes WAERS
WAKPD WAELA WAKPD MANDT TCURC Currency Codes MANDT
WAKPD WAELA WAKPD WAELA TCURC Currency Codes WAERS