topic Re: looping time.. in Application Development and Automation Discussions

looping time..

Former Member — Wed, 10 Jan 2007 02:21:47 GMT

DATA : BEGIN OF ITAB2 OCCURS 0,

KEY(10),

END OF ITAB2.

There are about 8000 lines in the ITAB2

LOOP AT ITAB2.

SELECT name FROM EMP

APPENDING TABLE IT100

WHERE KEY = ITAB2-KEY

ENDLOOP.

so this loop program is processing for a long time.

Could you show how to query at once?

Message was edited by:

jake

suresh_datti — Wed, 10 Jan 2007 02:25:20 GMT

Use the following code..

if not itab2[] is initial.

select name from emp into table it100

for all entries in itab2

where key = tab2-key.

endif.

~Suresh

raja_thangamani — Wed, 10 Jan 2007 02:38:41 GMT

Use FOR ALL ENTRIES as follows:

SELECT name FROM EMP
   TABLE IT100
     FOR ALL ENTRIES IN itab2 
          WHERE KEY = ITAB2-KEY.

Raja T

Message was edited by:

Raja Thangamani

Former Member — Wed, 10 Jan 2007 02:47:48 GMT

CHECK NOT ITAB2[] IS INITIAL.

SELECT NAME

FROM EMP

INTO TABLE IT100

FOR ALL ENTRIES IN ITAB2

WHERE KEY EQ ITAB2-KEY.

Thanks,

Santosh