SAP ABAP Data Element SETFRMLINE (Screen line for formula in set)
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 SETFRMLINE
Short Description Screen line for formula in set  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type KHAR79    
Data Type CHAR   Character String 
Length 79    
Decimal Places 0    
Output Length 79    
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 line 
Long 20 Formula line 
Heading 55 Formula line 
Documentation

Definition

Line of a formula used in the set. Formulas are only evaluated in the Report Writer.

Formula syntax in the Report Writer

A formula consists of operands, operators, numbers and parentheses.

  • Operands are contained by apostrophes. You can use the following operands in a formula:
    • Row numbers (e.g. '001' for row 001)
    • Cells (e.g. 'TOTAL' for a certain sum in the report)
    • Value or formula variables (e.g.'&1PERIK' for the value variable 1PERIK)
  • Cell names are alphanumeric, a maximum of 8 characters long and must begin with a letter.
  • You directly enter numbers, with or without a decimal point (e.g. 100 or 2.5)

Example (Procentage variance):
('001'-'002')*100/'001'

  • In addition to the basic operations of arthimetic + - * /, the following operators are supported:

Operator    Example

ABS Absolute value    ABS(-10) = 10

DIV Interger division    10 DIV 3 = 3

MOD Remainder of whole number division    10 MOD 3 = 1

SQRT Square root    SQRT(9) = 3

INT Truncation to integer    INT(3.9) = 3

TRUNC Truncation to integer    TRUNC(3.9) = 3

ROUND Rounding    ROUND(3.5) = 4

EXP Exponential function    EXP(1) = 2.71828

LOG Logarithm    LOG(10) = 2.3025

SIN, COS, TAN Trigonometric functions (angle of an arc)

Example (Variance of absolute values):
ABS('001') - ABS('002')

  • Logical statement:

    IF c1 THEN f1 ELSE f2

    where c1 is comparison condition, f1 and f2 are formulas.

    In comparison conditions the following operators are permitted:

    <    less than

    <=    less than or equal to

    >    greater than

    >=    greater than or equal to

    =    equals

Example (Determine maximum value):
IF '001' > '002' THEN '001' ELSE '002'

Note

  • You can insert any amount of spaces between the parts of the formula.
  • Formulas can refer to other formulas, that means formula rows are also allowed as operands.

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