cProjects Fields - Structures and field Controls

[Former Member]

Hi,

On the Project -Additional Data tab on cProjects, we have a field which is called Project "Created by". I am trying to locate where is that field stored in the tables. I saw that under the field controls ,an external structure is maintained and this feild is available there but not sure how to view the data in that structure ( i guess we can't view this data as its under a structure).

Since we have the accounting integeration on, so when we transfer the Project ,the Projects gets created in the backend ( ECC) with a "created by" of the repsective cProjects server name.

All I am looking for is who created the Project ( as in cProjects) and the date on which it was created.

Thanks.

[Former Member · Accepted solution]

Hi,

The structure is DPR_TS_UI_PRJ_DATA.

If you need to get the values you should use method get_detail_data of class cl_dpr_ui_log_project_detail.

Regards,

[Former Member · Accepted solution]

Thanks for the reply, I don't see this available in any data base tables?

So I run some program to get the values per Project?

[Former Member · Accepted solution]

Hi,

Also, you can see additional values with CGPL_PROJECT table.

Regards,

[Former Member · Accepted solution]

Thanks that works, but it seems that it is missing the Project ID as it works on the GUID. May be we need to join DPR_PROJECT and CGPL_PROJECT.

[Former Member · Accepted solution]

I think we can lik it via CGPL_ENTITY as that one has the GUID.

Problem solved. Thanks again.