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.