2020 Dec 01 5:15 AM - edited 2024 Feb 04 12:54 AM
Hello together,
how can we implement a currency conversion directly in a CDS View in S4HC if the CDS View is exposed as API?
The CDS View cannot be published using the function currency_conversion() in a calculated field in the app "Custom CDS View".
currency_conversion(
amount => I_BillingDocumentItem.NetAmount,
source_currency => I_BillingDocumentItem.TransactionCurrency,
target_currency => cast( 'USD' as ABAP.CUKY( 5 ) ),
exchange_rate_date => I_BillingDocumentItem.CreationDate,
exchange_rate_type => 'M',
error_handling => 'FAIL_ON_ERROR',
round => 'true',
decimal_shift => 'true',
decimal_shift_back => 'true'
)
However displaying the data preview of the CDS View is showing the correct values. Publishing the CDS View is not allowed. As the following error mesage is displayed:
Element contains a not supported formula.
APS_CCV_CHECK/008
We are also not able to derive the correct Exchange Rate from CDS View I_ExchangeRate as it is only containing one date (ExchangeRateEffectiveDate). So we are missing the DateTo as ExchangeRateEffectiveDate can be interpreted as DateFrom.
Best regards
Philipp
Request clarification before answering.
Hello Philipp,
Were you able to get any solution for this Currency Conversion issue ?
Regards,
Ankit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
118 | |
8 | |
8 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.