Role and Resource Assignment across multiple projects

[Former Member]

Hello All,

I am using SAP cProject 4.5 application.

In one of the project, I have created a role as "Project Manager" (Role Type - Z001) and assigned a resource "ABC" to that role (on staffing tab)

Using same role type and resource No (BP number), I did assignment to several other projects

Now from database tables, I want to find out all projects assigned to role type Z001 and resource ABC combination

I want some BAPI / table where I can give role type Z001 and resource ABC as an input and system should give me their assignment to all projects from database

Request you to kindly provide inputs on this. If there is no single table / BAPI available, please suggest me the sequence of tables / BAPI to refer to get desired data.

PS - In cProject application under the tab Resources - Staffing when I click on resource "ABC", system opens another screen which has another staffing tab. In this tab, I can see assignment of resource ABC across several projects. I want similar data refering to database tables

Thanks in advance for your kind help

Regards,

Mayur

[former_member201206 · Accepted solution]

Hi Mayur,

as you may notice, similar functionality has been implemented in standard (result of click on resource). You can just re-use it:

Take a look of the first 45 lines of the method

CL_DPR_UI_LOG_BUPA_DETAIL=RETRIEVE_DATA_STAFFING,

The core of the codes is call of

    CALL METHOD lr_service->get_staffings
      EXPORTING
        iv_partner_guid = i_partnerguid                         " the guid of the resource 'ABC
        iv_language     = lv_langu                                  " e.g. using SY-LANGU

      IMPORTING
        ev_rc           = lv_rc
        et_staffing     = lt_res_pro.                                  " The result table.

If you would like to restric of a role type 'Z001', compare it with the column lt_res_pro.-PARTICIPANT_ROLE, it containts of the role type. That is all.

Kind regards,

Zhenbo

[Former Member]

I second Zhenbo - simply reuse the methods used in the standard system.

As for the tables, here you go --- the holy grail of resource staffing:

Table	Topic / Contains...	Lookup Attribute/Fields	Key External Join-To / FK
BUT000	Business Partner	PARTNER_GUID NAME_LAST NAME_FIRST PARTNER  (BP #) PERSNUMBER  (PERNR)	DPR_BUPA_LINK-BUPA_GUID
DPR_BUPA_LINK	Linkage between BP and Project Roles / Resources	PARTICIPANT_GUID BUPA_GUID	DPR_PART-GUID
DPR_PART	Project Roles & Resources (also called "Concrete Roles")	GUID  (Project Role/Resource GUID) PARTICIPANT_ROLE  (Role Type) CONCRETE_ROLE  (Flag to define named resource)	DPR_ENTITY_LINK-PARTICIPANT_GUID  (to Proj Structure object) CGPL_HIERARCHY-GUID  (to Project
DPR_ENTITY_LINK	Linkage between Project Roles / Resources and Project Structure Object	GUID  (Str Proj Obj GUID)PARTICIPANT_GUID  (Role GUID) ENTITY_TYPE  (linked Project Structure object type)	GUID:  CGPL_HIERARCHY-GUID  (linkage to str hier) GUID:  DPR_PROJECT-GUID  (to Projects) GUID:  DPR_PHASE-GUID  (to Phases) GUID:  DPR_TASK-GUID  (to Tasks) GUID:  DPR_CHECKLIST_H-GUID  (to Checklist Headers) GUID:  DPR_CHECKLIST_I-GUID  (to Checklist Items)
CGPL_HIERARCHY	Hierarchy of PPM Objects / Structures	GUID  (Structure Object GUID) PROJECT_GUID	GUID: DPR_PART-GUID PROJECT_GUID: DPR_PROJECT-GUID
DPR_PROJECT	Project Definitions	GUID  (Project GUID) PROJECT_ID	GUID: CGPL_HIERARCHY-GUID
DPR_PHASE	Project Phases	GUID  (Phase GUID) PHASE_ID	GUID: DPR_PART-GUID
DPR_TASK	Project Tasks / Subtasks	GUID  (Task GUID) TASK_ID	GUID: DPR_PART-GUID
DPR_CHECKLIST_H	Project Checklist Headers	GUID  (Checklist Header GUID) CHECKLIST_ID	GUID: DPR_PART-GUID
DPR_CHECKLIST_I	Project Checklist Items  (children of CHECKLIST_I)	GUID  (Checklist Item GUID) CL_ITEM_ID	GUID: DPR_PART-GUID CL_ITEM_ID:  DPR_CHECKLIST_H-CHECKLIST_ID
CGPL_TEXT	PPM Object Text Descriptions / Names	TEXT1  (Text Descriptions)	???-GUID  (of any other table/object)

Hopefully this'll help you demystify application functions and linkages without having to debug.

[Former Member]

Hi Zhenbo & Lawrence

Thank you very much for your valuable reply

Regards,

Mayur