cProject - table for system status of a task

[matthias_fischer]

Hello all,

we are on cProject suite 4.0

We want to start a workflow depending on the system status of a project task.

In which table the system status are stored?

How was the reference to the task (e.g. guid from DPR_TASK or anything else)?

Can anybody help me?

Regards Mafi

[thomas_berndt]

Hello Rafi,

the table you're likely want to check is CRM_JEST.

Field OBJNR is the one that takes the task's GUID as selection criterion.

I hope this provides the answer you seek.

Best regards,

Thomas

[matthias_fischer]

Hello Thomas,

thanks a lot.

The CRM_JEST contains the cProjects system status and aditionally I found the

CRM_JCDS which contains the information which status was set when.

Best regards, Mafi

[Former Member]

Check the table DPR_TASK field PROC_STATUS_OWN for the status of the Task and field PROC_STATUS_SUP for the phase to which the task is assigned.

Field TASK_ID of this table (appears as Number in the basic tab of task) can be referenced.

Regards

Sreenivas

[matthias_fischer]

Hello Sreenivas,

looking at the table DPR_TASK there are no entrys for the fields PROC_STATUS_OWN,

PROC_STATUS_SUP and STAT_PROFILE_TSK.

I need the system status (released, in process, completed). It must be stored in another table.

Regards Mafi