select statement

[Former Member]

Hi experts,

I have a select statement and it is taking lot of time.

How can i reduce it?

  select aufnr xloek kzear into corresponding fields of table
      t_det from resb for all entries in t_comp
                                 where aufnr = t_comp-aufnr.

[Former Member]

If RESB is large, since you aren't using an index, this SELECT will always take a long time.

Rob

[Former Member]

arrenge field in iternal table.....

select aufnr xloek kzear into table

t_det from resb for all entries in t_comp

where aufnr = t_comp-aufnr.

Message was edited by: kishan negi

[abdul_hakim]

Hi Kaki,

use my below code..

data: begin of wa,

aufnr like resb-aufnr,

xloek like resb-xloek,

kzear like resb-kzear,

end of wa.

data itab like table of wa.

if not t_comp is initial.

select aufnr xloek kzear from resb into table itab for all entries in t_comp where aufnr = t_comp-aufnr.

endif.

Regards,

Abdul Hakim

[Former Member]

Hi Kaki,

i hope t_det has only 3 fields, that are aufnr,xloek,kzear in the same order of select.

if not t_comp[] is initial.
  select aufnr
         xloek
         kzear 
   into  table t_det 
    from resb for all entries in t_comp    
   where aufnr = t_comp-aufnr.
endif.

regards

vijay

[Former Member]

Thanks for all the replies.

points alloted

cheers

kaki

[Former Member]

If RESB is large, since you aren't using an index, this SELECT will always take a long time.

Rob