SAP ABAP Data Element RW_FORMULA (Report Painter: General formula)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-SL-IS (Application Component) Information System
     ⤷ GRWT (Package) Report Painter / Report Writer
Basic Data
Data Element RW_FORMULA
Short Description Report Painter: General formula  
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 
Documentation

Formula syntax in the Report Writer

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

  • The following operands are possible:
    • Row numbers (for example, Y001 for row 001)
    • Column numbers (for example, X001 for column 001)
    • Cells (for example, Z001 for a specific total in a report)
    • Value variables (for example, '1PERIK' for the value variable 1PERIK)
  • You can enter numbers directly, with or without a decimal point (for example, 100 or 2.5).

Example (percentage difference):
( X001 - X002 ) * 100 / X001

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

Operator    Example

ABS Absolute value    ABS(-10) = 10

DIV Quotient-whole no. div.    10 DIV 3 = 3

MOD Remainder-whole no. div.    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 Trigonomic functions (length of a curve)

Example (difference of absolute values):
ABS(X001) - ABS(X002)

  • Logical Expressions:

    IF c1 THEN f1 ELSE f2

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

    In comparison conditions, the following operators are allowed:

    <    less than

    <=    less than or equal to

    >    greater than

    >=    greater than or equal to

    =    equal to

Example (determine maximum value):
IF Y001 > Y002 THEN Y001 ELSE Y002

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