Get Exchange Rate
In order to extract the direct exchange rate between two currencies, the Get Exchange Rate function is used.
Parameter | Description |
---|---|
Rate Type | The Exchange Rate Type in SAP |
Currency | The From Currency |
Currency | The To Currency |
Date | The Date of Exchange. Note that if there is not a rate maintained for this date, the function will return the most recent rate prior to that date. |
Attribute | This parameter determines the value that is returned in this cell:
Leave blank to return the Direct Exchange Rate Select “Date” to return the exchange rate date recorded in SAP (useful if there is no direct rate maintained on the date specified) Select “From Factor” if required to apply to the rate Select “To Factor” if required to apply to the rate Select “Indirect Rate” to return the Indirect Exchange Rate (useful if there is no direct rate maintained in SAP) |