SAP ABAP Table WAKP (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	TRANSP	Transparent table
Transparent table	WAKP	Table Relationship Diagram
Short Description	Promotion Item Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AKTNR	☑	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
3	ARTNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	MEBME	☑	W_MEBME	MEINS	UNIT	3	0	Sales unit	T006
5	AKPOS	☐	W_AKPOS	NUMC6	NUMC	6	0	Promotion Item Number
6	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
7	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
8	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
9	BZQFI	☐	W_BZQFI	BZQFA	CHAR	1	0	Supply Source Determination Status
10	AKBSP	☐	W_AKBSP	LISTSH	CHAR	1	0	Item status, listing
11	NBPOS	☐	W_NBPOS	INT2	INT2	5	0	No. of modules with this material as an item
12	RESKZ	☐	W_LCHECK	W_LCHECK	CHAR	1	0	Check Against Listing Rules/Listing Conditions
13	BEKTY	☐	W_BEKTY	AAVIT	CHAR	4	0	Promotion announcement category	T626
14	SPDAT	☐	W_SPDAT	DATUM	DATS	8	0	Date on which promotion material is blocked for promotion
15	SPGRU	☐	W_SPGRU	SPGRU	CHAR	1	0	Reason for promotion block
16	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
17	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
18	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
19	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
20	AKLIZ	☐	W_PLIFZ	DEC3	DEC	3	0	Planned delivery time for promotional goods
21	PUMVP	☐	W_PUMVP	WERT	CURR	13	2	Promotion Plan Mat. Sales Vol. at Promo. Sales Price
22	PUMEP	☐	W_PUMEP	WERT	CURR	13	2	Promotion plan: mat. sales at PP in sales currency
23	PUMEN	☐	W_PUMEN	WERT	CURR	13	2	Promotion plan: sales volume at purchase price (net/net)
24	PABBM	☐	W_PABBM	MENGE	QUAN	13	3	Planned Sales Qty. of Promotion Material in Sales Units
25	PABLM	☐	W_PABLM	MENGE	QUAN	13	3	Planned Sales Qty of Promotion Material in Logistics Units
26	AUFME	☐	W_AUFME	MENGE	QUAN	13	3	Promotion plan: Material allocation table quantity
27	PLVKP	☐	W_PLVKP	PREIS	CURR	11	2	Sales price for promotion item
28	VPEIN	☐	VPEIN	DEC5	DEC	5	0	Sales price unit
29	PLEKP	☐	W_PLEKP	PREIS	CURR	11	2	Purchase price for promotion item
30	PLEKN	☐	W_PLEKN	PREIS	CURR	11	2	Basic purchase price: net/net - promotion item
31	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
32	WAEEK	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
33	WAELA	☐	W_WAELA	WAERS	CUKY	5	0	Currency current promotion - planning	TCURC
34	MEINS	☐	W_MEINS	MEINS	UNIT	3	0	Base unit of measure	T006
35	MELOG	☐	W_MELOG	MEINS	UNIT	3	0	Logistics unit	T006
36	MEBPR	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
37	MEAUF	☐	W_MEAUF	MEINS	UNIT	3	0	Allocation table unit	T006
38	RGART	☐	W_RGART	RGART	CHAR	1	0	Return type for promotional material
39	MIAMG	☐	W_MIAMG	MENGE	QUAN	13	3	Minimum order qty for promotional material
40	NDISP	☐	W_NDISP	CHAR2	CHAR	2	0	Replenishment indicator
41	FBDAT	☐	W_FADAT	DATUM	DATS	8	0	Earliest Order Date
42	SBDAT	☐	W_SADAT	DATUM	DATS	8	0	Latest Order Date
43	FLDAT	☐	W_FLDAT	DATUM	DATS	8	0	Earliest delivery date
44	SLDAT	☐	W_SLDAT	DATUM	DATS	8	0	Latest delivery date
45	APSTP	☐	APSTP	APSTP	CHAR	4	0	Item category of allocation table	T621
46	BEDAT	☐	W_BEDAT	DATUM	DATS	8	0	Order date with vendor
47	VREGE	☐	VREGE	SBELN	CHAR	10	0	Retail Promotion: Allocation Rule Number	SVKO
48	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
49	ABELP	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table	AUPO
50	ETIAG	☐	W_ETIAG	ETIAG	CHAR	18	0	IS-R Labeling: material grouping (deactivated in 4.0)	TWEA
51	EKKPS	☐	W_EKKPS	EKKPS	CHAR	1	0	Maintenance status of purchase price conditions
52	VKKPS	☐	W_VKKPS	VKKPS	CHAR	1	0	Maintenance status of sales price conditions
53	EKKON	☐	W_EKKON	XFELD	CHAR	1	0	Create purchase price condition records
54	VKKON	☐	W_VKKON	XFELD	CHAR	1	0	Create sales price condition records
55	ACTIV	☐	W_ACTIV	INT1	INT1	3	0	No. of successful price activations
56	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
57	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
58	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
59	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
60	ECKPKZ	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
61	VZKON	☐	W_VZKON	XFELD	CHAR	1	0	Create DC condition records
62	VZKPS	☐	W_VZKPS	VZKPS	CHAR	1	0	Maintenance status of DC conditions
63	EPRGR	☐	W_EPRGR	EPRGR	CHAR	6	0	Price Point Group, Promotion Item	*
64	NVKP	☐	W_NVKP	PREIS	CURR	11	2	Standard sales price
65	VK_AKTIV_AB	☐	W_VK_AKTIV_AB	DATS	DATS	8	0	Sales prices active from
66	VK_AKTIV_BI	☐	W_VK_AKTIV_BI	DATS	DATS	8	0	Sales price active to
67	BATNR	☐	BSTARTNR	MATNR	CHAR	18	0	Allocation material number	MARA
68	EKERV	☐	W_EKERV	EKERV	CHAR	2	0	Promotion: Purchase price determination sequence	TWEV
69	REB_VALUE	☐	REB_VALUE	WERT6	CURR	11	2	Value of Absolute Discount
70	REB_PERC	☐	REB_PERC	REB_PERC	DEC	5	2	Percentage Discount
71	REB_STATUS	☐	REB_STATUS	REB_STATUS	CHAR	1	0	Discount Status
72	NO_KALK	☐	NO_KALK	XFELD	CHAR	1	0	Price Activation w/o Price Calculation
73	ASTRA	☐	W_ASTRA	ASTRA	CHAR	4	0	Retail Promotion: Allocation Strategy	T627
74	OFFER_TYPE	☐	RDM_OFFER_TYPE_PRICE	RDM_OFFER_TYPE_PRICE	CHAR	2	0	Offer Type Price
75	OFFER_TYPE_DSC	☐	RDM_OFFER_TYPE_DISCOUNT	RDM_OFFER_TYPE_DISCOUNT	CHAR	2	0	Offer Type Discount
76	OFFER_ID	☐	WPM_OFFERID_PRICE	WPM_OFFERID	CHAR	36	0	Offer ID for Price
77	OFFER_ID_DSC	☐	WPM_OFFERID_DISCOUNT	WPM_OFFERID	CHAR	36	0	Offer ID for Discount
78	OFFER_PRDGRP	☐	WPM_OFFER_PRODUCT_GROUP_PRICE	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Price)
79	OFFER_PRDGRP_DSC	☐	WPM_OFFER_PRODUCT_GROUP_DSCNT	WPM_OFFER_PRODUCT_GROUP	NUMC	3	0	Product Group in Offer (Discount)
80	ITEM_CREAT_INDIC	☐	WPM_PROMO_ITEM	XFELD	CHAR	1	0	Promotion Item Indicator for Transferred Materials
81	PABBM_OFFER_PRC	☐	W_PABBM_OFFER_PRC	MENGE	QUAN	13	3	Planned sales qty in sales units for material in price offer
82	PABBM_OFFER_DSC	☐	W_PABBM_OFFER_DSC	MENGE	QUAN	13	3	Planned sales qty in sales units of material in discnt offer
83	.INCLU--AP	☐				0	0	Enhancement of Allocation Strategy Variant
84	ASTRA_VAR	☐	ASTRA_VAR	VARIANT	CHAR	14	0	Allocation Strategy Variant	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in