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

Symptom

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 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 echange rate from <...> to <...> and date <...> found

Environment

SAP Netweaver 7.5
SAP BW/4HANA
SAP S/4HANA

Product

SAP BW/4HANA all versions ; SAP Fiori all versions ; SAP NetWeaver 7.5 ; SAP S/4HANA all versions

Keywords

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 , SD-FIO-HBA , Analytical Apps , BW-BEX-OT-OLAP-CUR , Translation of Currencies or Units , MM-FIO , Fiori UI for Materials Management , 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.