Table to find system status

[Former Member]

Dear All,

I need a table where I can see the status of the Project/WBS.

The system statuses are available in table TJ02, how can i link this with a particular project and WBSE?

Thanks & Regards,

VDS

[Former Member]

Hi,

JEST table contains object status that is either system status or a user status. Field STAT corresponds to the Object Status. Field INACT identifies whether the status is currently active or inactive and field CHGNR is the change number that identifies the change documents for an object and is incremented serially.

TJ02 table contains the list of system status and description. All statuses in this table are internal. This means they are consistent across objects and clients. A single object can have multiple active system statuses and user statuses & inactive ones.

TJ30 table contains the list of user status and TJ30T contains their description.

You could use function module STATUS_READ read active object status and STATUS_OBJECT_READ to retrieve the status profile of an object number.

The status tables are based on object numbers which are a concatenation of the object type and the table of that object. Order #816025 would be stored as "OR000000816025". Equipment 20701817 would be stored as "IE000000000020701817". Sales order item 10 of 5215 would be stored as "VB0000005215000010".

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

TJ02T - Text for system status

TJ30T - Text for user status.

Thanks ,

Dhruv

Edited by: Dhruv Kumar Malhotra on Jul 9, 2009 10:51 AM

[Former Member]

Hi,

Goto JEST table pass OBJNR which will be picked up from PRPS by passing WBS element.

Pick the status which are active and pass the same in TJ02.

where you will get the description of those statuses.

Rgds

Sudhir Reddy

[former_member203098]

Hi,

From Table PRPS(WBSE) -

---

By giving the WBSE we can get object number.

JEST (object number) -

---

By mentioning the Object number and status from TJ02 we can get WBSE in that particular status.

Regards,

Nag.