CDS view - currency_conversion function parameters

former_member652212 — Fri, 31 Jan 2020 16:39:56 GMT

Hi -

We've created a CDS view that uses the currency_conversion function. The problem that we are running into is that we cannot call the function with parameters that are modified in the call. For example, we want to do something like this:

currency_conversion( amount => acdoca.tsl, source_currency => acdoca.rtcur, target_currency => t.waers, exchange_rate_date => dats_add_days(acdoca.budat,1,'NULL'), exchange_rate_type => 'M', error_handling => 'KEEP_UNCONVERTED' )

However, as I'm sure you know, we get the message "In function CURRENCY_CONVERSION, only columns, literals and parameters allowed".

Is there any way to call functions of these types using complex parameters WITHOUT having to create another view 'underneath' this one with the date calculation done in the underlying view?

Thanks,
Mark Chappell

topic CDS view - currency_conversion function parameters in Application Development and Automation Discussions

CDS view - currency_conversion function parameters