in-built function currency_conversion in ABAP CDS view with reference currencies?

[former_member269926]

Hello everyone,

I'm facing a challenge with ABAP CDS view and the in-built function "currency_conversion".

I'm getting daily currency rates from my bank, but only the currency pairs "foreign currency => EUR". When using my CDS View datamodel in SAP Analytics Cloud I have a problem to convert e.g. GBP => USD, because of the missing currency rates (foreign currency => USD).

In my ERP environment I have no issues with this, because of a customized "reference currency" in the system (here: EUR), e.g. the ABAP function module "CONVERT_TO_LOCAL_CURRENCY" works fine with all currency combinations. The module uses the reference currency to calculate the GBP into EUR and with the currency rate USD => EUR it's possible to get the amount at least in USD.

Did anyone of you know how to handle this "reference currency" in ABAP CDS Views?

One solution is to get all currency rates from my bank, which are needed for the reporting. However, I'm not sure if this is the right way to proceed (maybe this is too expensive since a payment has to be made for each currency). All business processes are working fine with the "reference currency", therefore this solution is not prefered.

Thank you!

Best regards,

Thorsten

[former_member269926]

Sorry, I forgot to write the details of my test environment

• Netweaver 752 Version 0003
• SAP HANA 2.0 SPS03 Rev 031.00
  
• SAP Analytics Cloud Test Tenant, Versions 2018.15.2 (Client) and 2018.15.1 (Server)

Best regards,

Thorsten