I have the following requirment for one of the report i am preparing in Bex query.
The user will input fiscal period (Interval) through selection screen and the report will run for that period which is fine.
But there is another requirement that all the months related that period should be shown in the report. Ineed help on this.
If user enter Fiscal period as 008.2011 to 008.2012.
Then the on of the field of the of report should show--
August 2011 or 008.2011
September 2011 or 009.2011
October 2011 or 010.2011
Novemebr 2011 or 011.2011
December 2011 or 012.2011
January 2012 or 001.2012
February 2012 or 002.2012 and so on.
I'll really appreciate the help and would like to know the step by step process to achieve this.