Select statement with where condition

[Former Member]

Hi all,

i dont want to fetch few records which will staisfy the ware condition.

instead of the below statement, any other method to fetch with high performance.

select * into itab from mara where matnr = itab1-matnr and

( matkl ne xyz or matkl ne abc or matkl ne 123 or matkl ne 789 )

[Former Member]

Hi,

Filter those values in internal table itab1 only.

example,

loop at itab1 where maktl = xyz and maktl = 123.

delete itab1.

endloop.

Regards,

Bhanu