topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Fri, 10 Feb 2006 07:32:32 GMT

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.

Re: select statement

Former Member — Fri, 10 Feb 2006 07:34:26 GMT

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

Re: select statement

abdul_hakim — Fri, 10 Feb 2006 07:38:02 GMT

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

Re: select statement

Former Member — Fri, 10 Feb 2006 07:39:47 GMT

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

Re: select statement

Former Member — Fri, 10 Feb 2006 07:49:14 GMT

Thanks for all the replies.

points alloted

cheers

kaki

Re: select statement

Former Member — Fri, 10 Feb 2006 14:40:36 GMT

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

Rob