Symptom
You find key figure 'Planned Work (non-aggregated)' shows wrong value in report: Customer Project Overview. It only shows the planned work for the first project task.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports view.
- Open report: Customer Project Overview (PROCPIU02_Q0001).
- Add field 'Planned Work (non-aggregated)' into column fields.
- Filter by project ID, you find the value showing as X Hour(s) (X represents number of hours).
- Then go to Project Overview.
- Here you find the total planned work for the project is X+N Hour(s) (N reprenests the planned work on other project tasks than the first task).
Cause
The reason for this behavior is that “Planned Work (non-aggregated)” is coming from the data source PROCPIU02. It is a union data source including several basic data sources. “Planned Work (non-aggregated)”( TSK_PLAN_WRK) is derived from the basic data source PROCPIB04.
It is representing the data only on the project task level.
Resolution
Currently there is no such key figure available for total planned work from the project.
An alternative way is to use key figure: Operative Planned Work (Task) based on data source PROPRJU05. This key figure retrieve the data from project task level and thus display the desired values.
See Also
KBA 2813939 - Planned Work shows Doubled value in Project Report
KBA 2017844 - Key Figure "Planned Work (h)" Shows Wrong Value in Customized Report
Keywords
Planned Work, Project Report, Customer Project Overview, Planned Work (non-aggregated) , KBA , SRD-PRO-PMN , Project Management , Problem