Skip to Content
0
Former Member
Apr 08, 2008 at 12:05 PM

help needed on performance improvement avoiding nested loops

194 Views

Hi Everybody,

Is there any thing similar to "for all entries" for internal tables to fetch multiple records

from an internal table at a time based on certain selection criteria.

We can read only record using "read" statement right. I want to read multiple records

from an internal table at a time without using loop.

I have three internal tables itab1, itab2, itab3. Based on a field value in itab1, I have to fetch

multiple records from itab2 into itab3. itab2 and itab3 are of same line type.

itab1

-


machine | function name

-


123 | FM1

456 | FM1

789 | FM2

itab2

-


machine | m/c description | start time | stop time |.....|.....|...

-


123 | mach1 | 07:00 | 08:00

123 | mach1 | 08:00 | 09:00

123 | mach2 | 06:00 | 08:00

456 | mach2 | 24:00 | 08:00

456 | mach2 | 07:00 | 12:00

789 | mach3 | 04:00 | 09:00

When I loop over itab1, and get first record, I want to get all records from itab2 corresponding to the machine number in the itab1 at a time into itab3 without using loop.

Thanks,

Sunny