Skip to Content
0
Former Member
Mar 06, 2009 at 05:43 AM

data selection

45 Views

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