SAP ABAP Table WAKPD (Screen Field String for Promotion Item Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WAKT (Package) Application development R/3 Promotions

Basic Data

Table Category	INTTAB	Structure
Structure	WAKPD	Table Relationship Diagram
Short Description	Screen Field String for Promotion Item Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Promotion Item Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
4	ARTNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	MEBME	☐	W_MEBME	MEINS	UNIT	3	0	Sales unit	T006
6	AKPOS	☐	W_AKPOS	NUMC6	NUMC	6	0	Promotion Item Number
7	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
8	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
9	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
10	BZQFI	☐	W_BZQFI	BZQFA	CHAR	1	0	Supply Source Determination Status
11	AKBSP	☐	W_AKBSP	LISTSH	CHAR	1	0	Item status, listing
12	NBPOS	☐	W_NBPOS	INT2	INT2	5	0	No. of modules with this material as an item
13	RESKZ	☐	W_LCHECK	W_LCHECK	CHAR	1	0	Check Against Listing Rules/Listing Conditions
14	BEKTY	☐	W_BEKTY	AAVIT	CHAR	4	0	Promotion announcement category	T626
15	SPDAT	☐	W_SPDAT	DATUM	DATS	8	0	Date on which promotion material is blocked for promotion
16	SPGRU	☐	W_SPGRU	SPGRU	CHAR	1	0	Reason for promotion block
17	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
18	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
19	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
20	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
21	AKLIZ	☐	W_PLIFZ	DEC3	DEC	3	0	Planned delivery time for promotional goods
22	PUMVP	☐	W_PUMVP	WERT	CURR	13	2	Promotion Plan Mat. Sales Vol. at Promo. Sales Price
23	PUMEP	☐	W_PUMEP	WERT	CURR	13	2	Promotion plan: mat. sales at PP in sales currency
24	PUMEN	☐	W_PUMEN	WERT	CURR	13	2	Promotion plan: sales volume at purchase price (net/net)
25	PABBM	☐	W_PABBM	MENGE	QUAN	13	3	Planned Sales Qty. of Promotion Material in Sales Units
26	PABLM	☐	W_PABLM	MENGE	QUAN	13	3	Planned Sales Qty of Promotion Material in Logistics Units
27	AUFME	☐	W_AUFME	MENGE	QUAN	13	3	Promotion plan: Material allocation table quantity
28	PLVKP	☐	W_PLVKP	PREIS	CURR	11	2	Sales price for promotion item
29	VPEIN	☐	VPEIN	DEC5	DEC	5	0	Sales price unit
30	PLEKP	☐	W_PLEKP	PREIS	CURR	11	2	Purchase price for promotion item
31	PLEKN	☐	W_PLEKN	PREIS	CURR	11	2	Basic purchase price: net/net - promotion item
32	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
33	WAEEK	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
34	WAELA	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	TCURC
35	MEINS	☐	W_MEINS	MEINS	UNIT	3	0	Base unit of measure	T006
36	MELOG	☐	W_MELOG	MEINS	UNIT	3	0	Logistics unit	T006
37	MEBPR	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
38	MEAUF	☐	W_MEAUF	MEINS	UNIT	3	0	Allocation table unit	T006
39	RGART	☐	W_RGART	RGART	CHAR	1	0	Return type for promotional material
40	MIAMG	☐	W_MIAMG	MENGE	QUAN	13	3	Minimum order qty for promotional material
41	NDISP	☐	W_NDISP	CHAR2	CHAR	2	0	Replenishment indicator	*
42	FBDAT	☐	W_FADAT	DATUM	DATS	8	0	Earliest Order Date
43	SBDAT	☐	W_SADAT	DATUM	DATS	8	0	Latest Order Date
44	FLDAT	☐	W_FLDAT	DATUM	DATS	8	0	Earliest delivery date
45	SLDAT	☐	W_SLDAT	DATUM	DATS	8	0	Latest delivery date
46	APSTP	☐	APSTP	APSTP	CHAR	4	0	Item category of allocation table	T621
47	BEDAT	☐	W_BEDAT	DATUM	DATS	8	0	Order date with vendor
48	VREGE	☐	VREGE	SBELN	CHAR	10	0	Retail Promotion: Allocation Rule Number	SVKO
49	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
50	ABELP	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table	AUPO
51	ETIAG	☐	W_ETIAG	ETIAG	CHAR	18	0	IS-R Labeling: material grouping (deactivated in 4.0)	TWEA
52	EKKPS	☐	W_EKKPS	EKKPS	CHAR	1	0	Maintenance status of purchase price conditions
53	VKKPS	☐	W_VKKPS	VKKPS	CHAR	1	0	Maintenance status of sales price conditions
54	EKKON	☐	W_EKKON	XFELD	CHAR	1	0	Create purchase price condition records
55	VKKON	☐	W_VKKON	XFELD	CHAR	1	0	Create sales price condition records
56	ACTIV	☐	W_ACTIV	INT1	INT1	3	0	No. of successful price activations
57	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
58	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
59	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
60	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
61	ECKPKZ	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
62	VZKON	☐	W_VZKON	XFELD	CHAR	1	0	Create DC condition records
63	VZKPS	☐	W_VZKPS	VZKPS	CHAR	1	0	Maintenance status of DC conditions
64	EPRGR	☐	W_EPRGR	EPRGR	CHAR	6	0	Price Point Group, Promotion Item	*
65	NVKP	☐	W_NVKP	PREIS	CURR	11	2	Standard sales price
66	VK_AKTIV_AB	☐	W_VK_AKTIV_AB	DATS	DATS	8	0	Sales prices active from
67	VK_AKTIV_BI	☐	W_VK_AKTIV_BI	DATS	DATS	8	0	Sales price active to
68	BATNR	☐	BSTARTNR	MATNR	CHAR	18	0	Allocation material number	MARA
69	EKERV	☐	W_EKERV	EKERV	CHAR	2	0	Promotion: Purchase price determination sequence	TWEV
70	REB_VALUE	☐	REB_VALUE	WERT6	CURR	11	2	Value of Absolute Discount
71	REB_PERC	☐	REB_PERC	REB_PERC	DEC	5	2	Percentage Discount
72	REB_STATUS	☐	REB_STATUS	REB_STATUS	CHAR	1	0	Discount Status
73	NO_KALK	☐	NO_KALK	XFELD	CHAR	1	0	Price Activation w/o Price Calculation
74	ASTRA	☐	W_ASTRA	ASTRA	CHAR	4	0	Retail Promotion: Allocation Strategy	T627
75	OFFER_TYPE	☐	RDM_OFFER_TYPE_PRICE	RDM_OFFER_TYPE_PRICE	CHAR	2	0	Offer Type Price
76	OFFER_TYPE_DSC	☐	RDM_OFFER_TYPE_DISCOUNT	RDM_OFFER_TYPE_DISCOUNT	CHAR	2	0	Offer Type Discount
77	OFFER_ID	☐	WPM_OFFERID_PRICE	WPM_OFFERID	CHAR	36	0	Offer ID for Price
78	OFFER_ID_DSC	☐	WPM_OFFERID_DISCOUNT	WPM_OFFERID	CHAR	36	0	Offer ID for Discount
79	OFFER_PRDGRP	☐	WPM_OFFER_PRODUCT_GROUP_PRICE	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Price)
80	OFFER_PRDGRP_DSC	☐	WPM_OFFER_PRODUCT_GROUP_DSCNT	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Discount)
81	ITEM_CREAT_INDIC	☐	WPM_PROMO_ITEM	XFELD	CHAR	1	0	Promotion Item Indicator for Transferred Materials
82	PABBM_OFFER_PRC	☐	W_PABBM_OFFER_PRC	MENGE	QUAN	13	3	Planned sales qty in sales units for material in price offer
83	PABBM_OFFER_DSC	☐	W_PABBM_OFFER_DSC	MENGE	QUAN	13	3	Planned sales qty in sales units of material in discnt offer
84	.INCLU--AP	☐				0	0	Enhancement of Allocation Strategy Variant
85	ASTRA_VAR	☐	ASTRA_VAR	VARIANT	CHAR	14	0	Allocation Strategy Variant	*
86	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
87	SELBM	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
88	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
89	TXTL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
90	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
91	AKTTT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
92	RFOLG	☐	W_TABIX	W_TABIX	INT4	10	0	Pointer to an entry in an internal table
93	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
94	PMATA	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
95	PMATR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
96	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
97	WAE_EKWVK	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	*
98	EKWVK	☐	W_EKWVK	WERTV6	CURR	11	2	Purchase price in sales price currency and sales unit
99	KZADDI	☐	W_KZADDI	XFELD	CHAR	1	0	Indicator: additionals are assigned
100	KZBAT	☐	W_KZBAT	XFELD	CHAR	1	0	Indicator: item with allocation material
101	REB_SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
102	PUMNP	☐	W_PUMNP	WERT	CURR	13	2	Promotion Plan Material Invoiced Sales at Stand.Sales Prices
103	PUMRE	☐	W_PUMRE	WERT	CURR	13	2	Promotion Plan Gross Revenue Material
104	PUMLO	☐	W_PUMLO	WERT	CURR	13	2	Promotion Plan Invoiced Lost Sales Material
105	IGNORE_PMAT	☐	WPM_IGNORE_PMAT	XFELD	CHAR	1	0	Variant Price Allowed - Promotion-Internal Handling
106	OFFER_TYPE_BBY	☐	WPM_OFFER_TYPE_BBY	XFELD	CHAR	1	0	Material is part of bonus buy offer
107	OFFER_TYPE_GENERIC	☐	WPM_OFFER_TYPE_GENERIC	RDM_OFFER_TYPE_GENERIC	CHAR	2	0	Generic offer type
108	OFFER_ID_GENERIC	☐	WPM_OFFERID	WPM_OFFERID	CHAR	36	0	Offer ID for Promotion
109	BBYNR	☐	BBYNR	BBYNR	CHAR	12	0	Bonus buy	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WAKPD	ABELN	AUKO	ABELN
2	WAKPD	ABELP	AUPO	ABELP
3	WAKPD	AKTHE	TWAT	AKTHE
4	WAKPD	AKTNR	WAKH	AKTNR
5	WAKPD	APSTP	T621	APSTP	KEY	1	CN
6	WAKPD	ARTNR	MARA	MATNR
7	WAKPD	ASTRA	T627	ASTRA
8	WAKPD	BATNR	MARA	MATNR
9	WAKPD	BEKTY	T626	AAVIT		C	N
10	WAKPD	EKERV	TWEV	EKERV
11	WAKPD	EKGRP	T024	EKGRP
12	WAKPD	EKORG	T024E	EKORG
13	WAKPD	ETIAG	TWEA	ARTGR
14	WAKPD	MANDT	T000	MANDT
15	WAKPD	MATKL	T023	MATKL		C	N
16	WAKPD	MEAUF	T006	MSEHI
17	WAKPD	MEBME	T006	MSEHI
18	WAKPD	MEBPR	T006	MSEHI
19	WAKPD	MEINS	T006	MSEHI		C	N
20	WAKPD	MELOG	T006	MSEHI
21	WAKPD	SATNR	MARA	MATNR	KEY	1	CN
22	WAKPD	VKORG	TVKO	VKORG
23	WAKPD	VREGE	SVKO	SBELN		C	N
24	WAKPD	VTWEG	TVKOV	VTWEG
25	WAKPD	WAEEK	TCURC	WAERS
26	WAKPD	WAELA	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in