Hierarchy

⤷

⤷

IMG Activity
ID | 0FILA003_1 | Determine Value Using Formula |
Transaction Code | S_XB7_96000153 | (empty) |
Created on | 20010926 | |
Customizing Attributes | 0FILA003_1 | Determine Value Using Formula |
Customizing Activity | 0FILA003_1 | Determine Value Using Formula |
Document
Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
Document Name | VV_TFILA_GF_003C |
Use
This IMG activity provides an additional, very flexible option for creating value IDs. When you use this option, the system calculates the value IDs using formulas. The use of formulas makes it possible for you to form new value IDs, for example, as the sum or difference of other value IDs.
For documentation on the exact syntax of the formulas, refer to:
Function module Analysis of a syntactically correct formula
Requirements
Standard settings
Recommendation
Note that you can only use value IDs to create a formula if the value IDs represent numbers. For example, if you want to add two value IDs in a formula, and one of the value IDs contains alphabetic characters when the contract is executed, processing terminates.
Remember that value IDs are allowed to contain all different data types (for example, alphanumeric, numeric, time data).
Further notes
It is also possible to use value IDs, which are themselves the result of calculation using a formula, in the formula of another value ID.
Example:
A, B, C, D are value IDs
A and B receive their values from condition types
C is defined by the formula C = A + B
D is defined by the formula D = C * 50 / 100
If the conditions of the contract supply value IDs A and B the values A = 1000.00 and B = 200.00, then the system calculates that C = 1200.00 and D = 600.00.
You should be very careful when using formula-based value IDs in other formulas, because unsolvable dependencies can result. If the system does not find a result after ten interactive steps, it terminates solving the formula and issues an error message.
It is also possible to use texts directly as a comparison value in a formula. You need to place the text between double quotation marks ("Text") and add a dollar sign ($) to the 'IF' statement.
Example:
IF$ var1 = "TEXT" THEN var2
Other uses of texts are not permitted in formulas.
Business Attributes
ASAP Roadmap ID | 105 | Define functions and processes |
Mandatory / Optional | 1 | Mandatory activity |
Critical / Non-Critical | 1 | Critical |
Country-Dependency | A | Valid for all countries |
Maintenance Objects
Maintenance object type | C | Customizing Object |
Assigned objects | ||||||
---|---|---|---|---|---|---|
Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
V1_TFILA_GF_003 | V - View | 0FILA003_1 |
History
Last changed by/on | SAP | 20030603 |
SAP Release Created in | 461 |