Skip to Content

Check in Billing Document

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 23, 2010 at 07:11 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 23, 2010 at 07:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 23, 2010 at 07:24 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 23, 2010 at 08:33 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded