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.

You can use the Currency Conversion Views dialog to provide these objects in your space for any of the following situations:
  • <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.

For more information, see Enabling Currency Conversion with TCUR* Tables and Views).

Procedure

  1. 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.
  2. Enter a Business Name and a Technical Name for the column, and specify an appropriate numerical Data Type.
  3. 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).

  4. 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.

  5. 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

  6. 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.