Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue with SELECT statement

Hi All,

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.

Thanks

Suresh

Tags:
replied

>

> when populating the r_rcomp, assign the sign as 'NE' ( Not equal to )

I don't think that will work. The option should be 'EQ' and the sign 'E' (exclude).

Rob

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question