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:
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.