Table name for the SO line item status for Sales Order

[Former Member]

Hi

Need the table name for the sales order line item status Cstd

Steps

Go to the sales order line item

go to the Tab status

under that in processing status--> system status

here Cstd is there but we are not able to find the table name for that

Strecture is RV45A and field name is STTXT

we are planing to restrict the PP order being released if the status is not Cstd

PP order should release if the status in Sales order line item is Cstd

Can you help to findout the table name foth above field

Thanks

Kameshwar Rao

[Former Member · Accepted solution]

Hi

I need to get the status for sales order line item. provided tables not fullfilled our requirement

Thanks

Kameshwar Rao

[former_member209761 · Accepted solution]

Hi,

The status of sales order line item will be available in the table VBUP.

Check and revert back.

Thanks & Regards,

Hegal K Charles

[Former Member]

Hi,

Table: TJ30T - Texts for User Status.

Table Contents:

MANDT MANDT CLNT 3 0 Client

STSMA J_STSMA CHAR 8 0 Status Profile

ESTAT J_ESTAT CHAR 5 0 User Status

SPRAS SPRAS LANG 1 0 Language Key

TXT04 J_TXT04 CHAR 4 0 Individual status of an object (short form)

TXT30 J_TXT30 CHAR 30 0 Object status

LTEXT J_LANGTEXT CHAR 1 Long text flag

Regards,

Saju.S

[former_member209761]

Dear Kameshwar Rao,

The status of line item will be available in the table VBUP.

If you want the status at header level, it is VBUK.

Check and revert back.

Thanks & Regards,

Hegal K Charles

[jignesh_mehta3]

Hello,

Access the following tables for all Status:

1. VBUK - Sales Document: Header Status and Administrative Data

2. VBUP - Sales Document: Item Status

3. VBAKUK - Conbines Status View table.

Just access the above tables & all your queries will be solved.

Thanks,

Jignesh Mehta

[former_member188076]

Hi

Check the table VBAKUK.

Regards,

Amitesh Anand