SAP ABAP Data Element RSFOB_FUNCTIONS (Formula Editor Functions)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DST (Application Component) Data Staging
     ⤷ RSFO (Package) Integration of Formula Editor in Transfer/Update Rules

Basic Data

Data Element	RSFOB_FUNCTIONS
Short Description	Formula Editor Functions

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	CHAR1
Data Type	CHAR	Character String
Length	1
Decimal Places	0
Output Length	1
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	Functions
Medium	15	Functions
Long	20	Functions
Heading	30	Formula Editor Functions

Documentation

Definition

The formula builder enables you, in collaboration with the transformation library, to easily create formulas, without using ABAP code. You can also integrate your own functions in the Formula Builder transformation library. BAdI: Customer-Defined Functions in the Formula Builder.

The transformation library provides the following functions in the following categories:

• Functions for character strings
• Date functions
• Basic functions
• Mathematical functions
• Other functions
• User-defined functions

If you use the formula builder in the variant maintenance screen of the process type Decision , you have additional functions at your disposal in the following category:

• Process chains

Note:

The formula for a Boolean target field must return a Boolean value. This means that the formula must either be an expression or the outermost function must return a Boolean value. The IF function in particular does not return a Boolean value. An error therefore occurs during the syntax check.

Functions for Character Strings:

• Concatenate (CONCATENATE)
• Use substrings only (SUBSTRING)
• Convert to uppercase (TOUPPER)
• Condense (CONDENSE)
• Condense without gaps (CONDENSE_NO_GAPS)
• First N characters (LEFT)
• Last N characters (RIGHT)
• Delete leading blanks (L_TRIM)
• Delete trailing blanks (R_TRIM)
• Replace (REPLACE)
• Shift left (SHIFT_LEFT)
• Shift right (SHIFT_RIGHT)
• Character string length (STR_LEN)

Date Functions:

• Add days to date (ADD_TO_DATE)
• Calculate fiscal period from calendar month (YYYYMM -> YYYYPPP)
• Date conversion (DATECONV)
• Date difference (DATE_DIFF)
• Calculate posting period from date (posting period)
• Calculate posting period from date (year + posting period)
• Calculate fiscal year from date
• Calculate half year from date (YYYYMMDD -> H)
• Calculate month from date (YYYYMMDD -> YYYYMM)
• Calculate month from date (YYYYMMDD -> MM)
• Calculate quarter from date (YYYYMMDD -> YYYYQ)
• Calculate quarter from date (YYYYMMDD -> Q)
• Convert date to calendar week (DATE_TO_WEEK)
• Calculate weekday from date
• Calculate weekday number from date (DATE_WEEKDAY1)
• Calculate calendar year from date (YYYYMMDD -> YYYY)
• Calculate calendar month from fiscal year (PPP -> YYYYMM)
• Calculate fiscal year from posting period
• Calculate last working day of month (LAST_WORKINGDAY_MONTH)
• Calculate last working day of year (LAST_WORKINGDAY_YEAR)
• Calculate half year from month (M or MM -> H)
• Calculate half year from month (YYYYMM -> H)
• Calculate quarter from month (M or MM -> Q)
• Calculate quarter from month (YYYYMM -> YYYYQ)
• Calculate quarter from month (YYYYMM -> Q)
• Calculate year from month (YYYYMM -> YYYY)
• Calculate half year from quarter (Q or YYYYQ --> H)
• Calculate half year from quarter (YYYYQ -> H)
• Calculate year from quarter (YYYYQ -> YYYY)
• Convert calendar week to first day of week (WEEK_TO_1ST_DAY)
• Calculate working day of current month from date (WORKINGDAY_MONTH)
• Calculate working day of current year from date (WORKINGDAY_YEAR)

Basic Functions

• If (IF)
• And (AND)
• Or (OR)
• Not (NOT)
• Less than (LT)
• Less than or equal to (LE)
• Not equal to (NE)
• Equal to (EQ)
• Greater than (GT)
• Greater than or equal to (GE)
• Raise to a power (POWER)

Mathematical Functions:

• Multiplication (MULTIPLY)
• Addition (PLUS)
• Subtraction (MINUS)
• Division (DIVIDE)
• Amount (ABS_VALUE)
• Cosine (COS)
• Sine (SIN)
• Tan (TAN)
• Arc cosinus (ARCCOS)
• Arc sinus (ARCSIN)
• Arc tangent (ARCTAN)
• Hyperbolic cosinus (COSH)
• Hyperbolic sinus (SINH)
• Hyperbolic tan (TANH)
• Quotient (DIV)
• Exponential function (EXPONENT)
• Decimal part (FRAC)
• Natural&

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A