SELECT, NOT IN ?

[Former Member]

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.

[Former Member]

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.

[ThomasZloch]

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

Thomas

[Former Member]

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'.

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi, tnx

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

[Former Member]

Hi,

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

This would encourage ppl to answer more proactively!!

Regards,

Lalit