Looking for table with discounts already applied in sales order item

[former_member611083]

Hello, I'm very new to SAP and I'm trying to look for the table that stores the discounts already applied in a sales order item.

I've looked into CDHDR and CDPOS but it stores the old and new value of field VBAP-NETPR. I can calculate the discount based on this but I don't think its the correct way.

From the picture below, is there a way I can get the exact -8% - 1.929 CLP and -10% - 2.219 CLP from a table?

[pkwurst]

Take a look at table VBAP, but fields KZWI1 through KZWI6. These fields represent the values of subtotal 1 - 6 in the pricing procedure. In your example above the subtotal Importe descuento appears to have the total discount applied value.

To get the actual condition records you will want to look at table KONV, which has all of the condition records for the sales order. Field KNUMV comes from VBAK-KNUMV and the Item ( KONV-KPOSN ) is the line item in the sales order. KONV-KBETR will be your percentage discount and KONV-KWERT is your Condition Value.

[former_member611083]

In KZWI1 to KZWI6 appears the total discount, however I need to get each discount with its value individually.

I've checked table KONV but it is empty.

[pkwurst]

Is the entire KONV table empty, or are you just not finding the results for your specific sales order? If trouble finding the sales order check table VBAK, with VBAK-VBELN equal to your sales order number, execute, and then look for field Doc. condition ( VBAK-KNUMV ). Use the value in VBAK-KNUMV, copy it, and then look at table KONV. Paste VBAK-KNUMV into KONV-KNUMV and execute.

[former_member611083]

Sadly the entire KONV table is empty. I just did a select * from konv with 0 results

[pkwurst]

Are you looking at the database level? Try using SE16 or SE16N from SAP GUI and see if you can find any results. KONV is a cluster table, so you might have issues pulling up the data directly from the database. It is also challenging to do joins on cluster tables in ABAP, which may cause you some reporting trouble.

[former_member611083]

Yes I've tried SE16 and SE16n with no results. I guess I'll have to stick with CDHDR and CDPOS

[pkwurst]

Daniel, one more idea. Are you on S/4 HANA? I noticed that KONV doesn't appear to be updated in S/4. Check out this article https://sapyard.com/sap-s-4-hana-technical-part-2-old-new-tables-confusion/ , it suggests that a new table, PRCD_ELEMENTS, is used instead of KONV. I don't have access to an S/4 instance, so I can't confirm, but would be interested in hearing if that is the case.

[former_member611083]

You are correct. I'm using S/4 HANA and PRCD_ELEMENTS has the information I need. Thanks a lot sir, you saved my day.

[Lakshmipathi]

At the outset, it is not clear how come the same condition type flowing twice with different value. In normal circumstances, it is quite possible to store in VBAP table where you have fields KZWI1 to KZWI6 based on your pricing procedure configuration.

[former_member611083]

Yes, the condition shouldn't be twice there, it's just made for test purposes.

KZWI1 to KZWI6 will show me initial and final value. What I need to do is get every discount with its value and the user that made it.