SAP ABAP Table WDFR_CALP (WDFR Pricing Data Calp)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR (Application Component) Purchasing
     ⤷ WO+G (Package) Retail Development for Perishables

Basic Data

Table Category	INTTAB	Structure
Structure	WDFR_CALP	Table Relationship Diagram
Short Description	WDFR Pricing Data Calp

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

History

Last changed by/on	SAP	20130529
SAP Release Created in