SAP Knowledge Base Article - Public

2671820 - All project tasks are not Appearing in Report : Revenue by Team Member

Symptom

All  tasks available in a project are not appearing in this report.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business analytics work center
  2. Go to Design Reports
  3. Search for  reportRevenue by Team Member
  4. Filter with  respective project ID
  5. In rows add Project, Project task and Team member
  6. and execute you will see that few taks are missing

 However if you go to Report ID: PROPRJU05_Q0001 and do same filtering and rows and columns  mentioned above, you will see all project tasks

Cause

The purpose of both reports are different:
Report PROPRJU05_Q0001 Project Time Recordings is project based.
Report PROCPIU03_Q0001 Revenue by Team Member is expense based.


Project tasks are shown for which expenses exist.
Additionally the report has a restriction that  it excludes expenses that are assigned to a sales order item of type fixed price,the reason is that we do not calculate a revenue. for these expenses.

Resolution

In case all project tasks are needed we recommend you to create your own report based on the data source PROCPIU03 - Revenue Contribution.
which does not exclude expenses of type "fixed price".

 

Keywords

Project tasks missing in report,Revenue by team member report not pulling all tasks , KBA , AP-PRO-PRJ , Project , Problem

Product

SAP Business ByDesign all versions