CDS View "V_KONV" in SAP S/4HANA On Premise

[Kaz_Iwamoto]

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

 

 

Brought to you by the SAP S/4HANA Customer Care and RIG

[former_member229495]

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/955a323799624bd792217806...

In this case to achieve the same info than VBAK should I use I_SalesOrder ?

Thanks
Ruy

[abhawsinghka-1]

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.

 

[Kaz_Iwamoto]

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.

[Madjid]

Hello

Thanks for your kind explanation.

I have a question
What is the difference between the "v_KONV" and "v_KONV_CDS"

best regards

[Kaz_Iwamoto]

Hello,

V_KONV is definition of V_KONV_CDS.

Tr-cd:SE11

[Madjid]

Hello

thank you kazuhisa.iwamoto

 

[Peter_Inotai]

Hi,

Thanks for sharing all of this information.

I have a question for this topic:

Is it possible to use V_KONV already in ERP 6.0 (Ehp8)? The definition is there, but it gives me a short dump DBSQL_CDS_VIEW_UNKNOWN.

It would be ideal to use V_KONV already in ERP 6.0, which would make code S/4HANA compatible and it would be easier as cl_prc_result_factory.

Currently only cl_prc_result_factory the only way to make the code both ERP and S/4HANA compatible, but V_KONV would be much easier.

Thanks,

Peter

[Kaz_Iwamoto]

Hello,

V_KONV isn't in ECC.

Best regards, Kaz

[Peter_Inotai]

Hi Kaz,

Thanks for the info.

Actually V_KONV (and V_KONV_CDS) is available in our ECC 6.00 system (Ehp 8 SAP_APPL SP17).

Based on your comment now I'm sure that I should not use it.

Best regards,

Peter