Faster loop?

[Sandra_Rossi]

Hello,

is there a way to make a loop faster or to replace it by something faster? I know of 'for all entries' but what if the two fields aren't compatible?

SELECT rqposname RQIDENT
INTO TABLE t_output
FROM tsp01
WHERE rqposname EQ lv_email.

LOOP AT t_output ASSIGNING FIELD-SYMBOL(<fs2>).
SELECT SINGLE jobname progname variant listident
INTO ( <fs2>-jobname, <fs2>-progname, <fs2>-variant, <fs2>-listident )
FROM tbtcp
WHERE listident EQ <fs2>-rqident
AND listident NE '0'.
ENDLOOP.

This takes a few minutes even though there are "only" 1300 rows in t_output.

Any Tips?

Thanks in advance.

[Sandra_Rossi]

Did you try a join?

[Former Member]

Yes I did

but unfortunaly listident and rqident are not the same type.

[Sandra_Rossi]

Andrea Clöß it's worth converting it into an answer!

[Nawanandana]

Try to define your internal table as hashed table. try to do same, it will be fast

DATA IT_TAB TYPE HASHED TABLE OF scarr
WITH UNIQUE KEY carrid.

[Tomas_Buryanek]

SELECT inside LOOP is generally bad for performance! Always try to SELECT your data in one DB fetch if possible.

In this case I would suggest simple SELECT with JOIN of the two tables.

[Former Member]

Yes I did try that

but unfortunaly listident and rqident are not the same type.

[Tomas_Buryanek]

teaman I see, in this case you can either create a table for FOR ALL ENTRIES or range table. And you will have to retype the rqident to listident.

But now I see another and bigger problem - your both conditions (only the one you are using) are not index nor key fields:

• TBTCP-LISTIDENT
• TSP01-RQPOSNAME