cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Portfolio and Project Management BI Reporting

Daniel
Explorer
0 Kudos
878

Hello @All,

I hope you guys can give me the information my colleagues and I are searching for weeks now.

Actually, we are trying to set up a BI reporting for the SAP PPM.

Our target is it, to create a kind of dashboard that shows the management relevant project information.

Therefore, we started a trace to identify the tables, where the project information are written. Furthermore, we used the SAP-Reports DPR_GUID_ANALYZE and DPR_GET_TREE to identify those tables.

Starting the reports with the Project ID (or GUID), the following tables are supposed to be the right ones:

  • CGPL_PROJECT
  • CGPL_TASK
  • CGPL_HIERARCHY
  • CGPL_RELATION
  • CGPL_ENTITY
  • CGPL_COPY_LINK
  • CGPL_TEXT
  • DPR_PROJECT
  • DPR_PHASE
  • DPR_TASK
  • DPR_PART
  • DPR_CHECKLIST_H
  • DPR_CHECKLIST_I
  • DPR_CHECKLIST_R
  • DPR_APPROVAL
  • DPR_IND_APPROVAL
  • DPR_BUPA_LINK
  • DPR_ENTITY_LINK
  • DPR_BUPA_DIST
  • DPR_PART_DIST
  • DPR_OBJLINK
  • DPR_OBJLINK_MPM
  • DPR_DOCUMENT
  • DPR_DASHBOARD
  • _VERSIONS
  • ACO_USER
  • ACO_USER_GROUP
  • ACO_ROLE
  • ACO_HR_OBJECT
  • EDMS_AT01
  • CFF_LOIO
  • CFF_PHIO
  • SKWG_BREL
  • CRM_JEST
  • CRM_JSTO
  • EVE_THRESHOLD_VL

Within the tables, we can identify the "Name" of phases; tasks and other project elements. Every single project element has a specific ID. Those IDs match to the ones within the SAP PPM. (For example task ID, phase ID, etc.)

But:

No link between Phase-ID (DPR_PHASE) and Phase-Text-ID (CGPL_TEXT)

CGPL_TEXT: TEXT1 = Name of project element

CGPL_TEXT: TEXT_Guid = Specific TEXT1-Guid

So we have a phase description with its Text-Guid. But there is no link between the phases Text-Guid and the phases ID.

Is there anybody that has an idea of how the SAP PPM tables are linked? Like srinivasan.desingh has it for SAP Project System (SAP PS Tables | SAP Blogs)

If you have any questions please feel free to ask!

Thank you in advance,

Daniel

Accepted Solutions (1)

Accepted Solutions (1)

Daniel
Explorer
0 Kudos

Dear Judith,

we might found the missing piece to solve this issue.

The following tables are relevant for recreating the projects structure in BI (or Excel):

  • IAOM_EXT_OBJ_INF (More user-friendly project hierarchy - the most important one)
  • CGPL_ENTITY (ELEMENT IDs ---> Number formats: Char <-> Raw)
  • CGPL_PROJECT
  • CGPL_TASK
  • CGPL_TEXT
  • DPR_PROJECT
  • DPR_PHASE
  • DPR_TASK

At this point, we were able to avoid BAPIs.

Using MS Excel PowerQuery for example, you can join those information and create management reports.

Question can be closed now.

Thank you for your help!

Regards,

Daniel

Answers (1)

Answers (1)

judith_gabriel
Product and Topic Expert
Product and Topic Expert
0 Kudos

Dear Daniel,

Maybe using the BAPIs - like BAPI_BUS2173_GET_DETAIL for phases - can provide all information which you are expecting. (BAPI_BUS2172* for projectdefinition)


The connection between DPR_PHASE and CGPL_TEXT is the GUID.
In table dpr_phase you can find the GUID for the phase. With this GUID you can find the corresponding entry in cgpl_entity.

Regards,
Judith

Daniel
Explorer
0 Kudos

Dear Judith,

thank you for your response.

I guess, we missed the cgpl_entity in our previous tests.

We´re gonna try the combination of BAPIs and the CGPL_entity.

I will let you know, if we were successfull or not.

Warm regards,

Daniel

Daniel
Explorer
0 Kudos

Dear Judith,

until now we were not successful. But we carry on trying.

Do you know, if there is a blog post that collects all information about BI reports / links between CGPL- and DPR-tables in SAP PPM?

I found a lot of community questions/entries about those topics. Everybody seems to have similar problems catching the right datas.

Some bulletpoints are

DPR_GUID_ANALYZE

DPR_GET_TREE

CGPL_HIERARCHY

BAPI_BUS2173_GET_DETAIL

CONVERSION_EXIT_CGPLP_INPUT

CONVERSION_EXIT_CGPLP_OUTPUT

Thank you very much!

Warm regards,

Daniel