SD How to find condition table actually for a sales/billing doc item

[DrenthBL]

Hi. I need to find a way to determine which condition tables are most frequently used by condition type.

Looking at an invoice, I can use the condition document number in VBRK to find the KONV record with the pricing at an item/step level. The KONV record has a condition number that is also included in the condition table (A9xx) and KONP. Other than looking at each of the condition tables in the access sequence for the specific condition type, any ideas how I can find the specific condition table that contains the condition number from KONV?

[hsyngvural]

Hello,

You should join KONV with KONH (based on KNUMH). KVEWE and KOTABNR fields of KONH table will give you the source condition table, collectively.

Best regards.

[DrenthBL]

thank you! I will give this a try.