Hi community,
in our list report (ODATA V2, UI5 version 1.102.8) we have following issue with currency conversion to a currency with decimal shift, like JPY.

If I filter the "RI-Relevant Amount", the result is empty:

Filtering with vaue 1085.60 instead of 108560.000 would find the entry.
Adding the currency to additional flter dield "Display Currency", the filter works:

The consumption view looks like this:
define view /MSG/C_SingleRskRptStrucCharcs
with parameters
P_KeyDate : /msg/x_key_date,
P_ExchangeRateType : kurst,
P_DisplayCurrency : vdm_v_display_currency
as select from /MSG/I_SingleRiskReportCalc(P_KeyDate: $parameters.P_KeyDate,
P_ExchangeRateType: $parameters.P_ExchangeRateType,
P_DisplayCurrency: $parameters.P_DisplayCurrency) as SingleRiskReportCalc
{
...
$parameters.P_DisplayCurrency as DisplayCurrencyThe currency conversion for field RI-Relevant Amount takes place in the underlying view:
@Semantics.amount.currencyCode: 'DisplayCurrency'
currency_conversion(
amount => ReinsurInsrdRiskReinsurAmt,
source_currency => ReinsurInsrdRiskReinsurAmtCrcy ,
target_currency => :P_DisplayCurrency,
exchange_rate_date => :P_KeyDate,
exchange_rate_type => :P_ExchangeRateType,
error_handling => 'FAIL_ON_ERROR' ) as ReinsurInsrdRiskReinsurAmt
Changing to @Semantics.amount.currencyCode: ':P_DisplayCurrency' or @Semantics.amount.currencyCode: '$parameters.P_DisplayCurrency' in Currency conversion doesn´t help.
It seems, that the parameter P_DisplayCurrency doesn´t affect the currency conversion.
The consumption view fetches RI-relevant Amount with currency JPY with value: 1085.60, missing the two digits.
Does this seem to be a bug or is there another possibility to get this kind of filtering done on cds-level without having the additional field DisplayCurrency filled?
Best regards,
Andreas