on 01-08-2014 1:01 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.