Skip to Content
0
Former Member
Jun 03, 2008 at 02:07 PM

Need to use NOT IN in Select stmt

19 Views

Hi all,

This is the stmt that i need. But its not working fine.

SELECT aufnr

auart

FROM aufk

INTO TABLE t_aufk

WHERE auart IN r_auart

AND ERDAT NOT IN S_DATE "Not working

AND AEDAT NOT IN S_DATE. "Not working

Could we use NOT IN in select stmt...

Or is there any other option...

Regards,

Vijay.