SAP ABAP Table WKKALP (Market-Basket Price Calculation: Item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WVKP (Package) IS-R: Sales pricing

Basic Data

Table Category	INTTAB	Structure
Structure	WKKALP	Table Relationship Diagram
Short Description	Market-Basket Price Calculation: Item

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	Sales price calculation: key fields in a price calculation
2	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	VRKME	☐	W_VRKME_VKP	MEINS	UNIT	3	0	Sales Unit	T006
4	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
5	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
6	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
7	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
9	BGINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	KLAH
10	WKPOS	☐	W_WKPOS	NUMC6	NUMC	6	0	Market-basket price calculation item number
11	WKMPO	☐	W_WKMPO	NUMC5	NUMC	5	0	Market-basket price calculation material item number
12	WWAER	☐	W_WWAER	WAERS	CUKY	5	0	Display Currency for Market-Basket Price Calculation	*
13	KALEB	☐	KALEB	KALEB	CHAR	2	0	Sales Pricing: Pricing level
14	KZRWC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
15	KZRWM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
16	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
17	KWAER	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency	*
18	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
19	EKDIV	☐	W_EKDIV	XFELD	CHAR	1	0	Market-basket price calc.: "Different pur. prices" indicator
20	EAMNG	☐	W_EAMNG	MENG10	QUAN	10	3	Market-basket price calc.: expected sales quantity
21	KAMNG	☐	W_KAMNG	MENG10	QUAN	10	3	Market-basket price calc.: corrected (expected) sales qty
22	EKWRT	☐	W_EKWRT	WERT13N	CURR	13	2	Market-basket price calc.: purch. value of corrected sls qty
23	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	*
24	VORPR	☐	W_VORPR	WERTV6	CURR	11	2	Sales Pricing: Suggested Price
25	VPDIV	☐	W_VPDIV	XFELD	CHAR	1	0	MB price calculation: indicator "different suggested prices"
26	PENDR	☐	PENDR	WERTV6	CURR	11	2	Sales price calculation: Plnd SP with price point rounding
27	PPDIV	☐	W_PPDIV	XFELD	CHAR	1	0	MB price calc.: indicator "different planned final prices"
28	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
29	VKDIV	☐	W_VKDIV	XFELD	CHAR	1	0	Market basket price calc.: indicator diff. final prices
30	VKPNE	☐	VKPNE	WERTV6	CURR	11	2	Sales price (net)
31	SPANE	☐	SPANE	WERTV6	CURR	11	2	Margin (net) in sales price calculation
32	UMWRT	☐	W_UMWRT	WERT13N	CURR	13	2	MB pr. calc.: bus.vol.(val.) for corr. sls qty and fin. pr.
33	ERWRT	☐	W_ERWRT	WERT13N	CURR	13	2	MB price calc.: gross rev. (val.) for corr. sales quantity
34	ENDPA	☐	ENDPA	WERTV6	CURR	11	2	Current Final Price
35	EADIV	☐	W_EADIV	XFELD	CHAR	1	0	MB price calc.: indicator "different current final prices"
36	VKPNA	☐	VKPNA	WERTV6	CURR	11	2	Current sales price (net)
37	SPANA	☐	SPANA	WERTV6	CURR	11	2	Current margin (net)
38	AUWRT	☐	W_AUWRT	WERT13N	CURR	13	2	MB price calc.: sales (value) for sales qty w/ curr. SP
39	AEWRT	☐	W_AEWRT	WERT13N	CURR	13	2	MB price calc.: gross rev. corr. sales qty w/ current net SP
40	ERAEN	☐	W_ERAEN	WERT13N	CURR	13	2	Market-basket price calc.: absolute change in gross revenue
41	UMAEP	☐	W_UMAEP	WERTV6	CURR	11	2	MB price calc.: percent. change in sales (chnge/curr sales)
42	ERAEP	☐	W_ERAEP	WERTV6	CURR	11	2	Market-basket price calc.: percentage chnge in gross revenue
43	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
44	SUBRC	☐	SUBRC	EK08R_RC	NUMC	2	0	Subroutines for return code
45	ICON4	☐	ICON_L4	ICON	CHAR	4	0	Icon with output length 4	*
46	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
47	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
48	PMATA	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
49	PMDIV	☐	W_PMDIV	XFELD	CHAR	1	0	MBPricing: Different Pricing Reference Materials Indicator
50	CSTF1	☐	WKK_CSTFLD	WERTV6	CURR	11	2	Customer-Defined Field in Market Basket Calculation
51	CSTF2	☐	WKK_CSTFLD	WERTV6	CURR	11	2	Customer-Defined Field in Market Basket Calculation
52	CSTF3	☐	WKK_CSTFLD	WERTV6	CURR	11	2	Customer-Defined Field in Market Basket Calculation
53	CSTF4	☐	WKK_CSTFLD	WERTV6	CURR	11	2	Customer-Defined Field in Market Basket Calculation
54	CSTF5	☐	WKK_CSTFLD	WERTV6	CURR	11	2	Customer-Defined Field in Market Basket Calculation
55	ICON132	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
56	MATNR132	☐	TEXT132	TEXT132	CHAR	132	0	Text (length 132)
57	WERKS132	☐	TEXT132	TEXT132	CHAR	132	0	Text (length 132)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WKKALP	BGINT	KLAH	CLINT
2	WKKALP	MATNR	MARA	MATNR
3	WKKALP	PLTYP	T189	PLTYP
4	WKKALP	VKORG	TVKO	VKORG
5	WKKALP	VRKME	T006	MSEHI
6	WKKALP	VTWEG	TVTW	VTWEG
7	WKKALP	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20100310
SAP Release Created in