(Glue-2411) Extractor 2.0 Transfer Rules

Introduction

With SNP Glue transfer rules you can modify the data during the extraction process. This process is similar to transfer routines within BW transformations. The functionality can be used for adjusting data, changing SAP abbreviations to more human-readable forms, currency conversion, etc. In this document, you can find some basic information about the transfer rules and current implementation. 

Transfer rules are set for each field separately. This function behaves as an end routine in BW transformations, where we change/adjust data stored in a target structure.

Currently, there are these options for transfer rules: 

• Direct assignment

• Currency conversion

• Conversion routine

• Business function

• Meaningful value

• ABAP rule

• Delete flag

• CDC flag

• CDC timestamp

Direct assignment

A value from the source field is copied without changes to the target field.

Currency conversion

The currency value is stored in a database as a number with two decimal places. This can lead to problems with currencies with none or more than 2 decimal places. As an example, the Japanese Yen doesn't have any decimals, so when we have for instance 1005 JPY, the amount is stored as 10,05 in a database.

SAP applications displaying these values, perform a conversion according to a currency key during the extraction. It is necessary to convert the value of the currency field to the correct form before it is stored in an external database.

Our functionality enables this conversion automatically, as it finds the currency key during the data load changes the particular amount into a proper value, and stores it in target storage.

You can apply currency conversion to all fields or only to selected ones using the corresponding button "Apply currency conversion" in the transformation screen of the Extraction Process as shown in the screenshot below.

Open

You can also adjust it manually by using the “Go To” button.

Open

Conversion routine

This option allows you to use SAP conversion routines (also known as conversion exits) in the Extraction Process transformation.

You can apply conversion routine rules to all fields or only to selected ones using the corresponding button "Apply conversion routines" in the transformation screen of the Extraction Process as shown in the screenshot below. After clicking on that button, the program will loop through selected fields and check their domains. If it finds a conversion routine in the definition of a domain, it will set respective rules and generate value expressions of the following view: "ALPHA ( ESRRE )", where "ALPHA" is a conversion routine and "ESRRE" is a source field.

You can also set it manually by using the "Go To" button as shown in the screenshot below. Search-help will display all conversion routines available on the system. 

Business function

This option allows you to use certain Business functions to adjust values during extraction.

Date format function

The Date format function is a special type of business function that allows you to format date values from technical SAP format into the desired ‘easy to read’ format. You can automatically apply this function on all date-like fields by pressing the Apply date format function from the toolbar of the Extractor 2.0 transformation screen.

Time format function

The Time format function is a special type of business function that allows you to format fields containing time values from technical SAP format into the desired ‘easy to read’ format. You can automatically apply this function on all time-like fields by pressing the Apply time format function from the toolbar of the Extractor 2.0 transformation screen.

Xfeld to Boolean function

The Xfeld to Boolean function allows you to translate the ABAP XFELD or FLAG field to BOOLEAN expressions, e.g. 1/0 or T/F or TRUE/FALSE. You can automatically apply this function on all fields that use domain XFELD or FLAG by pressing Apply Xfeld to Boolean from the toolbar of the Extractor 2.0 transformation screen.

XFELD_TO_BOOLEAN( VALUE, TRUE_SYMBOL, FALSE_SYMBOL ) → example: function XFELD_TO_BOOLEAN( FAILED, "1", "0" ) will take the value of field FAILED and translate it to 1(TRUE) or 0(FALSE).

Meaningful value

The original value is transformed into a more meaningful one. For example, you can easily transform the abbreviation 'AA' into the meaningful term 'American Airlines'.

Keep in mind that the data type needs to be adjusted so that longer texts fit into the target field. More information can be found in the section Data Dictionary - Data Enrichment (Meaningful values).

For every data element (e.g., 'AA') there are different ways to transform values. This information is stored in a database table and can be a part of customizing settings. You can adjust the settings in the SNP Glue Cockpit. 

In general, the system transforms the values in four different ways into meaningful values:

• Role –  takes short texts of fixed values from a domain

• Mapping – every data element contains a mapping of how an old value should be transformed into a new one

• SID – converts data element RSSID into a meaningful value

• ABAP – custom code that was written by a user

Example without using of meaningful values: 

Example with using of meaningful values:

If a meaningful value is not found for value, the system stores the original value and puts it into brackets – please see the column TYPE in the picture below. 

In the case values of the data, the element RSSID is included in the Master data table, then by a SID conversion, they are converted into a value from this table. However, this conversion makes sense for HANA-optimized cubes without dimension tables and the F table already contains SID values (this points directly to the values in the Master data table). Every part of the process (adjusting fields during table creation and making rules in the extractor) is performed automatically. For example, the source table can look like this: 

An example of converted values in the target table: 

ABAP rule

In case the value in a particular field needs to be changed, deleted, or adjusted, you can create your custom ABAP code that will be then processed for the selected field during the load.

To set up an ABAP rule, use the ‘Rule’ button in the Transformation screen and select rule type ‘ABAP rule’. A popup with ABAP editor will appear, where custom logic can be entered.

Delete flag

Assigns a 'D' flag in case of deleted records. This is possible if Fetcher has TRIGGER delta type selected and also the Read deleted entries setting is checked. Otherwise, the target field value stays blank.

CDC flag

Assigns the ‘I'(Insert), 'U’(Update), or 'D'(Delete) flag according to changes made for a specific row. This is possible if Fetcher has TRIGGER delta type selected and also the Read deleted entries setting is checked. Otherwise, the target field value stays blank.

CDC timestamp

Assigns the timestamp of change made for a specific row. This is possible if Fetcher has TRIGGER delta type selected and also the Read deleted entries setting is checked. Otherwise, the target field value stays blank.