Table that stores overall status of a sales order

[Former Member]

Hi all,

I have a requirement. I need to fecth the overall status of the sales order.

I found that i can see the status of sales order at header level. i want to know in which database table does the status store to access the table and fetch the data.

can some one tell me in whihc database table does overall status of the sales doc store?

any help will be highly appreciated.

Regards,

Jessica Sam

[Former Member]

Hi,

You can check some usefull data in VBAKUK like overall sales order status.

In VBUK you get the status but cannot get based on sales org level for this you need to use 2 tables VBAK and pass the values to VBUK so you can solve this issue by using single table VBAKUK.

Regards

vK

[GaryONeill]

Perfect, UBAKUK was exactly what I was looking for to get delivery/overall statuses.

[Former Member]

Thanks to all for immediate and valuable replies

[Former Member]

Dear Jessica,

However, you may check with:

VBUK - Order status

VBUP - Line item detail status

However, you must check complete status, within;

VBFA - Document flow: Let's you move from order to shipping document to invoice.

Best Regards,

Amit

[former_member217082]

Hi Jessica

Check the VBUK and VBUP tables to meet your requirement . As the document flow will be updated in these tables

Regards

Srinath

[Shiva_Ram]

Hi,

You can find the status in tables VBUK (for header status) and VBUP (for item status).

Regards,