Skip to Content
0
Former Member
Apr 01, 2008 at 06:13 PM

SELECT QUERY

12 Views

i am doing an select like this

FROM bsak

INTO TABLE t_cleared

FOR ALL ENTRIES IN t_data1

WHERE lifnr = t_data1-lifnr

AND bukrs IN s_bukrs

AND augdt GT p_kdate

AND belnr NE bsik-augbl

AND budat LE p_kdate

AND bschl = 31.

AND hkont IN s_hkont.

now the problem is that the table t_data1 has got no records for this particular case and moreover for the particular s_hkont and bukrs combination there are no records in the table but still this select is fetching all the records

wat is wrong here?