topic Select statement with where condition in Application Development and Automation Discussions

Select statement with where condition

Former Member — Sat, 19 Apr 2008 08:42:47 GMT

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 — Sat, 19 Apr 2008 09:28:14 GMT

Hi,

Filter those values in internal table itab1 only.

example,

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

delete itab1.

endloop.

Regards,

Bhanu