cProject table data

[Former Member]

hi,

can anyone tell me the table in which the object links of the cProject are stored. i have gone through DPR_PROJECT and RPM_OBJ_LINK but i am not able to get the results.

Data : - An item is linked to a cProject.

i want to get to the related project from an item GUID and /RPM/ITEM_D helped me get the GUID with the input item external ID. Now with this GUID i want to get the related project ID. when i used the item GUID as input to RPM_OBJ_LINK it gives me the result with INTERNAL ID, OBJECT TYPE etc., but i do not get the cProject GUID.

Pls let me know if i am missing any table in between.

Thanks.

[priyatham_kasu2 · Accepted solution]

Hi Sujata,

In RPM_OBJ_LINK table,

PROJECT_GUID = ITEM guid

OBJECT_TYPE = 0INMCPROJECT

OBJECT_KEY = cProject definition guid.

Once you get the project guid, you can get project details form DPR_PROJECT table.

Best Regards,

Priyatham

[Former Member · Accepted solution]

Thanks Priyatham,

Also can you pls let me know how i can get the following table data.

Data : - A project(which is linked to an item) has a role and has some demand against a particular month.

Now when i go to DPR_PROJECT I am able to locate the project

In DPR_PART I am able to input the role id and get the details and from DPR_PART_DIST i want to know what is the ENTITY_GUID and GUID. how can i relate the role ID with this table.

Scenario - i would like to input a demand of say 10 hours against a particular month of a role under a project(related to an item), how many tables i would cut across ,what are the tables and how do i navigate from one to the other.

Appreciate your help.

[priyatham_kasu2 · Accepted solution]

Hi Sujata,

Once you have the project GUID, then tables DPR_PART and DPR_ENTITY_LINK will get the roles of that project.

Role guids and IDs can be obtained from DPR_PART.

In table DPR_ENTITY_LINK,

PARTICIPANT_GUID = role guid

ENTITY_TYPE = 'DPO'

ENTITY_GUID = project guid

you get all the valid roles for that project guid.

In table DPR_PART_DIST,

ENTITY_GUID = Role guid

Check for cProject BAPIs which can be of help to your scenario.

Best Regards,

Priyatham

[Former Member · Accepted solution]

hi Priyatham,

My observation is the entity ID in DPR_PART_DIST = role ID(from DPR_PART)+0A651F17. Your inputs did help me a lot. If i have the project ID which table gives me the roles that are there in that project. DPR_PART gives me all the results across all the projects. If i want to filter the roles related to a project alone is there any other table for reference.

Pls reply.

[priyatham_kasu2 · Accepted solution]

Hi Sujata,

You can get roles of a project from DPR_ENTITY_LINK itself.

ENTITY_GUID = project guid

ENTITY_TYPE = DPO

PARTICIPANT_GUID = Role guid

make sure that the field CONCRETE_ROLE is not set. The participant guids got here can be used in DPR_PART to get role details.

When a resource is staffed to a role, then it creates a new entry in DPR_PART as well as DPR_ENTITY_LINK by setting the field CONCRETE_ROLE = X.

Best Regards,

Priyatham

[Former Member]

Answered

[Former Member]

Answered