Hello everyone,**
*I have a function module where ,at end of current quarter, i need to fetch data of last 3 quarters including current quarter .*
eg:
I/P :QTR 1 YEAR 2010
O/P
QTR VALUE
Q12010 ITAB DATA
Q22009 ITAB DATA
Q32009 ITAB DATA
Q42009 ITAB DATA
I/P :QTR 2 YEAR 2010
O/P
QTR VALUE
Q22010 ITAB DATA
Q12010 ITAB DATA
Q32009 ITAB DATA
Q42009 ITAB DATA
I/P :QTR 3 YEAR 2010
O/P
QTR VALUE
Q32010 ITAB DATA
Q22010 ITAB DATA
Q12010 ITAB DATA
Q42009 ITAB DATA
I/P :QTR 4 YEAR 2010
O/P
QTR VALUE
Q42010 ITAB DATA
Q32010 ITAB DATA
Q22010 ITAB DATA
Q12010 ITAB DATA
but getting only 2010(eg) all 4 quarters data for all the input options.
how to write a select query for getting the result as shown above?
In my DB table year and quarter fields are separate.
Bluesky
