SAP Knowledge Base Article - Preview

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

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



  • SAP Netweaver 7.5


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


ECC, FIORI, CURRENCY, CURR, TCURR, C_SALESVOLUMEBYYEARQUERY_CDS, CDS view, BRAIN380, BRAIN 380 , 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 , ABAP in Eclipse Tools for Data Dictionary and 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 ONE Support launchpad (Login required).

Search for additional results

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