SAP Knowledge Base Article - Public

2946943 - Analytical apps aren't returning any data


When you access analytical apps (e.g Monitor Purchase Scheduling Agreement Items, Purchasing Spend Dashboard) the app shows "Unable to retrieve data from the database" or return the error "Database returned the SQL code 719. Error txt: currency/unit conversion error" after you insert the Currency in the Display Currency filter.


SAP S/HANA Cloud All versions

Reproducing the Issue

Access analytical apps.


The valid date for the conversion currency (e.g CYN to EUR) is in the past.


  1.  Access the app Currency Exchange Rates
  2. Find and click on the conversion that you use in your system
  3. Click on Edit button and adjust the Valid From for a future date
  4. Save


 Analytics; Currency; , KBA , MM-FIO-PUR-ANA , Fiori UI for Purchasing Analytics , Problem


SAP S/4HANA Cloud all versions