Create a Currency Conversion Column in a Graphical View
Convert values from one currency to another or harmonize values given in various currencies with a Currency Conversion Column, which uses the SAP TCUR* to perform the calculations.
Prerequisites
To create a view with a currency conversion column, you must ensure that all of the required SAP TCUR* tables are present in (or shared to) your space, supplied with appropriate data, and encapsulated in views that have the Expose For Consumption switch enabled.
-
<Connection> - Generate currency conversion tables and views in your space and bring data in from SAP S/4 HANA Cloud, SAP S/4 HANA On-Premise, or SAP ABAP connections.
-
<Space Name> - Use currency conversion tables shared to your space and generate views to encapsulate them.
-
Manual - Generate currency conversion tables and views in your space and then manually maintain currency conversion data in them.
Procedure
- In a Calculated Columns node, click (Add New Calculated Column) > (Currency Conversion Column) to create a new Currency Conversion column.
The new column properties are displayed in the side panel.
- Enter a Business Name and a Technical Name for the column, and specify an appropriate numerical Data Type.
- Use the Currency Properties section to set the properties of your source and target currencies.
Property
Description
Source Amount Column
Select the column identifier containing the values to be converted.
Steps
Define the steps that should be included in the conversion process:
-
Shift - enables a decimal shift according to the source currency selected.
-
Convert - triggers the actual conversion from the source to the target currency.
-
Round - rounds the converted value to the number of digits of the target currency. Use this step carefully if subsequent aggregations take place on the number, as rounding errors could accumulate.
-
Shift Back - while shift changes the decimals from two to the configured precision of the source currency, Shift Back changes them back to two, but from the target currency. If error handling is set to keep unconverted the output currency might be the source instead of the target currency. In case of an error, the rounding and the Shift Back are done with respect to the source currency and the conversion is dropped. This renders all steps redundant, and yields the input value again.
Source Currency
Select the column describing the input unit. Click and choose a type:
-
Column - Select a column and click Select.
-
Fixed Value - Select a fixed value and click Select. A fixed value is a constant of the type string.
Target Currency
Select the column describing the target unit. Click and choose a type:
-
Column - Select a column and click Select.
-
Fixed Value - Select a fixed value and click Select. A fixed value is a constant of the type string.
-
Input Parameter - Select an Input Parameter and click Select. You can also directly enter the technical name in the currency conversion column's properties panel.
Reference Date
Enter the column describing the currency reference date. Click and choose a type:
-
Column - Select a column and click Select.
-
Fixed Date - Select a date on the calendar or enter it in the format YEAR-MONTH-DAY. For example, for the 1st of December 2021, enter 2021-12-01.
-
Input Parameter - Select an Input Parameter and click Select. You can also directly enter the technical name in the currency conversion column's properties panel.
-
Expression - Enter a SQL expression into the Expression field. Browse, select a category, or filter available Date & Time Functions (see SQL Functions Reference).
-
- Use the Conversion Properties section to refer to table columns for the conversion.
Property
Description
Client
Enter a three character string that is used to separate tenants within ERP system tables.
This parameter should normally be set to 000.
Conversion Type
Define the conversion type as stored in the conversion tables. The conversion types available in your system vary according to the setup of your ERP system. In general, these are either M or EURX. Contact your system administrator for the details of your specific table configuration.
Error Handling
Select a value to define how the system handles a situation where a row could not be converted. All mandatory values must be provided beforehand:
-
Fail on Error - the conversion fails with an error.
-
Set to Null - the output from the row that caused the error is set to NULL.
-
Keep Unconverted - the input value is returned.
-
- Use the Advanced Properties section to define constant parameter values used in the conversion.
Property
Description
Lookup
Define the type of lookup to be performed:
-
Regular - a regular conversion is performed.
-
Reverse - performs a conversion with the input units swapped.
Accuracy
Defines the rounding behavior of the system:
-
Compatibility - mimics ERP behavior by rounding the result.
-
Highest - keeps as many digits as possible in the result.
Date Format
Defines the format in which the reference date is presented:
-
Auto Detect - attempt automatic detection of the date format.
-
Normal - date is provided in a regular format.
-
Inverted - date is provided in inverted SAP legacy format.
Precision Entity
Select the entity to provide decimal precisions.
Default: SAP.CURRENCY.VIEW.TCURX
Configuration Entity
Select the entity to provide conversion type configuration.
Default: SAP.CURRENCY.VIEW.TCURV
Prefactors Entity
Select the entity to provide conversion factors.
Default: SAP.CURRENCY.VIEW.TCURF
Rates Entity
Select the entity to provide conversion rates entity.
Default: SAP.CURRENCY.VIEW.TCURR
Notations Entity
Select the entity to provide notations.
Default: SAP.CURRENCY.VIEW.TCURN
Currency Code Entity
Select the entity to provide currency codes.
Default: SAP.CURRENCY.VIEW.TCURC
-
- Click Validate once all properties are set to check if they are correct, and fix any error signaled. When you are satisfied, open or refresh the Data Preview panel to review the results of your currency conversion in your new column.