on 2021 Feb 16 7:35 AM
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:
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
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):
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
4 | |
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.