Skip to Content
0
Former Member
Mar 18, 2009 at 08:47 AM

selection of data.

14 Views

hI Experts,

I have one doubt. I m making modulepool prg.

I have 2 text box for date to get difference between 2 dates and In database table i have TDATE (DATS) field which stored dates in format DD.MM.YYYY.

My internal table structure is:

SYEAR

SMONTH

PERNR

APF

VPF

EPF

TDATE

The text box name is FDATE AND EDATE and declared it in D datatype in report.

and i m using following statement to get record of between date.

SELECT SYEAR SMONTH PERNR APF VPF EPF TDATE FROM ZUPWORKER INTO(BODY1-SYEAR,BODY1-SMONTH,BODY1-BPERNR,BODY1-APF,BODY1-VPF,BODY1-EPF,BODY1-TDATE)

WHERE TDATE BETWEEN FDATE AND EDATE

AND PERNR = SMF1-PERNR

ORDER BY SYEAR SMONTH ASCENDING .

The error is Fdate is Unknown.

Regards,

Swapnika