SAP Datasphere Currency Calculation incorrect - Why?

[MKreitlein]

Dear Community,

I've been working with SAP Datasphere for almost 1 year now, but did not use currency conversion so far.

This is my first try, but somehow the result is not like expected and I hope to find experts here, to explain why this is...

I used the two SAP Help pages for my example:

https://help.sap.com/docs/SAP_DATASPHERE/c8a54ee704e94e15926551293243fd1d/b462239ffb644d9baab4442a10... 

https://help.sap.com/docs/SAP_DATASPHERE/c8a54ee704e94e15926551293243fd1d/6e3d8bed7ece4c27ba10e2cc52... 

I'm sorry for all the German column names - my example was not intended to become a community question!

I created one simple source table with Date, Value in Local Currency (USD) and Target Currency (EUR):

My conversion is executed via a graphical view and a calculated currency conversion column:

This view is contained in a dataflow, where I then fill the calculated column into my 2nd local table column:

So far so good ... but when you compare the "Wert in SW" which is the converted statistics currency, then I cannot find the right TCURR values for this calculation 😞

See here the source from my S4 system, and the loaded remote table data in my Datasphere Space:

I have only 1 set of TCUR* tables in the whole Datasphere tenant... so there is no other table containing different values.

Does anybody see in the above shown settings, how these strange values are caluclated?

When you convert USD in EUR and with the rate of Jan 9th 2023, this was: 1/ 1,07213 = 0,9327, almost what you can find via google:

So, this means, my 100 USD should be worth 93,27 EUR... but Datasphere converted: 106,40 EUR.

It does not seem like a technical error, since I chose "Set to null" in case of errors.

Any idea from the experts here?

Did anybody test this already, did you have similar issues in the beginning?

Any help appreciated 🙂

Thanks, Martin

[dominik_graus]

Hi Martin,

Could you also share the relevant content of TCURV, TCURF, and TCURN?

Regards,
Dominik

[MKreitlein · Accepted solution]

Hello Dominik,

thanks for your reply ... in the meanwhile I got some more information... and this is obviously the root cause.

It is a S4 Demo system, where I loaded the TCUR* data from.

There, the settings in TCURN obviously lead to the fact, that the following currency pair is used:

So, here From: EUR - To: USD - 100 USD / 0,93980 = 106,40 EUR.

TCURN is like:

Either line 1 or line 4 apply, since there is no entry for: From: USD - To: EUR.

I have never had this kind of customizing... I always could rely on the TCURR entries "From & To" 🙂

BR, Martin

[TuncayKaraca · Accepted solution]

Hi Martin,

I just came to see if there were any replies for your question and I saw you answered your own question. Thanks for the answer!

Regards,
Tuncay