Useful class for coding of BW routines in Transformations

Recently I came across a coding in ABAP rule in transformation where simple method from class CL_RSAR_FUNCTION was used. It was method fiscper_calmonth. This simple method derives calendar month (0CALMONTH) as per given fiscal period (0FISCPER).

I had a look into other methods in same class and I found it very interesting. Method contains 55 methods in total in release BW 7.3 SP08. Some of them are very useful. Basic calendar and string function are there. For overview I’m providing full list of methods below. I’m sure I’ll use this class in my next BW developments.

ABORT_PACKAGE Function: Abort Package

ADD_TO_DATE Function: Add Days to Date

CALMONTH_FISCPER Function: Calendar Month ->Fiscal Period

CONDENSE Function: Condense

CONDENSE_NO_GAPS Function: Condense No Gaps

DATECONV Function: Date Conversion

DATE_DIFF Function: Date Difference

DATE_FISCPER Function: Date -> Fiscal Period

DATE_FISCPER3 Function: Date -> Fiscal Period 3

DATE_FISCYEAR Function: Date -> Fiscal Year

DATE_HALFYEAR Function: Date -> Half-Year

DATE_MONTH Function: Date -> Month

DATE_MONTH2 Function: Date -> Month 2

DATE_QUARTER Function: Date -> Quarter

DATE_QUARTER1 Function: Date -> Quarter1

DATE_WEEK Date Conversion in Calendar Week

DATE_WEEKDAY Function: Date -> Weekday (Textual)

DATE_WEEKDAY1 Function: Date -> Weekday (Technical)

DATE_YEAR Function: Date -> Calendar Year

FIRST_WORKINGDAY_MONTH Calculation of First Working Day in Month

FIRST_WORKINGDAY_YEAR Calculation of First Working Day in Month

FISCPER_CALMONTH Function: Fiscal Period -> Calendar Month

FISCPER_FISCYEAR Function: Fiscal Period -> Fiscal Year

IF Function: IF Statement

IS_INITIAL Function: Is Initial

LAST_WORKINGDAY_MONTH Calculation of Last Working Day in Month

LAST_WORKINGDAY_YEAR Calculation of Last Working Day in Year

LEFT Function: Left

L_TRIM Function: Left Trim

MAPPING Function: Field Mapping Transfer Structure

MONTH2_HALFYEAR Function: Month 2 -> Half-Year

MONTH2_QUARTER1 Function: Month 2-> Quarter1

MONTH_HALFYEAR Function: Month -> Half-Year

MONTH_QUARTER Function: Month -> Quarter

MONTH_QUARTER1 Function: Month -> Quarter1

MONTH_YEAR Function: Month -> Calendar Year

NEGATIVE Function: Reverse +/- Sign

QUARTER1_HALFYEAR Function: Quarter 1-> Half-Year

QUARTER_HALFYEAR Function: Quarter -> Half-Year

QUARTER_YEAR Function: Quarter -> Calendar Year

REPLACE_ALL Function: Replace All

REPLACE_FIRST Function: Replace First

RIGHT Function: Right

R_TRIM Function: Right Trim

SHIFT_LEFT Function: Shift Left

SHIFT_RIGHT Function: Shift Right

SKIP_RECORD Function: Skip Record

SKIP_RECORD_AS_ERROR Function: Skip Record (With Error Message in Monitor)

STR_LEN Function: strlen

UNIT_CONVERSION Function: Unit Conversion

WEEK_FIRST_DAY Calendar Week Conversion in First Day of Week Date

WORKINGDAY_MONTH Function: Date -> Working Day of Corresponding Month

WORKINGDAY_YEAR Function: Date -> Working Day of Corresponding Year

AMOUNT_DAYS_OF_MONTH Number of Days in Month

GREATER_OF_TWO_MONTH Which of 2 Months Has More Days Within Period