on 2008 Dec 11 7:27 AM
Hi Friends,
In VA02 , how to identify whether a particular material(item) is invoiced, is there any indicator for this? Kindly tell me in which table the inidicator is stored?
Thanks!!!
vallamuthu
Hi,
You can check the billing status in VBUP table.
If the billing document has been created/completed to that corresponding item, then field VBUP-UVFAK = 'C'.
Hope this help.
Cheers,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SOLVED OWN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Select that particular item and press F5. You can see document flow.
Regards,
Aparna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Read into table VBFA for getting the document flow of Sales Order.
VBELV = SO Number
POSNV = SO item
VBTYP_N = 'M' (Invoice) or 'N' (Cancelled Invoice)
Sum up invoice qty and minus cancelled Invoice, then compare total invoice qty with SO qty.
If total invoice qty less than SO qty, means partially invoiced.
If total invoice qty equal to SO qty, means fully invoiced.
If total invoice qty = 0, means not invoiced yet.
Hope this helps.
Cheers,
Edited by: Ed on Dec 11, 2008 9:11 AM
User | Count |
---|---|
104 | |
10 | |
8 | |
7 | |
4 | |
4 | |
3 | |
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.