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.
- Access the app Currency Exchange Rates
- Find and click on the conversion that you use in your system
- Click on Edit button and adjust the Valid From for a future date
Analytics; Currency; , KBA , MM-FIO-PUR-ANA , Fiori UI for Purchasing Analytics , Problem