Skip to Content
12
Former Member
Jul 09, 2007 at 03:46 PM

Variable to sum 13 - 16 fiscal periods

136 Views

Experts,

We have a BW report which shows opening balance for the previous year, say for ex : If user enter 001.2007 to 003.2007 then BW report opening balance will display for a GL account from 001.2006 to 012.2006. But when user post some data for the period 13.2006 , then this period value is not appearing under opening balance in the BW report when they choose from 001.2007 to 003.2007. How can I pick up value in in the period 13.2006.

Is there any settings in the config side or Do I have to amend CMOD code whcih sum up previous fiscal year periods.

WHEN 'ZCUMRMAP' . "Periods 1-(n-1) based on from value of 0I_FYPER

CLEAR l_s_range.

loop at i_t_var_range into l_s_var_range where vnam = '0I_FYPER'.

endloop.

lv_per_value = l_s_var_range-low.

lv_year = lv_per_value(4) .

lv_perval = lv_per_value+4(3).

lv_perval = lv_perval - 1.

*{ 0002

  • if month is 000 then change to 12 and then year to pervious year

if lv_perval = '000'.

lv_perval = '012'.

lv_year = lv_year - 1.

endif.

lv_period = lv_perval .

move 'I' to l_s_range-sign.

move 'BT' to l_s_range-opt.

  • concatenate lv_year '000' into l_s_range-low . " 0002 exclude

  • concatenate '2005' '012' into l_s_range-low . " 0002 include

  • Period 2005.12 is used as the start point of data collection

  • based on the BW Live system data available in 0FIGL_O02 ODS

  • Read min period from the ODS Table

DATA: min_period like /bi0/afigl_o0200-fiscper.

select single MIN( FISCPER ) into min_period

from /bi0/afigl_o0200.

move min_period to l_s_range-low . " 0002 include

  • } 0002

concatenate lv_year lv_period into l_s_range-high.

  • { 0002

if l_s_range-high < min_period.

l_s_range-high = min_period.

endif.

  • } 0002

append l_s_range to e_t_range.

I appreciate for u r advice.

Many thanks