SAP Knowledge Base Article - Public

3251337 - Error message raised when opening the "Sales Volume - Check open Sales" App.

Symptom

When opening the "Sales Volume - Check open Sales" App the below message is raised:

Sales Volume:

Loading chart data failed.
Database returned the SQL code 719. Error text: currency/unit conversion error: search table error: Conversion( "COL$7$", "COL$6$", "COL$8$", ...

, "COL$9$" ), row 0: could not determine valid conversion rate for value(s) 125, 0, 0, 0, 0 from unit 'EUR' to unit 'USD' on date *2021-

:00.00.0000000 for client '100'

"could not determine valid conversion rate for value(s)"


*Please note that this date (2021) 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.

Environment

  • SAP S/4HANA Cloud

Reproducing the Issue

  1. Open the "Sales Volume - Check open Sales" App.
  2. Error message is raised.

Cause

The issue is caused by missing currency conversion rates from <XXX> to <XXX> in <XXXX>.

Resolution

Maintain the missing currency by using the “Currency Exchange Rates” App (App ID F3616).

Keywords

unit, could not determine valid conversion rate for value(s), COL$9$, Sales Volume - Check open Sales, XXX, XXX, currency, could not determine valid conversion rate for value, could not determine valid conversion,Loading chart data failed , Sales Volume, Error text: currency/unit conversion error: search table error:,  "COL$7$", "COL$6$", "COL$8$", ..., "COL$9$", S/4HANA Cloud, SD, Sales, S/4HANA , KBA , SD-FIO-HBA , Analytical Apps , Problem

Product

SAP S/4HANA Cloud all versions