Check whether sales order has been invoiced.

[Former Member]

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

[former_member204513 · Accepted solution]

Hi Dinesh,

Try with VBFA table

I hope it will help you,

Regards,

Murali.

[Former Member]

This message was moderated.

[Former Member]

Solved on my own. Thanks to all for replies.

[Former Member]

Hi,

You need not go for the table , just click on the document flow in va02.

Regards

Chetan

[Former Member]

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.

[Former Member]

Hello,

You can check the same form the Document flow of sales order. The table and field is VBFA and VBELN respectively.

Prase

[Former Member]

Two ways for this..

(1) Thru VTFA table ..VBELN

(2) Check the Doc Flow (click on the buttton on the -VA03 screen)

Cheerzz..

Subbz..

[Lakshmipathi]

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