SAP Knowledge Base Article - Public

2946943 - Analytical apps aren't returning any data

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

  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

Keywords

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

Product

SAP S/4HANA Cloud all versions