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_VEC_LIST |
| Short Description | Transformation "Data Record -> List" |
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 can use this transformation to transform recurring columns in a table into several rows. The system generates from each individual data record in the input table several records in the output table.
This transformation bears similarities to the transposition of a table. During a transposition, the rows and columns are switched round for the whole table. With this transformation, however, only selected columns of the table are transposed, and all other columns are forwarded unchanged for further processing.
Example
A table contains the responses to a questionnaire. Each row of the table contains all the responses to the questionnaire:
Questionnaire Response Importance Response Importance Response Importance
Question 1 Question 1 Question 2 Question 2 Question 3 Question 3
A 2 100 1 75 4 50
B 3 80 2 66 1 33
For subsequent processing, the format of the table needs to be changed so that each data record contains the response and importance corresponding to each question:
Questionnaire Question No. Response Importance
A 1 2 100
A 2 1 75
A 3 4 50
B 1 3 80
B 2 2 66
B 3 1 33
When the analysis process is performed, part of the column name (Question 1/Question 2/Question 3) is transformed into a characteristic value for the new column Question Number. The recurring fields Response Question 1, 2... and Importance Question 1, 2... are transposed into the new columns Response and Importance.
Activities
- In the Definition tab page, select the fields to be transformed. These are the fields that are to be refilled by the transformation. In the above example, these fields are the columns Response Question 1, Importance Question 1, Response Question 2, Importance Question 2, Response Question 3 und Importance Question 3. The characteristic Questionnaire is left unchanged. These columns are deleted from the output structure.
- In the Transformation tab page, define the transformation field. By doing so, you define the new column (with name, description, and InfoObject for the column type) that is to take the characteristic value as column name. In this example, the new column is Question Number.
- Also in the Transformation tab page, define at least one transposition field to be filled by the transformation. The fields defined here are added to the output structure of the node. In this example, these are the new columns Response and Importance.
- With the steps thus far, you have now described the new output structure. You now have to define the transformation rules that describe how the field content is to be copied from the old to the new structure.
For this, go to the Details tab page and specify for each field of the original data record the row and the column of the output table that the value is to be placed in. You specify the row by means of a characteristic value for the transformation field, and you specify the column by selecting a transposition field. Example: For the column Importance Question 1, enter for Question Number the characteristic value 1, and enter the new column Importance for the column .
Runtime Behavior
The type of input columns (Response Question 1, Response Question 2, Response Question 3) should match the type of transposition field (Response). The field content is copied using ABAP-MOVE logic and converted where necessary. If conversion is not possible (for example, the FLOAT value 1.00E30 is to be copied into a decimal field of length 10), the analysis process is terminated due to overflow.
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 30B |
