on 07-23-2010 8:03 AM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.