How can I fetch invoices in which a specific cond type is used?

[former_member303858]

Hi All,

I want to take out invoices in which a specific condition type such as freight discount is used.

In the pricing procedure we have a condition type 100% discount on freight. I want such type of invoices in which this condition type is used.

Kindly suggest me tables from which I can get this. Urgently required.

Thanks and Regards,

Satish.

[Lakshmipathi]

Dear Satish

Go to SE16, input KONV and execute. There you can see a field Condition type. Key in the condition type against which you want to retrieve the data and execute. List of all documents will flow in which you can see a tab "Doc. condition". Make a note of those references.

Next come out of the screen and again go to SE16, input table VBRK and paste the above references in the same field (KNUMV) which you can find here also.

Now you will get list of all billing documents in which the particular condition type is used.

thanks

G. Lakshmipathi

[former_member303858]

Hi Lakshmipathi,

Thanks for suggesting.I have this on my mind but as data was huge , was just finding any other way to do it.

Thanks,

Satish.

[Former Member]

HI satish,

you could get the data from the tables KONP. you couls use a querry like

READ TABLE xkomv WITH KEY kposn = komp-kposn

kschl = '.......'

to get the relevant data

Hope this helps

Thanks

akasha

[Former Member]

Hi Satish,

Use this menu path:

Easy access -> Sales information system->Enviroment->Master data>conditions-->Individual prices

Double click

Enter all required fields along with your condition type and execute(F8).

Could solve your problem.

Thanks,

Swamy H P

[former_member303858]

Hi Swami,

I tried but it giving some kind of dump/error I suppose.

Any other way out?

Thanks,

Satish.