how can i display currnet month and same month in last year data in bex report

[Former Member]

hi experts

i have time char (jc month ) which is similar to the fiscal year month ...every fiscal year has got 13 jc months ...

fiscal year starts from apri01 t0 marc 31

001.2011,002.2011..............upto...013.2011 are jc months in fiyear 2011.

now i want to show sales data for current year and last year(only for tat particular jc month)

example

variable screen should have option to choose jc month

like jc month =001.2011

o/p

sale for 001.2011             sales for 001.2010....

1000INR                                      2000INR

my approach

i have tried by using char vari on  jc month and used offset option...

ex:

char vari-cust i/p on jc month (001.2011)and restricted wit -013

insted of showing 001.2011 and 001.2010 values

it is fetching          001.2011        989.2010

its considering 000.2011,999.2010 values 

can any one pls tell me way to creat this report and over come this issue ???

thanks in advance ...

Hari

[yogesh8984 · Accepted solution]

Hello,

You can use User Exit variable in I Step 2. You can read the value of period being put into selection screen and then change it to last year in user exit logic.

This should work.

Regards,

Yogesh

[Former Member · Accepted solution]

thank you so much yogesh ...

can you help me with SAMPLE  code ...i am not familiar  with ABAP.

regards,

Harry

[Former Member]

SAP BI EXPERTS PLS HELP ME BY GIVING YOUR INPUTS ....PLS

Thanks and regards,

Harry