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_FORMULAS |
| Short Description | Transformation 'Formula' |
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 | 0 | |
| Medium | 0 | |
| Long | 0 | |
| Heading | 0 |
Documentation
Use
Using formula transformation, you can specify one or more formulas for which the results are to be provided in the output table as additional fields.
You can still access the input data (input fields) for each formula. A range of system fields are also provided.
The result of a formula is calculated line by line at runtime; this calculation is based on the input data table and the result is written to the corresponding formula field.
In addition to the basic mathematical functions available, a range of standard transformations such as date functions, functions for character strings, or logical comparison operators are also provided. For more information about working with transformations, see the transformation library. This also describes how you can create customer-specific transformations as BAdI implementations.
For more information about the functions of the formula builder and how to work with it, see the operating instructions.
Activities
- Define a formula field for each formula required by choosing "Insert Row" and entering a unique field name, a description, and an InfoObject for classification, in this new row.
- Define a formula for a formula field by choosing the pushbutton with the formula icon in the relevant row. You can also do this by double-clicking. You create your formula in the lower part of the screen. When creating your formula, make use of the option to access the contents of the input fields.
Example
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 700 |
