Check in Billing Document

[Former Member]

Dear Gurus,

I need to check if in a billing document exists the condition price MWST or LCIT (one of these two must exists).

I've checked a lot of ue but I've found a good one. For example LV69AFZZ is activated only if you access the price, RV60AFZZ has not the price online.

Could you help me?

[former_member183879 · Accepted solution]

Hi Max

I hope your reqmt is to find out the list of invoices with the corresponding MWST/LCIT values.

You can go to SE16 enter VBRK table, give invoice number in VBRK-VBELN and get VBRK-KNUMV

Now go to SE16 for KONV table, provide KONV-KNUMV = VBRK-KNUMV and also give KONV-KSCHL = MWST or LCIT

Now get the output for KONV-KSCHL, KONV-KWERT, KONV-KBERT,KONV-KNUMV

Now by linking the KONV-KNUMV and VBRK-KNUMV you can find out the list of invoices their corresponding tax condition type and their value by means of a VLOOKUP in an xls sheet.