Skip to Content
0
Former Member
Jun 29, 2009 at 11:20 AM

Variable Range not working in BPS-Layout.

58 Views

Hi BI Guru's,

I am facing Problem in BPS - Layout. My requirement is to get YTD Budget Quantity in Single Coulumn. For Example, I need Quantiy for the Period 001.2009 to 12.2009 in single Column as Budget YTD 2009.

For this I defined a variable on the Planning area, with the characteristics "fiscper" and in the selection condition i entered the range 001.2009 to 012.2009, but when i executed the layout it is showing the quantity for the perios 001.2009 only and not for the entire range.

I tried with the User Exit also, where i copied the standard function module "UPF_VARIABLE_USER_EXIT" to 'Z' function and modified to my requirement. Following is my Code for the Function Module

 clear eto_charsel.
 
data ls_charsel type upc_ys_charsel.

 clear ls_charsel.

  i_area = 'ZUCOPA'.
  I_CHANM = 'FISCPER'.
  i_variable = 'ZACTDYTD1'.
  ls_charsel-chanm = i_chanm.
  ls_charsel-seqno = '1'.
  ls_charsel-sign  = 'I'.
  ls_charsel-opt   = 'BT'.
  ls_charsel-low   =  '2009001'.
  ls_charsel-HIGH   = '2009012'.

  insert ls_charsel into table eto_charsel. 

But the after using the Function Module in the User Exit area of Variable also, I am getting the Quantity for the Period 001.2009 only and not for the entire range ( 001.2009 to 012.2009 ).

Please suggest some solution ASAP.

Thanks in advance.

Regards,

VD.