Skip to Content

Looking for table with discounts already applied in sales order item

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?

va03.png (38.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • May 15 at 02:43 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 15 at 02:37 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.