on 2022 Nov 09 1:27 PM
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 DisplayCurrency
The 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
any breakthroughs on this issue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
10 | |
10 | |
10 | |
10 | |
9 | |
8 | |
7 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.