How to derive Quarter Values in Bex

Hey Ravi,

If your company's calendar and fiscal calendar are same. You can always calculate Quarters based on fiscal period(which will be similar to your calmonth and calquater ).

I would suggest you go with creating a routine at your cube/ADSO level for Quarter calculation, rather than trying to do it at Bex.

If you are willing to do that Bex, Virtual Char is an option i can think of, but that will be bit expensive in terms of query performance for bigger result set.

we have created a custom infoobject liek 0fiscper and laoded hierarchies manually from 001.2016 to 012.2027 and its quarters. . now we are getting quarters.and support teams have to perform year end activity to update quarters values for newyear after december 2027. in jan 2028 first week they can maintain using rsa1 or rsh1 for custom object.

also we can create a custom infoobject zquarter type char and length 7 , alpha conversion.

write a field routine by mapping 0fiscper to zquarter.

code :

DATA : LV_PER1 TYPE N.

DATA : LV_YEAR1 TYPE bdatj.

** target field: ZQUARTER

*$*$ begin of routine - insert your code only below this line *-* * Note the _M class are not considered for DTP execution.

* Breakpoints must be set in the _A class instead.

"insert your code here

LV_PER1 = SOURCE_FIELDS-FISCPER+4(3).

lv_year1 = SOURCE_FIELDS-FISCPER(4).

CASE LV_PER1.

WHEN '001' OR '002' OR '003'.

CONCATENATE 'Q1.' LV_YEAR1 INTO RESULT.

WHEN '004' OR '005' OR '006'. CONCATENATE 'Q2.

' LV_YEAR1 INTO RESULT.

WHEN '007' OR '008' OR '009'.

CONCATENATE 'Q3.' LV_YEAR1 INTO RESULT.

WHEN '010' OR '011' OR '012'.

CONCATENATE 'Q4.'

LV_YEAR1 INTO RESULT.

ENDCASE.