SAP ABAP Data Element RSAN_FOBU_FUNCTIONS (Formula Editor Functions)
Hierarchy
☛
SAP_BW (Software Component) SAP Business Warehouse
⤷
BW-EI-APD (Application Component) Analysis Process Designer
⤷
RSAN_WB (Package) APD - Tool - User Interface

⤷

⤷

Basic Data
Data Element | RSAN_FOBU_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.
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
Functions for Character Strings
- Concatenate (CONCATENATE)
- Use Substrings Only (SUBSTRING)
- Convert to Uppercase (TOUPPER)
- Condense (CONDENSE)
- Summarize without Spaces (CONDENSE_NO_GAPS)
- First N Chars (LEFT)
- Last N Chars (RIGHT)
- Delete Leading Blanks (L_TRIM)
- Delete Trailing Blanks (R_TRIM)
- Replace (REPLACE)
- Move Left (SHIFT_LEFT)
- Move 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 Booking Period
- Calculate Last Work Day for Month (LAST_WORKINGDAY_MONTH)
- Calculate Last Work Day for 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 Days of Current Month from Date (WORKINGDAY_MONTH)
- Calculate Working Days 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)
- Equals (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 Cosine (ARCCOS)
- Arc Sine (ARCSIN)
- Arc Tangent (ARCTAN)
- Hyperbole Cosine (COSH)
- Hyperbole Sinus (SINH)
- Hyperbole Tan (TANH)
- Quotient (DIV)
- Exponential Function (EXPONENT)
- Decimal Part (FRAC)
- Natural Logarithm (LOG_E)
- Logarithm to Basis 10 (LOG_10)
- Remaining (MOD)
- Sign (SIGN)
- Root (SQUARE_ROOT)
- Integer Part (TRUNC)
Other Functions:
- Check for Initial Value (IS_INITIAL)
History
Last changed by/on SAP 20130604 SAP Release Created in 700