SAP ABAP IMG Activity 0FILA003_1 (Determine Value Using Formula)
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   FI-LA (Application Component) Lease Accounting
     FI_LA_GF (Package) Lease Accounting General Functions
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