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_SORT |
| Short Description | Transformation "Sort" |
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 sort the data according to the selected fields. The node can be integrated into an analysis process at any point in that process. Use the node when you want to use the function Display data to display the data in sorted form.
Runtime behavior
To sort the data, first all the data is read from the data source, buffered in the interim and then made available in sorted form to the subsequent transformation.
Note
Since almost all transformations sort according to grouping fields, adding a sort in this type of transformation will only lead to a decrease in performance because the data is sorted once unnecessarily. The sort transformation is especially not suited to sort the data for the call of a routine transformation.
The data structure is not changed during the sort.
Activities
- Select the fields that the data is to be sorted by.
- Specify the sort sequence. The default setting is to sort ascending, but you can also set the Descending indicator.
Runtime behavior
For the data to be forwarded after sorting, all data must first be read. After the sort, the data is forwarded to the subsequent nodes.
Example
The master data for the business partner (0BPARTNER) is to be read sorted. In addition to the source Characteristic, a node for the sort is included in the model. If you select the Business Partner field as a sort field and do not make any other setting for the sort sequence, then, after the analysis process has been performed, the data to be forwarded from the node is sorted ascending by business partner.
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 30B |
