SAP Knowledge Base Article - Public

1969893 - Data Source Unassigned Expenses shows the sum of Expense Amounts


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.


SAP Travel on Demand

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Click on New -> Report.
  4. Insert the name and on Data Source insert Unassigned Expenses (Technical ID:ODTUNASSIGNEDEXPENSESU01).
  5. Click on Finish.
  6. Open your newly created report and click on Go.

You will notice that the report displays a sum of the Expenses Amount key figure.


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.


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.


expense reports, unassigned expenses, ODTUNASSIGNEDEXPENSESU01, key figure, expenses amount, wrong data, report, data source , KBA , LOD-TEM-ER-DET , Expense Details , How To


SAP Cloud for Travel and Expense 1308 ; SAP Cloud for Travel and Expense 1311