SAP Knowledge Base Article - Preview

3632161 - Error "could not determine valid conversion rate for value(s) &1, &2, &3, &4, &5 from unit &6 to unit&7" when opening sales analytical apps - SAP S/4HANA Cloud Public Edition

Symptom

When opening one of the sales analytical apps, for example, Sales Volume - Check open Sales app, Sales Volume - Flexible Analysis app, the following message is raised:

Database returned the SQL code 719. Error text: currency/unit conversion error: search table error: Conversion( "COL$2$", "COL$3$", "COL$4$", ...

, "COL$6$" ), row 0: could not determine valid conversion rate for value(s) 0, 0, 0, 0, 240 from unit 'EUR' to unit 'USD' on date 0001-01-01 ...

0:00.0000000 for client '100'

*Please note that this date (0001-01-01) is specific for this particular example; in other instances, the date may vary.
*Please note that units (EUR and USD) are specific for this particular example; in other instances, the units may vary.

Besides, there is at least one Invoice with a Billing Date empty or before 01/01/1801.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

SAP S/4HANA Cloud Public Edition

Product

SAP S/4HANA Cloud Public Edition all versions

Keywords

unit, could not determine valid conversion rate for value(s), loading chart date failed, Sales Volume - Check open Sales, currency, could not determine valid conversion rate for value, could not determine valid conversion, 0001-01-01, Sales Volume, Error text: currency/unit conversion error: search table error, conversion, 1801, SAP S/4HANA Cloud Public Edition, SD, Sales, S/4HANA, database returned the SQL code 719 , KBA , SD-ANA-2CL , Analytics (Public Cloud) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.