cancel
Showing results for 
Search instead for 
Did you mean: 

variable for budget from starting to previous fiscal year?

Former Member
0 Kudos

Hi experts,

The requirement i got in my report to calculate Budget upto previous fiscal year.

For ex: If my project starts on Nov 2004 , then i want to calculate for the year Nov 2004 to Mar 2008.

I tried for variable Cumulate to last fiscal yeard

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member181964
Active Contributor
0 Kudos

Hi,

Use Customer Exit varaibles and do it..

Can you pls explain with example....clearly then you get good solution..

Thanks

Reddy

Former Member
0 Kudos

hi reddy,

In short i want to caluculate the cumulated figure for the budget starting of the year to last fiscal year or curent fiscal year,. If i write in customer exit how then ? can u please give me the standard variable if it s there

Thanks in Advace

vas

Edited by: vasu sapbw on Feb 26, 2009 12:36 PM

former_member181964
Active Contributor
0 Kudos

Hi,

Here I'm giving the code to get Months based on System date, so you change this code to as per your requirement.And if any use input variable is there then you need to use ....

LOOP AT i_t_var_range INTO loc_var_range WHERE vnam = 'ZVARAIBLE'.
 ENDLOOP.

Note: So by using this variables you need to restrict your Keyfigures with offset values.

* First Month Of Current Fiscal year comment*
    WHEN 'FMYEAR'.

      CALL FUNCTION 'DATE_TO_PERIOD_CONVERT'
             EXPORTING
               i_date               = sy-datum
*         I_MONMIT             = 00
               i_periv              = 'V3'
            IMPORTING
              e_buper              =  zbuper
              e_gjahr              =  zbdatj.

      CLEAR: l_s_range.

      l_s_range-low+4(2) = '04'.
      l_s_range-low+0(4) = zbdatj.
      l_s_range-sign = 'I'.
      l_s_range-opt = 'EQ'.
      APPEND l_s_range TO e_t_range.

* Last Month of Current Fiscal year*
    WHEN 'LMYEAR'.
      CALL FUNCTION 'DATE_TO_PERIOD_CONVERT'
             EXPORTING
               i_date               = sy-datum
*         I_MONMIT             = 00
               i_periv              = 'V3'
            IMPORTING
              e_buper              =  zbuper
              e_gjahr              =  zbdatj.

      CLEAR: l_s_range.

      l_s_range-low+4(2) = '03'.
      l_s_range-low+0(4) = zbdatj + 1.
      l_s_range-sign = 'I'.
      l_s_range-opt = 'EQ'.
      APPEND l_s_range TO e_t_range.

Thanks

Reddy