topic Re: Select in Loop . in Application Development and Automation Discussions

Select in Loop .

SG141 — Mon, 25 Jun 2007 21:12:09 GMT

I have a internal table which contains material numbers. I need additional internal to hold material number and material description.

So is this a correct statement

loop at t_out.
select mtart from mara 
          into t_mara 
         where matnr = t_out-matnr.
endloop.

Re: Select in Loop .

Former Member — Mon, 25 Jun 2007 21:13:54 GMT

Hi Kartik,

Please Use Select Single Instead of Select Query

loop at t_out.
select single mtart from mara 
          into t_mara 
         where matnr = t_out-matnr.
endloop.

This will work more faster

Re: Select in Loop .

Former Member — Mon, 25 Jun 2007 21:16:10 GMT

You better do it like this...


DATA: W_TABIX TYPE SY-TABIX.
FIELD-SYMBOLS: <OUT> LIKE LINE OF T_OUT.

IF NOT T_OUT[] IS INITIAL.
SELECT MTART
INTO T_MTART
FROM MARA
FOR ALL ENTRIES IN T_OUT
WHERE MATNR EQ T_OUT-MATNR.

LOOP AT T_OUT ASSIGNING <OUT>.
W_TABIX = SY-TABIX.
READ TABLE T_MTART WITH KEY MATNR = <OUT>-MATNR.
IF SY-SUBRC EQ 0.
MOVE T_MTART-MTART TO <OUT>-MTART.
MODIFY T_OUT FROM <OUT> INDEX W_TABIX.
ENDIF.
ENDLOOP.
ENDIF.

Greetings,

Blag.

Re: Select in Loop .

Former Member — Mon, 25 Jun 2007 21:19:35 GMT

If you use select in loop, it may leads to performance issues, so it will be better if you use 'For all entries' .

Regards,

reward for all useful answers.

Re: Select in Loop .

SG141 — Mon, 25 Jun 2007 21:20:49 GMT

Getting a error Statement Not Accessible

Re: Select in Loop .

Former Member — Mon, 25 Jun 2007 21:31:36 GMT

better make your initial query with material desc also ie mtart. into ITAB1

select matnr mtart from mara into table ITAB1.

*copy Itab1 into itab2

itab2 = itab1.

I think performance wise this is good.

thanks

vinsee