Symptom
When you create a report on top of this Data Source, you realize that the report is displaying the sum of Expenses Amount key figure.
Environment
SAP Travel on Demand
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports view.
- Click on New -> Report.
- Insert the name and on Data Source insert Unassigned Expenses (Technical ID:ODTUNASSIGNEDEXPENSESU01).
- Click on Finish.
- Open your newly created report and click on Go.
You will notice that the report displays a sum of the Expenses Amount key figure.
Cause
The reason for such behavior is due to the fact that the Data Source has been created on a Supplier level, which means that if you do not use Supplier characteristic at either Rows or Columns, then the report will display the sum of Key Figure Expense Amount.
Resolution
To resolve this case, you need to drag characteristic Supplier from Not Currently Shown into either Rows or Columns.
This will then make the report run on its basic level and return the correct amount of Expense Amounts.
Keywords
expense reports, unassigned expenses, ODTUNASSIGNEDEXPENSESU01, key figure, expenses amount, wrong data, report, data source , KBA , LOD-TEM-ER-DET , Expense Details , How To