Fiscal Year Period User Choice to Restrict the Balance wrt to version

[Former Member]

Hello friend, I have a Budget Balance key fiegure. which has values for a period say 001.2007 4 Values . sum equal = 13035

Now I want to Create a Current Period Balance in Report and YTD Balance in Report

For Current Period I did this as below but it is not working

<b>

Restricted Key Figure Budget Current period</b>

Budget Balance key fiegure

Restrict with Value Type for Budget Data = 90

Restrict with Fiscal Yr/ Period User Enter Variable say user enter 006.2007

Restrict with Version Type for Budget Data = User Choice say user enter 20

I am still not getting the correct Current Period balance in rep it always take january 2007 balance.

Now same for YTD

Restricted Key Figure Budget Current period</b>

Budget Balance key fiegure

Restrict with Value Type for Budget Data = 90

Restrict with Offset Range January Customer Exit Variable -- Fiscal Yr/ Period User Enter Variable say user enter 006.2007 so it will be 001.2007 --006.2007

Restrict with Version Type for Budget Data = User Choice say user enter 20

I am still not getting the correct YTD Period balance in rep it always take January 2007 balance.

Please help me with the logic to work this CURRENT PERIOD BALANCE AND YTD

iF You have any code you can send me at soniyakv@hotmail.com

Thanks

Soniya

[Former Member · Accepted solution]

did you check the LISTCUBE with the same selections to see if the period balance turns out to be correct. As far as I see the RKF, it looks good and should work. Please check the data in the cube to validate the numbers, and if they tie, we can look into the query.

[Former Member · Accepted solution]

Data in the Cube perfectly ties and balances are correct. Please tell why YTD and QTD always only pull the Current period balance like if user put 006.2007 Balance will be same for all YTD and QTD

[Former Member · Accepted solution]

If the numbers show perfect in cube, I think you need to look at the variable you are using? whats the variable you are using? is it a SAP exit or you created it?

[Former Member · Accepted solution]

Hi Friends I have this YRD Customer Exit Variable with the Range option

and Code is as below. Can u tell why this is always showing the current period balance instead of YTD

WHEN 'ZVR_YTDBUD'.

if i_step = 2 or i_step = 3.

clear loc_var_range.

loop at i_t_var_range into loc_var_range.

if loc_var_range-VNAM = 'ZVMFISCPER'.

if sy-subrc = 0.

YTD_YEAR = loc_var_range-low(4).

YTD_YEARH = loc_var_range-low(7).

concatenate YTD_YEAR '001' into YTD_CURRENTYEAR.

CLEAR L_S_RANGE.

L_S_RANGE-LOW = YTD_CURRENTYEAR.

L_S_RANGE-HIGH = YTD_YEARH.

L_S_RANGE-SIGN = 'I'.

L_S_RANGE-OPT = 'EQ'.

append l_s_range to e_t_range.

exit.

endif.

endif.

endloop.

endif.

[Former Member · Accepted solution]

I am just pasting my answer to your other post...

but is your RKF restricted to both variables?

Hi,

you can remove the OR I_STEP = 3, doesn't do anything....

. make sure that 'ZVR_YTDBUD' is an interval var, <b>NOT</b> ready for input

. make sure that 'ZVMFISCPER' is mandatory

. I guess that you have filetered FISCPER with both variables thus it will be filtered with the signle value of 'ZVMFISCPER'; if this is the case, try the following:

Include a restricted key figure in your report filtered on 'ZVMFISCPER'; hide it

Remove 'ZVMFISCPER' from the 0FISCPER filter of your other RKF in order to keep only the 'ZVR_YTDBUD'.

Otherwise the code looks good except that we don't see how YTD_CURRENTYEAR and YTD_YEARH are declared...

hope this helps...

Olivier.

Message was edited by:

Olivier Cora