SAP ABAP Data Element RKE_FORMEL (Formula for an element of the key figure scheme)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KE (Package) Profitability Analysis
Basic Data
Data Element RKE_FORMEL
Short Description Formula for an element of the key figure scheme  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type CHAR60    
Data Type CHAR   Character String 
Length 60    
Decimal Places 0    
Output Length 60    
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 for an element of the key figure scheme 
Documentation

Definition

The formula is a calculation rule which defines an element of the key figure scheme. The formula links together constants and other elements of the scheme. The link may consist of standard calculation operations or those you have defined in ABAP code.

When using the formula editor, be sure to observe the following:

  1. The first line begins with '='.
  2. The elements you use must have four digits, so be sure to use leading zeros
  3. When you use elements of the key figure scheme (as opposed to constants) in a formula, these begin with the letter "Z". For example, element 10 would be written as "Z0010" in the formula.
  4. If constants with decimal places are used, you must use a decimal point (period): 1.3
  5. Negative constants must be placed in parentheses: (-1.3)
  6. Mark the end of a formula with semi-colon ";".
  7. You can use any combination of +,-,*,/, and parentheses.
  8. If one line is not long enough for the formula you want to define, you can continue in the next line. However, you must begin the next line with a mathematical operation.
  9. Instead of using standard mathematical operations, you can also use your own functions. These functions are defined as form routines in Program SAPMKEBF, and are marked in the formula by a "$". The function parameters are separated with commas and placed in parentheses.
    This function can only stand alone in the formula. Elements with other functions can be used in other elements of the key figure scheme.

Examples

Examples of calculation lines:

  • =+Z0060+Z0062+Z0064+Z0066+Z0068+Z0070;
  • =+Z0022-Z0078;
  • =+Z0080/Z0110;
  • =+Z9022*4;
  • =+Z9010*(-1.3);

Example of a calculation which continues on next line:

  • =(+Z9001+Z9002)*3+Z0080-Z0070+Z9003+Z9004+Z9005+Z9006
    +Z9007+Z9008+Z9099+Z0002+40;

Example of a calculation line with a function call (absolute function):

  • =$ABS(Z9002);
    If the absolute function was defined for the element 1000, you can define the following for the element 1010: =-Z1000;
    You can no longer use the $ function in the element 1000.

Example for a calculation line with function call (maximum function)

  • =$MAX(Z0010,Z0020);
History
Last changed by/on SAP  19980617 
SAP Release Created in