sql query

hi experts

i have this query:

date like ausp-atflv.

SELECT SINGLE ausp~atflv

FROM ausp

INTO date

WHERE ausp~objek = e_cekko-lifnr

AND ausp~atinn = 'TODG'

AND ausp~klart = '010'.

and it doesn't returns any result although i checked the query with the same parameters with se16 and there it returns one row as it supposed to be.

whats wrong here

thanks

Amit