Question Re: Datasphere currency conversion issue in Technology Q&A

Datasphere currency conversion issue

bohdan_kureshov — Fri, 16 Feb 2024 10:22:11 GMT

Hello everyone.

I have tried to model a view on with a currency conversion in free-plan tenant Datasphere like in this exercises - https://github.com/SAP-archive/data-warehouse-cloud-modeling/tree/main/exercises/ex3/internal-orders-currency-conversion. I also took data from there.

As a result I get an error like this: "The query executed with errors. Caught exception : exception 70000719: Conversion( "CurrencyConversionMeasure" ), row 0: could not determine valid conversion rate for value(s) 480976 from unit 'USD' to unit 'EUR' on date 2010-11-17 00:00:00.0000000 because of an error during rate lookup: invalid conversion type was found in "ABWCT" column".

If I delete that record in TCURF or replace ABWCT=EURX with empty value, I get: "could not determine valid conversion rate for value(s) 480976 from unit 'USD' to unit 'EUR' on date 2010-11-17 00:00:00.0000000"

I have tried to use CURRENCY_CONVERSION function in calculated column, currency conversion column (in View and in Analytical model); different dates and currencies; generate currency views in Datasphere, but result is the same. Are there any restrictions for free-plan tenants?

Re: Datasphere currency conversion issue

TuncayKaraca — Fri, 16 Feb 2024 15:09:44 GMT

@bohdan_kureshov Do you have a records for Currency Type (KURST) = 'M' and dates 2010-11-17 in TCURF and TCURR when you replaced ABWCT=EURX with empty value in TCURF table?

Re: Datasphere currency conversion issue

kpsauer — Mon, 19 Feb 2024 08:07:58 GMT

Hello,

please use the built in currency conversion option documented here: Enabling Currency Conversion with TCUR* Tables and Views. The archived Git-repo explains a workaround which was valid 3 years ago and is now outdated. I recommend not to use this old and archived repo, as the software advanced over the past 2-3 years dramatically and this old repo is not further maintained as you have seen on the repo status.

Re: Datasphere currency conversion issue

bohdan_kureshov — Mon, 19 Feb 2024 09:21:11 GMT

As I mentioned before, I have also tried native currency conversion column in Graphical view and in Analytical model, but the result is the same, so I don't understand what is wrong

Re: Datasphere currency conversion issue

bohdan_kureshov — Mon, 19 Feb 2024 10:00:08 GMT

I have chosen that date bacause it has record in TCURR with type M USD-EUR currency conversion.

For TCURF there is only one record with that parameters in that dataset with GDATU = 81999898 (or 01-01-1800). I have also tried to create a new record wih other date, but it didn't help.

Re: Datasphere currency conversion issue

Sai_Sriram — Wed, 01 May 2024 04:24:07 GMT

Hi Tried adding in data manually as well came up with the same errors when i tried from US to AUD. I did not do the SQL way but the standard way.

Re: Datasphere currency conversion issue

NarendraKotkar — Thu, 18 Sep 2025 13:25:08 GMT

We are facing the same issue, Any resolution found for this issue?