Exhange Rate Billing Output

[elif100212]

In order to see an example of currency conversion on the invoice output, which CDS (Core Data Services) are you using? When I try accessing I_BillingDocumentItem and retrieve PriceDetnExchangeRate, I can see the resulting numerical value. However, I_ExchangeRate is a CDS that doesn't allow select operations inside. In my output, for instance, I'd like to see:

RON/EURO 4.9351 USD/EURO 4.7267

Do you know of any function or CDS that could help me achieve this kind of conversion?

[OwenLiu]

Changed tag to Sales.

[Former Member]

Hi @eliftklc: Can you please check the CDS view - I_BillingDocumentBasic which has a bit more details than that of the I_BillingDocumentItem.

I could see the fields - Exchange rate (from document currency into accounting currency) (AccountingExchangeRate) and Exchange rate setting (AccountingExchangeRateIsSet) whereas the I_BillingDocumentItem only has Exchange rate for price determination from document currency into accounting currency (PriceDetnExchangeRate) & Exchange rate at time of creation for statistics (StatisticsExchangeRate).

You can also build a custom CDS views based on both the views as required. I could not see exchange rate function available in the CDS views - Supported Capabilities for CDS Views, however I do think that you can try the CURRENCY_CONVERSION in the custom CDS view app. The syntax can be found here - ABAP CDS - Conversion Functions for Units & Currency.

I am not fully sure if this will work as have not done it myself, but please try out in your system and it can be confirmed.

Thanks,
Saumi