Introduction
...
- Direct assignment – just copies one to one data from a source field to a target field
- Routine – a custom implementation which changes the value in the selected field
- Currency – transformation of currency values according to a currency key
- Meaningful field values – translation of values according to a domain, mapping table, SID, or a custom conversion routine
Business function – adjust values with business functions
- Trigger operation type - in trigger delta extractor, fill operation type (INSERT, UPDATE, DELETE)
- Trigger operation timestamp - in trigger delta extractor, fill timestamp of the operation
- Routine: Unique recordmode - similarly to the standard routine, this transfer rule generates include for custom adjustment of data. However, this routine contains a predefined implementation for suppressing duplicate rows with the same semantic key but a different recordmode field. Moreover, because this routine is specific for recordmode field present in the Change log Changelog table, you can use it only for Change log delta type. This routine is described in more details in the chapter BW Transfer Rules.
Except for the Direct assignment, all transfer rules are represented by an "include form" which is part of the extractor form. You can access and modify them with the transaction SE38.
After creating an extractor, the system sets by default the "Direct assignment" rule. However, in case a field is of a ‘CURR’(Currency) type, the system uses the Currency conversion rule.
Default currency rule isn't assigned to a currency field when all keys from the Reference table aren't included in the Fieldname Mapping and the reference table is different than the source table. More information can be found in the chapter Structured Data Extraction.
For easy working with the Transfer rules the Fieldname Mapping provides a toolbar with these buttons:
...
In the case that 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 perform these changes:
Select Routine as a transfer rule and click in the column Edit Rule to access the generated form. The form can be edited in the same way as any Z*/Y* ABAP report. Importing parameter is_record contains the whole record which is processed. This parameter should not be modified. You can change the value of the selected field through the parameter cv_field which modifies the value according to your requirements.
...
Skip the records during the extraction process
You have an option to set up a condition to skip records during the extraction process. To perform this, you should set the flag 'gv_skip_line' under your condition.
...
Currency conversion can be disabled for BW InfoCubes. This can be achieved through the GLUE customizing table /DVD/GL_CUS_PAR, where the key value must be set to 'BW_NAMESPACE_PREFIX_+' and the parameter value should be a namespace of BW InfoCubes (for example '/BI0/' or '/BIC'). This makes sense for the tables that are part of the InfoCubes since InfoObjects have a defined currency key. Conversion of the tables in InfoCubes is currently not supported by GLUE, therefore we recommend to disable disabling all BW namespaces when creating and extracting tables.
...