SAP ABAP Table CALP (Sales Price Calculation: Item in a Price Calculation)

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	CALP	Table Relationship Diagram
Short Description	Sales Price Calculation: Item in a Price Calculation

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	VKKAB	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
11	VKKBI	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
12	VKKAM	☐	VKKAM	DATUM	DATS	8	0	Key date for sales price conditions
13	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
14	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
15	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
16	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
17	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
18	PBIND	☐	PBIND	PBIND	CHAR	1	0	Indicator for price fixing
19	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
20	MGAME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
21	EKKAB	☐	EKKAB	DATUM	DATS	8	0	Purchase price conditions valid from
22	EKKBI	☐	EKKBI	DATUM	DATS	8	0	Purchase price conditions valid to
23	EKKAM	☐	EKKAM	DATUM	DATS	8	0	Key date for purchase price conditions
24	VKABA	☐	VKABA	DATUM	DATS	8	0	Current Sales Conditions Valid From
25	VKBIA	☐	VKBIA	DATUM	DATS	8	0	Current Sales Conditions Valid To
26	EKAPP	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
27	EKALS	☐	EKALS	KALSM	CHAR	6	0	Sales Pricing: Purchase Price Calculation Schema	*
28	VKALS	☐	VKALS	KALSM	CHAR	6	0	Sales Pricing: Sales Price Calculation Schema	*
29	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
30	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
31	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
32	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
33	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
34	INFWK	☐	INFWK	XFELD	CHAR	1	0	Info record at plant level
35	ESOKZ	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
36	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
37	BEWRK	☐	BEWRK	WERKS	CHAR	4	0	Plant from Which Material is Procured	T001W
38	BEVKO	☐	BEVKO	VKORG	CHAR	4	0	Sales organization via which material is procured	TVKO
39	BEVTW	☐	BEVTW	VTWEG	CHAR	2	0	Distribution channel via which material is procured	TVTW
40	BESPA	☐	BESPA	SPART	CHAR	2	0	Division via which the material is procured	*
41	BEPLT	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	*
42	BEBPL	☐	BEBPL	PLTYP	CHAR	2	0	Price list of supplying plant	*
43	BEVRK	☐	W_BEVRK_KALP	MEINS	UNIT	3	0	Sales Pricing: Sales Unit for Supplying Organizational Level	*
44	BEMGA	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
45	VLGWK	☐	VLGWK	WERKS	CHAR	4	0	Sales Pricing: Reference Plant	*
46	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
47	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
48	FIVKO	☐	FIVKO	VKORG	CHAR	4	0	Distribution chain filter for plant groups: Sales org.	*
49	FIVTW	☐	FIVTW	VTWEG	CHAR	2	0	Distribution chain filter for plant groups: Distr. channel	*
50	WAERS	☐	BSTWA	WAERS	CUKY	5	0	Purchase order currency	TCURC
51	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
52	KWAER	☐	KAWAER	WAERS	CUKY	5	0	Sales Pricing: Pricing Currency	TCURC
53	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
54	AUFSG	☐	AUFSG	WERTV6	CURR	11	2	Actual Markup in Sales Price Calculation
55	PAUFS	☐	PAUFS	WERTV6	CURR	11	2	Planned markup
56	PENDP	☐	PENDP	WERTV6	CURR	11	2	SP calculation: Planned sales pr. w/o price point rounding
57	PENDR	☐	PENDR	WERTV6	CURR	11	2	Sales price calculation: Plnd SP with price point rounding
58	VKPNE	☐	VKPNE	WERTV6	CURR	11	2	Sales price (net)
59	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
60	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
61	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
62	KALEB	☐	KALEB	KALEB	CHAR	2	0	Sales Pricing: Pricing level
63	SPANE	☐	SPANE	WERTV6	CURR	11	2	Margin (net) in sales price calculation
64	SPABR	☐	SPABR	WERTV6	CURR	11	2	Margin (gross) in sales price calculation
65	ENDPA	☐	ENDPA	WERTV6	CURR	11	2	Current Final Price
66	KALEA	☐	KALEA	KALEB	CHAR	2	0	Pricing Level of Current Final Price
67	SPANA	☐	SPANA	WERTV6	CURR	11	2	Current margin (net)
68	SPABA	☐	SPABA	WERTV6	CURR	11	2	Current margin (gross)
69	ROTPR	☐	ROTPR	WERTV6	CURR	11	2	Reduced-from price
70	MITPR	☐	MITPR	WERTV6	CURR	11	2	Cash price
71	EMPPR	☐	EMPPR	WERTV6	CURR	11	2	Recommended price
72	VORPR	☐	W_VORPR	WERTV6	CURR	11	2	Sales Pricing: Suggested Price
73	VKP01	☐	VKPZW	WERTV6	CURR	11	2	Variable sales price
74	VKP02	☐	VKPZW	WERTV6	CURR	11	2	Variable sales price
75	VKP03	☐	VKPZW	WERTV6	CURR	11	2	Variable sales price
76	PROZ1	☐	W_PROZ	WERTV6	CURR	11	2	Sales Price Calculation: (general) percentage-based factor
77	PROZ2	☐	W_PROZ	WERTV6	CURR	11	2	Sales Price Calculation: (general) percentage-based factor
78	EVAUF	☐	EVAUF	WERTV6	CURR	11	2	Sales Pricing: Markup for Determining the Retail Price
79	EVPAU	☐	EVPAU	WERTV6	CURR	11	2	Planned markup for determining the retail price
80	EVWRS	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
81	EVPRS	☐	EVPRS	WERTV6	CURR	11	2	Sales Pricing: Retail Price
82	EVSPA	☐	EVSPA	WERTV6	CURR	11	2	Sales Pricing: Retail Price Margin
83	PAWRS	☐	PAWRS	WAERS	CUKY	5	0	Sales Pricing: Parallel Sales Currency	*
84	PAEPR	☐	PAEPR	WERTV6	CURR	11	2	Sales Pricing: Parallel Final Price
85	BPSTA	☐	BPSTA	BPSTA	CHAR	1	0	Pricing: Status of Item in Pricing Document
86	EKABS	☐	XEKAB	XFELD	CHAR	1	0	Checkbox for storing purchase price conditions
87	VKABS	☐	XVKAB	XFELD	CHAR	1	0	Checkbox for saving sales price conditions
88	KZPPL	☐	KZPPL	XFELD	CHAR	1	0	Indicator: Delete Prices at Site Price List Level
89	KZPBL	☐	KZPBL	XFELD	CHAR	1	0	Indicates that prices at plant level are to be deleted
90	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
91	EKERV	☐	EKERV_M	EKERV	CHAR	2	0	Purchase price determination sequence	TWEV
92	EKERA	☐	EKERA	EKERA	CHAR	1	0	Purchase price determination type
93	EFNAM	☐	EFNAM	FUNCNAME	CHAR	30	0	Name of the Function Module in PP Determination Type C	TFDIR
94	BWERA	☐	BWERA	BWERA	CHAR	1	0	Source determination type
95	VKERV	☐	EKERV_V	EKERV	CHAR	2	0	Sales price determination sequence	TWEV
96	VKERA	☐	VKERA	VKERA	CHAR	1	0	Sales price determination type
97	MPROZ	☐	MPROZ	WERTV6	CURR	11	2	Pricing: Price Change in Percent
98	LIFEL	☐	LIFELD	LIFELD	CHAR	5	0	Sales Pricing: List Field for Determining Sales Price	*
99	ECKKZ	☐	ECKKZ	XFELD	CHAR	1	0	SP calc.: price point rounding for suggested final price
100	PSTRA	☐	PSTRA	PSTRA	CHAR	2	0	Sales Pricing: Pricing Strategy	TWPS
101	TKONN	☐	TKONN	TKONN	CHAR	10	0	Trading Contract: Trading Contract Number	*
102	TPOSN	☐	TPOSN	TPOSN	NUMC	6	0	Trading Contract: Item Number
103	TKRATE_SD	☐	UKURS_CURR	UKURS	DEC	9	5	Exchange Rate
104	TKRATE_MM	☐	UKURS_CURR	UKURS	DEC	9	5	Exchange Rate
105	WRSVO	☐	WRSVO	WAERS	CUKY	5	0	EMU: Currency Prior to Conversion	*
106	KBELN	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document	*
107	KBELP	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document	*
108	KBELN_COPY	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document	*
109	KBELP_COPY	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document	*
110	KBELN_IDENT	☐	KBELN	KBELN	CHAR	10	0	Number of pricing document	*
111	KBELP_IDENT	☐	KBELP	KBELP	NUMC	5	0	Item Number of Pricing Document	*
112	BSTMG	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
113	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
114	BSTUZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
115	BSTUN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
116	KBETR_EKPGR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
117	WAERS_EKPGR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
118	KPEIN_EKPGR	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
119	KMEIN_EKPGR	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
120	KUMZA_EKPGR	☐	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
121	KUMNE_EKPGR	☐	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
122	EKINP	☐	W_EKINP_KALP	CHAR1	CHAR	1	0	SP: Indicator for Ready-for-Input Status of Purchase Fields
123	EKNUM	☐	EKNUM	KNUMV	CHAR	10	0	SP: Key for Transaction Conditions in Purchase Pricing
124	VKNUM	☐	VKNUM	KNUMV	CHAR	10	0	SP: Key for Transaction Conditions in Purchase Pricing
125	KNUMH_V	☐	KNUMH_V	KNUMB	CHAR	10	0	Number of the sales price condition record
126	PVGRD	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	TWBN
127	SUBRC	☐	W_SUBRC	EK08R_RC	NUMC	2	0	Subroutines for return code
128	FAMNR	☐	WPF_FAMNR	CHAR10	CHAR	10	0	Identification Number for Price Family
129	GRP01	☐	WPF_GROUP	CHAR10	CHAR	10	0	Number of a Family Group in a Price Family
130	FMTYP	☐	WPF_FMTYP	WPF_FMTYP	CHAR	2	0	Type of Family Member
131	SMATN	☐	WPF_SMATN	MATNR	CHAR	18	0	Master Material of a Price Family	*
132	FCHAL	☐	WPF_FCHAL	WPF_MODKZ	CHAR	1	0	Price Change Allowed (_=No, 1=Group, 2=Group and Article)
133	FHIDE	☐	WPF_FHIDE	XFELD	CHAR	1	0	Pricing Item Hidden for Family Member (X = Yes)
134	FCHNG	☐	WPF_FCHNG	XFELD	CHAR	1	0	Manual Price Change of Family Member To Occur (X = Yes)
135	GENKZ	☐	WPF_GENKZ	XFELD	CHAR	1	0	Pricing Item Generated by the System (X = Yes)
136	EPRGR	☐	EPRGR	EPRGR	CHAR	6	0	Price point group	*
137	EPRG2	☐	EPRG2	EPRGR	CHAR	6	0	Price point group for retail price	*
138	NEPGR	☐	NEPGR	XFELD	CHAR	1	0	Indicator: No Price Point Group
139	NEPG2	☐	NEPGR	XFELD	CHAR	1	0	Indicator: No Price Point Group
140	KBART	☐	KBART	KBART	CHAR	4	0	Pricing document type
141	.INCLUDE	☐				0	0	Include for Structure CALP
142	INIPR	☐	W_INIPR	WERTV6	CURR	11	2	Sales Price Calculation: Initial Price
143	INIAM	☐	VKKAM	DATUM	DATS	8	0	Key date for sales price conditions
144	EPTYP	☐	EPTYP	EPTYP	CHAR	2	0	Price Point Category
145	EPTY2	☐	EPTYP	EPTYP	CHAR	2	0	Price Point Category
146	RKTYP	☐	WRF_RPC_RKTYP	WRF_RPC_RKTYP	CHAR	1	0	Price Point Groups: Ranking Type
147	RKTY2	☐	WRF_RPC_RKTYP	WRF_RPC_RKTYP	CHAR	1	0	Price Point Groups: Ranking Type
148	FILGR	☐	W_FILGR	KLASSE	CHAR	18	0	Plant grouping, sales promotion
149	STPLGR	☐	WRF_STPLGR	WRF_STPLGR	CHAR	1	0	Status of Plant Group
150	VKSCH	☐	W_VKSCH_KALP	KSCHL	CHAR	4	0	Sales Pricing: Condition Type for the Sales Price	*
151	VKOTABN	☐	W_VKOTABN_KALP	KOTABNR	NUMC	3	0	Sales Pricing: Condition Table for the Sales Price	*
152	VKSCA	☐	W_VKSCA_KALP	KSCHL	CHAR	4	0	SP Calculation: Condition Type for Current Sales Price	*
153	VKOTABA	☐	W_VKOTABA_KALP	KOTABNR	NUMC	3	0	Sales Pricing: Condition Table for the Current Sales Price	*
154	FCODE	☐	FCODE	FCODE	CHAR	20	0	Function code
155	IGNORE_PMAT	☐	WPM_IGNORE_PMAT	XFELD	CHAR	1	0	Variant Price Allowed - Promotion-Internal Handling
156	CMPGN_ID	☐	CMPGN_ID_R3	CMPGN_ID_R3	CHAR	10	0	Campaign ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CALP	BEVKO	TVKO	VKORG
2	CALP	BEVTW	TVTW	VTWEG
3	CALP	BEWRK	T001W	WERKS
4	CALP	BGINT	KLAH	CLINT
5	CALP	EFNAM	TFDIR	FUNCNAME
6	CALP	EKERV	TWEV	EKERV
7	CALP	EVWRS	TCURC	WAERS
8	CALP	HWAER	TCURC	WAERS
9	CALP	INFNR	EINA	INFNR
10	CALP	KWAER	TCURC	WAERS
11	CALP	LIFNR	LFA1	LIFNR
12	CALP	LTSNR	WYT1	LTSNR
13	CALP	MATKL	T023	MATKL
14	CALP	MATNR	MARA	MATNR
15	CALP	PLTYP	T189	PLTYP
16	CALP	PMATN	MARA	MATNR
17	CALP	PSTRA	TWPS	PSTRA
18	CALP	PVGRD	TWBN	PV_GRUND
19	CALP	SATNR	MARA	MATNR
20	CALP	VKERV	TWEV	EKERV
21	CALP	VKORG	TVKO	VKORG
22	CALP	VRKME	T006	MSEHI
23	CALP	VTWEG	TVTW	VTWEG
24	CALP	VWAER	TCURC	WAERS
25	CALP	WAERS	TCURC	WAERS
26	CALP	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in