Variable to sum 13 - 16 fiscal periods

[Former Member]

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

[Former Member]

Hi Kiran,

Change your code and check it

*{ 0002

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

if lv_perval = '000'.

lv_perval = '012'. <b>(Make this as '016')</b>

lv_year = lv_year - 1.

endif.

Make the change in like "lv_perval = '016' "

and try

regards,

PM

[Former Member]

I didnt exactly get ur question. But the 4 special periods do pick up the balances in the opening balance of the next year. You need not have to do any exit to calculate the balance. As these 4 special periods are part of 12th posting period.