cancel
Showing results for 
Search instead for 
Did you mean: 

List Report: Issue with currency conversion to jpy

Andreas05
Product and Topic Expert
Product and Topic Expert
0 Kudos
348

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.

  1. The report delivers following result:

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


    Filtering with vaue 1085.60 instead of 108560.000 would find the entry.

  3. 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

Accepted Solutions (0)

Answers (1)

Answers (1)

asimchandra
Explorer
0 Kudos

any breakthroughs on this issue?