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
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.
SAP Knowledge Base Article - Preview