Skip to Content

Customer exit to find next 12 months divided into 3 quarters

I need to write customer exit code for bex query . Requirement is report must take the current month by default and show the keyfigure value (max utlization) for next 3 months ( Q1) , next 3 months (Q2) , next 6 months (Q3).

For e.g IF this is April , then utization for 1 ) APril , may , June as Q1

utilization for 2) june , july , august as Q2

and remaining 6 months as Q3 .

Here utilization is formula with calculation in it .

i created calculated keyfigure with this and restricted it with calmonth each with offset range. but it is not working as expected. for ex. for Q1 - i set the offset from 0 - 3 , so that it takes next 3 months from today ( dec , jan , fec ) . But is is not calculating that way.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Dec 27, 2018 at 07:33 AM

    Hi Dinesh,

    Perhaps you may consider to use curremt member variable.

    See https://wiki.scn.sap.com/wiki/x/3AdSGQ

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04 at 12:48 PM

    Hi,

    Offset is the solution for your problem with Q1, Q2, and Q3. May I know the formula in your utilization key figure? Maybe it's the one giving error in the computation.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 at 04:19 PM

    Hi, you should be able to accomplish this by means of Time Offsets in Restricted Key Figures. In order for the offsets to work correctly you must use the 0CALMONTH infoobject (MM.YYYY), not the 0CALMONTH2 (MM) infobject (i.e. when you add 3 months to 11.2018 you get 02.2019).

    Good luck

    Add comment
    10|10000 characters needed characters exceeded