2561100 - Currency Conversion in CDS Queries - Could not determine valid conversion rate for value(s) ...

• When running a CDS Query with a currency_conversion function an error such as the follows occur:

Error Database returned the SQL code 2,048. Error text: column store error: search table error: [2620] executor: plan operation failed;currency/unit ...
Error sion error,Conversion( "COL$8$", "COL$9$" ), row 760: could not determine valid conversion rate for value(s) 41.34, 41.34 from unit 'CNY' to unit ...
Error ' on date 2017-09-12 00:00:00.0000000Error Error reading the data of InfoProvider 2CCMMSPLRCMPURVAL2
Error while reading data; navigation is possible
Information CL_RSDRS_SQL_QUERY_OSQL_EXT >> Row: Inc: 48 Prog: _FETCH_DATA_OPENSQL

• In the Indexserver logfile of the HANA database more detailed information related to the error is written (Transaction DBACOCKPIT. The file starts with indexserver_alert_ (path: Diagnostics -> Diagnosis Files))

PlanExecutor.cpp(00872) : pop1 (rc 2048, search table error: 
[2620] executor: plan operation failed;currency/unit conversion error,Conversion( "COL$8$", "COL$9$" ),
row 760: could not determine valid conversion rate for value(s) 41.34, 41.34 from unit 'CNY' to unit 'EUR' on date 2017-09-12 00:00:00.0000000)
..
PARAMETERS: target_unit=>'$$place_holder_0$$', schema=>'$$place_holder_1$$', method=>'ERP', conversion_type=>'M',
lookup=>'regular', error_handling=>'FAIL_ON_ERROR', accuracy=>'highest', steps=>'convert,shift_back,shift,round',
output=>'converted, output_units, input, source_unit, target_unit, reference_date', family=>'currency'
..

• In some case a BRAIN 380 error message is visible in the ODATA Response or when testing the CDS query in RSRT:

BRAIN 380: No exchange rate from <...> to <...> and date <...> found

• SAP NetWeaver
• SAP BW/4HANA
• SAP S/4HANA

ECC, FIORI, CURRENCY, CURR, TCURR, C_SALESVOLUMEBYYEARQUERY_CDS, CDS view, BRAIN380, BRAIN 380, currency issue, F1905 , KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , HAN-DB-CDS , SAP HANA Activation of HDBDD-files (CDS Definitions) , BC-DWB-AIE-DIC , Tools in Eclipse for Data Dictionary (without CDS) , BC-SRV-BSF-CUR , Currency translation / Expiring currencies , MM-FIO , Fiori UI for Materials Management , SD-FIO-HBA , Analytical Apps , BW-BEX-OT-OLAP-CUR , Translation of Currencies or Units , Problem