Hierarchy
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-EI-APD (Application Component) Analysis Process Designer⤷
RSAN_WB (Package) APD - Tool - User Interface
Basic Data
| Data Element | RSAN_WB_DST_UNION |
| Short Description | Transformation "Union" |
Data Type
| Category of Dictionary Type | Direct Type Entry | |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | ||
| Data Type | STRG | Character String of Variable Length |
| Length | 0 | |
| Decimal Places | 0 | |
| Output Length | 0 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Text |
| Medium | 20 | Description |
| Long | 40 | Description |
| Heading | 60 | Description |
Documentation
Use
You use this node to unify two data sources (database operation Union All).
The two data sources do not have to have the same structure. The result structure automatically includes all fields of the data sources. Fields with the same name must, however, have the same data type so that the system can add the data of both data sources to the same result column.
Activities
No settings are made for the Union transformation. You can influence the result structure by adjusting the structures of the two data sources in preceding transformations. Rename the fields using the Projection transformation if you want fields with different names to be added to the same column in the union results.
Identical data records are not removed. If required, use the Aggregation transformation as a subsequent step to condense the data by using selected group fields.
A field that only occurs in one data source is filled with the initial value in all data records from the other data source.
Example
You want to unify business partner data from an InfoProvider with additional data for these and other business partners from an external source.
You do not want to process the intersection of the data of the InfoProvider and the additional source (join); you want to process all data from the business partners from data sources 1 and 2.
Date from InfoProvider
Business Partner Age Country
0008966598 26 DE
0008467859 36 DE
Date from External Source
Business Partner Age
0008512197 45
0008121970 36
Result
Business Partner Age Country
0008966598 26 DE
0008467859 36 DE
0008512197 45
0008121970 36
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 700 |
