topic Re: Activity status in Application Development and Automation Discussions

Activity status

Former Member — Wed, 27 Feb 2008 09:50:50 GMT

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.

regards

Re: Activity status

Former Member — Wed, 27 Feb 2008 09:55:42 GMT

Check the JEST table.

Re: Activity status

Former Member — Wed, 27 Feb 2008 09:55:59 GMT

Hi,

The Activity Status Information is stored in table JCDS (Change Documents for System/User Statuses). You can also look into the table JEST (Individual Object Status).

The STAT field gives the status.

<REMOVED BY MODERATOR>

Thanks,

Himanshu

Edited by: Alvaro Tejada Galindo on Feb 27, 2008 4:43 PM

Re: Activity status

Former Member — Wed, 27 Feb 2008 09:57:36 GMT

Hi,

Check the following tables,

jest

JSTO

Regards,

Umasankar.

Re: Activity status

Former Member — Wed, 27 Feb 2008 10:18:42 GMT

hi,

thanks for replay but i get the activity from table afvc field vronr

field type char4 and the field in jest is type char22

do i miss something?

Regards

Re: Activity status

Former Member — Wed, 27 Feb 2008 10:25:39 GMT

hi,

thanks for replay but i get the activity from table afvc field vronr

field type char4 and the field in jest is type char22

do i miss something?

Regards

Re: Activity status

Former Member — Wed, 27 Feb 2008 10:26:18 GMT

The field OBJNR (Object Number) is the primary key field used to fetch unique record from JEST. Hence in order to get status of each object you need to get the value of OBJNR based on the other fields.