Condition Types in Sales and Billing docs

[Former Member]

Hi

What is the best transaction or Tables to use to find either Billing docs or Sales docs that contain specific Condition records

I am looking for all orders/ invoices that contain a specific condition type that relates to discounts

Thanks

Tony

[Former Member]

Hi Friend,

The condition types you can get from the KONV table

The link between the KONV and VBRK is through the KNUMV which is the the document number

From the VBRK table and get the KNUMV and pick it and goto KONV and give the KNUMV as input and in KSCHL give the conditiontype for which you want the value

The value you can get it from KWERT field.

Hope this is clear.

regards,

santosh

[Former Member]

OK

Thats helped a bit more -

Do i then need to go back and use VBRK and upload the KNUMV docs that i have identified as having the cond type KSCHL that i require ????

This then to give me the billing docs ???

Thanks

TOny

[Former Member]

Hello Friend,

You can try the same for Billing Documents in the Table VBRK and Field KNUMV as same for the Sales Order.

[Former Member]

Hi,

Try Table KONP.....hope it will help

Thanks,

Raja

[Former Member]

Hi

KONP only tells me the number of condition records are held holding the condition type.

The condition type I am after is mainly manually entered into the sales order, so no cond record is held.

Tony