Question Re: Search annotation not working when using built-in function CURRENCY_CONVERSION in Technology Q&A

Search annotation not working when using built-in function CURRENCY_CONVERSION

manoj_achar — Tue, 12 Nov 2024 15:49:51 GMT

Using 'Search' annotation we have exposed some fields data to be searched.

@search.searchable: true

@search.defaultSearchElement: true
@search.fuzzinessThreshold: 0.9
@search.ranking: #HIGH

In the CDS, 2 levels down we have used built-in function CURRENCY_CONVERSION to convert the price value depending on the currency type. Because of this, the search functionality is dumping. We have not used 'Search' annotation on this field (and subsequent fields using this field), but still it is producing error.

Appreciate any help on this.

cast( currency_conversion (
amount => final_margin,
source_currency => currency,
target_currency => cast('US$' as abap.cuky( 5 )),
exchange_rate_date => valid_from,
round => '',
error_handling => 'SET_TO_NULL'
) as zrpd_final_margin ) as Final_MarginUSD,

Re: Search annotation not working when using built-in function CURRENCY_CONVERSION

junwu — Tue, 12 Nov 2024 16:19:07 GMT

any error msg?

Re: Search annotation not working when using built-in fun...

manoj_achar — Wed, 13 Nov 2024 14:16:16 GMT

No. In the backend, it generates Native HANA sql for the search and we get a dump. There is no useful information in the termination result on why it happened.

If we comment the built-in function currency_conversion and then search, we get the search results back.

Re: Search annotation not working when using built-in function CURRENCY_CONVERSION

manoj_achar — Wed, 13 Nov 2024 14:18:36 GMT

No. In the backend, it generates Native HANA sql for the search and we get a dump. There is no useful information in the termination result on why it happened. If we comment the built-in function currency_conversion and then search, we get the search results back.