on 07-08-2008 6:01 AM
Hi All
I have to check whether a sales order has been invoiced or not. Can anybody provide the data base table name and field name where this information is stored.
Points for sure.
Thanks
Dinesh
Hi Dinesh,
Try with VBFA table
I hope it will help you,
Regards,
Murali.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Solved on my own. Thanks to all for replies.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You need not go for the table , just click on the document flow in va02.
Regards
Chetan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
VBUP-FKSAA : Billing status for order-related billing documents. (at the item level)
VBUP-FKSTA : Billing status of delivery-related billing documents
VBUP-LFSTA : Delivery status (of the Item).
So if the order is directly billed(like credit memo) then you can get the value from VBUP-FKSAA
If it is delivered and then billed the you have to get the Delivery No using VBFA or LIPS table and then the billing status of the delivery from VBUP-LFSTA field and then billing status from VBUP-FKSTA field of the relevent delivery no.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
You can check the same form the Document flow of sales order. The table and field is VBFA and VBELN respectively.
Prase
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Two ways for this..
(1) Thru VTFA table ..VBELN
(2) Check the Doc Flow (click on the buttton on the -VA03 screen)
Cheerzz..
Subbz..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Dinesh
table VBFA - field VBELN for billing document.
In the above table, you have to input sale order reference in the field Preceding doc and M in Subsequent document category.
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 |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.