Technical Articles
CDS View “V_KONV” in SAP S/4HANA On Premise
Introduction
This blog will show you how to use CDS View “V_KONV” for SD, MM Consultants.
This is valid for S/4HANA any on premise version.
What is V_KONV
Pricing model has been changed in SAP S/4HANA. Table “KONV” will be no more used in SAP S/4HANA.
Table “PRCD_ELEMENTS” replaces table “KONV”.
If your custom programs is using the table “KONV”, you can use a CDS View “V_KONV” instead of the table “PRCD_ELEMENTS”. Because the Table “PRCD_ELEMENTS” stores pricing data different way than the table “KONV”. So, the CDS View “V_KONV” shows the pricing data of the “PRCD_ELEMENTS“ as same as the pricing data of the table “KONV” in SAP ERP.
KONV in SAP ERP
Purchase order price example:
The KONV data example
Field “KNUMV” of Table “EKKO” is Field “KNUMV” of table “KONV”.
The values are 10 times bigger than what you can see as the Purchase Order Pricing.
PRCD_ELEMENTS in SAP S/4HANA
Purchase order price example: It is as same as the SAP ERP above pricing data.
PRCD_ELEMENTS data in SAP S/4HANA example:
Field “KNUMV” of Table “EKKO” is Field “KNUMV” of table “PRCD_ELEMENTS”.
It seems to be as same as what you can see in purchase order document price.
How to use CDS View “V_KONV”
You can read “V_KONV” by ABAP program.
—–Sample program in SAP S/4HANA—————–
REPORT ZV_KONV_TEST1.
select * from v_konv
where ( knumv = ‘1000005394’ ) into table @DATA(RESULT).
Break-point.
——————
The sample program result:
It is as same as KONV data in SAP ERP.
The values are 10 times bigger than what you can see as the Purchase Order Pricing.
Conclusion:
You can understand how to use the CDS View “V_KONV”.
SAP Notes:
2220005 – S/4 HANA: Data Model Changes in Pricing and Condition Technique
2267442 – S4TWL – Pricing Data Model Simplification
2267308 – S4TWL – Data Model Changes in SD Pricing
Hi Kazuhisa,
Great Blog.
So, where can I find the other CDS Views relevant for sales ?
Example: If I want to select a sales order table (VBAK) or billing document (VBRK), where is the corresponded CDS view like V_KONV used in your example for KONV.
I saw this link:
https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2005.500/en-US/955a323799624bd79221780675ada090.html
In this case to achieve the same info than VBAK should I use I_SalesOrder ?
Thanks
Ruy
Hi Kazuhisa,
Thank you. This is a nice blog.
However SAP in their cookbook mention not to use V_KONV becuase of some buffering issues.
"SAP advises you not to use the CDS view for simple selections of the pricing results. PRCD_ELEMENTS was created as a transparent table, therefore automatic buffering for cluster tables is no longer available. SAP recommends that you use the provided API. "
Can you please suggest if it is alright to use V_KONV in place of the API.
It depends on how to use it.
Page 9 of Cookbook_Pricing_ConditionTechnique_20210917.pdf attached Note 2220005 - S/4 HANA: Data Model Changes in Pricing and Condition Technique
You should use the provided API. To access the price result within custom CDS views or in more complex select statements not covered by the API interface, you can use the CDS view named V_KONV instead.