Table for checking System Status in a Service Order

[Former Member]

Hi,

In which table can I find System Status (like REL - Released) of a Service Order ?

Thanks.

Raj

[Former Member · Accepted solution]

Hi Raj,

System status you can get it from a table called TJ02T

regards

Shanmuga Satish

[peter_atkin · Accepted solution]

Guys,

TJ02 and TJ02T will not give you the status of a PM/CS order.

These tables contain the the individual system status settings.

PeteA

[Former Member · Accepted solution]

Hi Pete,

Yes System status we can get it from TJ02T and system status for PM/CS order we can get it from JEST table

regards

satish

[peter_atkin · Accepted solution]

AUFK -> JEST -> TJ02 -> TJ02T

[Former Member]

Friend

CAUFVD-STTXT

ENJOY SAP

Regards

[Former Member]

Hi,

CAUFVD is a Structure. But I want to know in which table the values (of System status for a Service Order) esp. REL is stored. Is there any other way to identify ?

Thanks.

Raj

[Former Member]

Here are some key status tables:

JEST - Object Status

JCDS - Change Documents for Statuses

JSTO - Status Object Information

JCDO - Change Documents for Status Objects

TJ02 - System Statuses

TJ03 - Object Types

TJ04 - Status Control for Object Type

TJ20 - Status Profiles

TJ30 - User Statuses

Hope this helps.

[Former Member]

Hello Raj,

Did you find out in which table the system status for a service order is saved?

Thanks!

BR,

Linda

[peter_atkin]

Linda,

The system-statuses are stored in table JEST.

An easier way to get this data is by using function module STATUS_TEXT_EDIT:

CALL FUNCTION 'STATUS_TEXT_EDIT'
           EXPORTING
                FLG_USER_STAT = ' '
                OBJNR         = I_VIAUFKS-OBJNR
                ONLY_ACTIVE   = 'X'
                SPRAS         = SY-LANGU
           IMPORTING
                LINE          = W_LINE.
*           user_line     = w_user_line.