With the help of operators, you can create mapping rules, which control how source data is mapped to the target area. The mapping rules of a method are dependent only on the consolidation area.
The following operators are available:
• Condition
• Move
• Reassignment
• Apply existing rule
Condition
You can draft a mapping rule with or without a condition. A condition must always be followed by another operator (for example, move or reassign).
In the details of a condition you specify the characteristic values to which the condition applies. You also can use single selections. A condition has the effect of a filter on the source data records.
You can create multiple conditions per target characteristic.
Move
The move operator maps one or more source fields to a single target field.
If some of the field names in the source and target structures are identical, you can choose Create Proposal.
Then the system automatically creates the moves for each of those fields and displays the moves in the list of target fields beneath each field. (This also applies to the permanent parameters.)
• To move a single source field to a single target field, you specify the source field in the move details.
Furthermore, in the details you can specify an offset and a length to reference the technical key of the source field.
Suppose your source system has a source field for characteristic item with a length of 18 characters, where the leading eight characters are used to describe the item in the hierarchy.
In the details for the move, you would enter:
• Length = 10
• Offset = 8
When mapping is executed, the system would copy the last ten characters (positions 9-18) of the source characteristic to the target characteristic.
To cut out portions of a source field value, you can use separators and indexes.
Suppose the source field has a length of 18 characters. It has the following composition: <profit center>-<company>.
In the target data basis you have defined a matrix organization with companies and profit centers.
You choose the character "-" as the separator. For index 1 you specify <profit center> and for index 2 you specify <company>.
In this way, the source field is used twice.
• To move multiple source fields to a single target field, you specify a concatenation rule in the move
details (table). Then the system concatenates the contents of the source fields you specify.
Here you also can specify offsets and lengths, and/or separators and indexes.
Suppose your source structure includes the fields company and profit center.
You want to fill a target field for the characteristic consolidation unit with a length of 18 characters. You want to compose the target field as follows:
• Character 1 = "C"
• Characters 2-7 = the content of the field "company"
• Character 8 = "P"
• Characters 9-18 = the content of the field "profit center"
In the details for the move, you would enter the following in the table:
• Line 1: Constant = C
• Line 2: Move field "company"
• Line 3: Constant = P
• Line 4: Move field "profit center"
To prevent excess spaces between the components of the target field, you can choose Trim Marginal Spaces.
You can define one or more constants for the target characteristic value regardless of whether you move a single or multiple source fields. Constants are always set as you define them, regardless of what the source characteristic value looks like. For example, you can define that the fiscal year variant is always set to "FY4".
You can populate a target characteristic value with one or more attribute values of a source characteristic (for example, the attribute country of characteristic profit center). You specify attributes within the table in the details for the move.
Reassignment
When you want to assign multiple source fields to a single target field, you can use the reassignment operator as an alternative. Here, the value of the target field is determined by the values of the source fields.
Suppose the values of the source fields are PC1000 (for the profit center) and C1000 (for the company). In this case, the value of the target field consolidation unit is reassigned with CU0001.
You can use single selections in reassignments, as well.
Applying Existing Rules
If you assign a name to a mapping rule, that rule can be reused. (To do this, double-click the target field and assign a name for the mapping rule in the dialog box that appears.)
Now you can use this mapping rule for master data-equivalent characteristics in the same or a different set of mapping rules. Examples of master data-equivalent characteristics are consolidation unit, partner unit, and investee unit.
Activities
Proceed as follows to define a set of mapping rules:
...
1. To begin with, you can create move operation proposals for source and target fields by choosing
Create Proposal (see earlier).
Examine the proposed moves.
2. You can create your own mapping rules for all target fields that have no proposed moves.
To do this, select the target field in the list and choose one of the following commands in the context menu:
{ Create Condition
{ Create Move
{ Create Reassignment
{ Apply Existing Rule
Create Condition
...
a. In the details of the condition, specify the characteristic values to which the
condition applies.
b. Create a move or a reassignment for the condition, or apply an existing rule.
Create Move
{ To move a single source field to a single target field, specify in the move details, if applicable, an
offset and length for the source field and/or a constant and an attribute.
{ To move a multiple source fields to a single target field, specify in the move details the
concatenation rule (and, if applicable, specify an offset and length or a separator and indexes, with or without constants and attributes).
Create Reassignment
To display the source characteristics in the respective table columns, choose the corresponding symbol in the toolbar above the table and select the desired source characteristics in the list.
Apply Existing Rule
To apply an existing rule, call up input help in the details of the mapping rule field and choose a rule.
Specify the substitution field.
3. Continue customizing the data collection method.
Selection
Use
You use this function to restrict the scope of data to be collected and to restrict the area in which posting is to be possible.
As in mapping, you use a selection in the following data collection methods:
• Flexible upload (optional)
• Load from data stream
• Copy (optional)
Activities
...
1. Define the area in the source InfoProvider, from which data is to be loaded.
To do this, specify the desired characteristics and characteristic values. Single selections can be used for this purpose.
The system attempts to perform an inversion for the status-relevant characteristics. When doing this, the system takes into account the permanent parameters and inversely interprets your mapping rules.
This means that it derives the source selection from the mapping rules between the source and the target.
If the automatic inversion does not produce a result or if it is too complicated, too many data records are selected in the BW System. Therefore, at this point you need to restrict the data to be selected in the source selection.
2. Define the target area in the data basis, into which data is to be loaded.
You can use a target selection to control which data of a consolidation unit is modified. To do this, you make restrictions to financial statement items and subassignments in the target selection. You also can use single selections.
If you choose Delete All in the settings in update mode, the system deletes the records that already exist in the target area of the data basis before your data is loaded.