Skip to Content
Technical Articles
Author's profile photo Kazuhisa Iwamoto

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

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ruy Pinto de Castro
      Ruy Pinto de Castro

      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

      Author's profile photo Ananya Bhawsinghka
      Ananya Bhawsinghka

      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.

       

      Author's profile photo Kazuhisa Iwamoto
      Kazuhisa Iwamoto
      Blog Post Author

      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.