Hi Friends, I have 1 problem here
I m prescribing my coding and logic as following:
DATA: KYEAR(4) TYPE C,
NYEAR(4) TYPE C,
KYEAR = SY-DATUM+0(4),
NYEAR = SYEAR - 1 .
IF SYEAR EQ KYEAR AND SMONTH < 4.
SELECT APERNR ASMONTH ASYEAR AAPF AVPF AEPF
BTMONTH BTYEAR BEMPLOYEEPF BEMPLOYERPF
FROM ( ZUPWARDHAWOR AS A INNER JOIN ZTRANS_ENTRY AS B
ON APERNR = BPERNR )
INTO CORRESPONDING FIELDS OF BODY1
WHERE A~SYEAR BETWEEN NYEAR AND SYEAR
AND A~SMONTH BETWEEN '04' AND SMONTH
AND A~PERNR = SMF1-PERNR AND
B~PERNR = SMF1-PERNR "AND
BTMONTH = ASMONTH AND
BTYEAR = ASYEAR
ORDER BY ASYEAR ASMONTH ASCENDING .
APPEND BODY1.
COUNT = COUNT + 1.
ENDSELECT.
Month name is SMONTH year is SYEAR.
I need when i put JAN 2009 OR Feb 2009 the data should be select from APRIL 2008 to Jan 2009 or Feb 2009.
But according to my logic the data is selecting when i hide month from WHERE condition.
It is selected data from jan2008 to jan 2009. But i want Aprill 2008 to till current month and year.
Plz try to solve it soon.
Regards,
Swapnika