topic Re: SELECT, NOT IN ? in Application Development and Automation Discussions

SELECT, NOT IN ?

Former Member — Fri, 13 Jun 2008 08:06:30 GMT

Hi,

is it OK to use NOT IN within SELECT statement?


data: lt_mara type STANDARD TABLE OF mara,
      wa_mara type mara.

select * from mara INTO TABLE lt_mara
         where matnr NOT IN ('F000018000', 'F000018100')
          AND mtart = 'FOLD'.

  loop AT lt_mara into wa_mara.
    write:/ wa_mara-matnr.
  endloop.

tnx, Adibo.

Re: SELECT, NOT IN ?

ThomasZloch — Fri, 13 Jun 2008 08:09:01 GMT

syntactically OK, but this will be a slow select since all records must be scanned to get the result.

Thomas

Re: SELECT, NOT IN ?

Former Member — Fri, 13 Jun 2008 08:09:08 GMT

U can use .. better if U put them in a range with sign = 'E'.

and use IN ...

select * from mara INTO TABLE lt_mara

where matnr IN r_matnr

AND mtart = 'FOLD'.

Re: SELECT, NOT IN ?

Former Member — Fri, 13 Jun 2008 08:09:26 GMT

HI,

Don't use negetive where class in select statements, instead delete those particular records after fetching the data from table using select.

Rgds,

Bujji

Re: SELECT, NOT IN ?

Former Member — Fri, 13 Jun 2008 08:17:45 GMT

data: lt_mara type STANDARD TABLE OF mara,

wa_mara type mara.

select-options:s_matnr for mara-matnr.

ranges : r_ranges for mara-matnr .

r_matnr-low = 'F000018000'.

r_matnr-sign = 'E'.

r_matnr-options = EQ'.

append r_matnr.

r_matnr-low = 'F000018100'.

r_matnr-sign = 'E'.

r_matnr-options = EQ'.

append r_matnr.

loop at s_matnr.

r_matnr-low = s_matnr-low.

r_matnr-sign = 'E'.

r_matnr-options = EQ'.

append r_matnr.

endloop.

select * from mara INTO TABLE lt_mara

where matnr in r_matnr

AND mtart = 'FOLD'.

loop AT lt_mara into wa_mara.

write:/ wa_mara-matnr.

endloop.

Re: SELECT, NOT IN ?

Former Member — Fri, 13 Jun 2008 08:19:08 GMT

Hi, tnx

So it's better to use range with sign E and IN.

Re: SELECT, NOT IN ?

Former Member — Fri, 13 Jun 2008 08:22:01 GMT

Hi,

Would be good if reward points are given to the helpful answers.

This would encourage ppl to answer more proactively!!

Regards,

Lalit