find Activity status

[Former Member]

hi,

i wont to now in which table i can find Activity status ,

i now that tr. cj20n but i don't now where this in tables (if open,close)

and date of opening Activity .

regards

[Former Member · Accepted solution]

Hi,

AFVC is the table for operation (activity).

The exhaustive list of system statuses is available in tables TJ02 / TJ02T. Apart from above, all the tables related to system statuses are listed below:

TJ01 Business Transactions

TJ01T Business Transaction Texts

TJ01V Responsible for business processes

TJ02 System status

TJ02T System status texts

TJ02V Responsible for system status

TJ03 Object types

TJ03T Texts for object types

TJ03V Responsible for object types

TJ04 Status control for object type

TJ05 Permitted transactions per object type

TJ06 System statuses set/deleted by process

TJ07 Influence of system status on transaction

Muraleedharan.R

[Former Member · Accepted solution]

hi MURALEEDHARAN.R

thanks for your replay!

i need to find the status of activity and not for system i get from table

afvc field vronr (activity) and i wont to check the status of it if it open or close or something else and date that open the activity .

Regards

[Former Member · Accepted solution]

hi friends,

any idea?

Regards

[Former Member · Accepted solution]

For the activity (Object Number's which start with NP) you'll find the status in table JEST.

The text of these status is available in table TJ02.

Not sure about the date bit.

Regards

Sreenivas

[abhishek_singh1 · Accepted solution]

Like said above you can get the status from the

table JEST using objnr of the activity.

entries in the table JEST which do not have 'INACT' would be active status.

To check the dates you might check the table JCDS for the key fields

MANDT

OBJNR

STAT

CHGNR

your required date and time fields are

UDATE

UTIME

[Former Member · Accepted solution]

Hello,

Please bear in mind that JCDS will only be updated if status change documents are active for the object.

For Project and WBS you can activate status change documents in OPSA (project Profile). For activities you must activate them in OPUV (Network type parameters).

Hope this helps

Regards

Martina