SAP ABAP Data Element M_FORMEL (Formula)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ GBSE (Package) FI-SL sets
Basic Data
Data Element M_FORMEL
Short Description Formula  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type M_FORMEL    
Data Type CHAR   Character String 
Length 50    
Decimal Places 0    
Output Length 50    
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 Formula 
Medium 15 Formula 
Long 20 Formula 
Heading 55 Formula 
Documentation

Definition

With formula variables for numeric fields, the default value of the variables is determined by calculating the specified formula. You can use constants (1993), value variables ('VAR'), formula variables ('FVAR'), as well as SAP and user defined exits ('#S001', '#U001') in these formulas.

You can use the following operations or functions in formulas:

  • Mathematical operations:

    Addition +, subtraction -, multiplication *, division /, raising to a higher power **

  • Mathematical functions:

    Sine SIN(), cosine COS(), tangent TAN(), square root SQRT(), truncating places behind decimal point TRUNC()

  • Logical functions:

    Conditional statements: for example, IF a>b THEN c ELSE d. Nested IF statements are not possible.

The following syntax rules are still valid:

  • Variables that are used in formulas must have a numeric return value.
  • Exits that are used in formulas must also have a numeric return value. If however, the formula contains nothing but a user exit, an alphanumeric exit can be used. You will find additional information on user-defined exits here.
  • Variable and exit names must always be enclosed in single quotes ( ' ).

    Examples for valid names include: 'VAR' or '&VAR' for the value variable VAR; '#S001' for the SAP exit S001; '#U001' for the user exit U001, '#U002(VAR1)' for the user exit U002 with variable VAR1 as a parameter.

History
Last changed by/on SAP  20010607 
SAP Release Created in