Issue with SELECT statement
I have an issue with SELECT statement. In select statement though i am excluding some values which are in range table, those values are also getting selected.
I am using select statement like this.
select fielda fieldb fieldc... fieldn from table zzallt into corresponding fields of t_zzallt where saknr in s_saknr
and rcomp not in r_rcomp.
where s_saknr is select options and r_rcomp is range table. I should not select saknr values which are in r_rcomp, but are being selected. Please tell me where I am wrong.