SAP Knowledge Base Article - Public

3284018 - Key figure 'Planned Work (non-aggregated)' shows wrong value in report: Customer Project Overview

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

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Open report: Customer Project Overview (PROCPIU02_Q0001).
  4. Add field 'Planned Work (non-aggregated)' into column fields.
  5. Filter by project ID, you find the value showing as X Hour(s) (X represents number of hours).
  6. Then go to Project Overview.
  7. 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

Product

SAP Business ByDesign all versions