SAP Knowledge Base Article - Preview

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

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'
..


Read more...

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 Cloud all versions ; SAP S/4HANA all versions

Keywords

ECC, FIORI, CURRENCY, CURR, TCURR, C_SALESVOLUMEBYYEARQUERY_CDS, CDS view , 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 , MM-FIO , Fiori UI for Materials Management , BW-BEX-OT-OLAP-CUR , Translation of Currencies or Units , SD-FIO-HBA , SD - Fiori Analytical Apps , 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.