Symptom
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.
Environment
SAP S/HANA Cloud All versions
Reproducing the Issue
Access analytical apps.
Cause
The valid date for the conversion currency (e.g CYN to EUR) is in the past.
Resolution
- 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
- Save
Keywords
Analytics; Currency; , KBA , MM-FIO-PUR-ANA , Fiori UI for Purchasing Analytics , Problem
Product
SAP S/4HANA Cloud all versions