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.

[Jelena]

I completely agree with Lakshmipathi - this should be handled through the incompletion procedure in the preceding document (either order or delivery).

The user exits in the billing documents are not meant to be used for such verification. When the document goes to billing, it should already be correct.

If this is some kind of an odd exception, such verification may also be handled in the copy control routine from order/delivery (whichever applies) to the billing document. Although this is a rather ugly way of doing it and I wouldn't recommend it, especially because a perfectly acceptable standard solution exists.

[Former Member]

Thank you for your prompt answer.

But I need to check if it exist condition MWST or LCIT in transaction VF01, in the invoice creation.

It's for this reason that I'm looking a userexit.

[Lakshmipathi]

I need to check if it exist condition MWST or LCIT in transaction VF01

I would prefer to have an incompletion log in OVA2 for sale order itself, so that there is no need to check at the time of billing document creation.

On the other hand, still if you feel that a check should be made at the time of VF01, then you can try with billing exit USEREXIT_FILL_VBRK_VBRP (Module pool SAPLV60A, program RV60AFZC)

thanks

G. Lakshmipathi

[Former Member]

But in ue USEREXIT_FILL_VBRK_VBRP I haven't the field VBRK-KNUMV valued and I haven't KONV on line for doing the check...

Regards

[Lakshmipathi]

Not sure whether I understood your explanation correctly. If my understanding is correct, you want to check which are all the documents that have any of those two condition types.

If this is correct, you can very well check in table KONV and the link between VBRK and KONV is KNUMV.

thanks

G. Lakshmipathi