...
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 For 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.
...
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.
...
You can also adjust it manually by using the “Go To” Go To button.
...
Note |
---|
Unsupported reference tables:
|
...
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.
...
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 easy-to read’ -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.
...
Note |
---|
The usage of this business function is dependent on the SNP Glue table structure. You need to replace SAP data elements of date-like format with character-like data elements because of the resulting format being character-like. You can set the replacement of data elements to apply automatically in the transaction /DVD/GL_SETT by specifying the parameters DEFAULT_DATE_FORMAT and ROLLNAME_REPLACEMENT_DATE. More information about these parameters and their meaning can be found in the chapter Glue Settings. |
...
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 easy-to read’ -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.
...
Note |
---|
The usage of this business function is dependent on the SNP Glue table structure. You need to replace SAP data elements of a time-like format with character-like data elements because of the resulting format being character-like. You can set the replacement of data elements to apply automatically in the transaction /DVD/GL_SETT by specifying the parameters DEFAULT_TIME_FORMAT and ROLLNAME_REPLACEMENT_TIME. More information about these parameters and their meaning can be found in the chapter Glue Settings. |
...
In general, the system transforms the values in four different ways into meaningful values:
Role – takes : Takes short texts of fixed values from a domain
Mapping – every : Every data element contains a mapping of how an old value should be transformed into a new one
SID – converts : Converts data element RSSID into a meaningful value
ABAP – custom : Custom code that was written by a user
Note |
---|
Please note: If meaningful values are missing some content, run the program '/DVD/GL_BPL_SPKFL_CONTENT_GEN'. |
Example without using of meaningful values:
...
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.
...
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 It assigns the timestamp of a change made for a specific row. This is possible if Fetcher has has the TRIGGER delta type selected and also the and the Read deleted entries setting is checked. Otherwise, the target field value stays blank.