topic Re: looping internal tables in Application Development and Automation Discussions

looping internal tables

Former Member — Thu, 24 Aug 2006 04:58:49 GMT

Hi all,

I have an internal table filled with data. I need to take up a single record at a time and compare with all the other records of the internal table. This I need to do for all the records of the internal table.

Please tell me the best way of doing this.

Thx..

Paul

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 05:02:06 GMT

Use READ statement..

-Mohan.

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 05:03:16 GMT

use

FOR All entries in ITAB1 into ITAB2.

Do not put a select query in a loop.

Re: looping internal tables

dani_mn — Thu, 24 Aug 2006 05:03:24 GMT

HI,

use

LOOP AT itab1.

 READ table itab2 with key field1 = itab1-field1 
                           field2 = itab1-field2.
                         

ENDLOOP.

LOOP AT itab1.

 LOOP AT itab2.
     if itab1-field1 = itab2-field1 AND 
        itab1-field2 = itab2-field2.

     endif.
 ENDLOOP.

ENDLOOP.

Regards,

HRA

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 05:04:05 GMT

i will give some sample code.

Loop at abc.

read table xys key xys-fieldname = abc-firlsname.

if sy-sybrc = 0.

do the comparision or any opration as requried.

endif.

read table lmn key lmn-fieldname = abc-firlsname.

if sy-sybrc = 0.

do the comparision or any opration as requried.

endif.

endloop

This will help

If it help you please don't forget to give ratting

with regards

Dhananjay

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 05:05:04 GMT

hi pradipta..

u can use READ statement.

Read table itab with key <>.

it will bring the record one by one to the work area.

Then u can process the record in this work area.

Naveen

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 05:05:18 GMT

Eg:

SELECT * FROM ebkn

INTO TABLE ITAB2

FOR ALL ENTRIES IN

ITAB2

WHERE (your condition).

Please reward if useful.

cheers,

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 05:06:45 GMT

Hi,

LOOP AT ITAB.

Do the comparison...

ENDLOOP.

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 05:06:51 GMT

Apologies!!

I misinterprited the question..

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 05:09:23 GMT

Hello,

You can either loop on internal table and do comparision. To simplify the code you can create a copy of your internal table

ITAB_COPY[] = ITAB_ORIGINAL[].

LOOP AT ITAB_ORIGINAL.

LOOP AT ITAB_COPY.

If you want to compare the whole row(all columns)

IF ITAB_COPY = ITAB_ORIGINAL.

Do what you want

ENDIF.

ENDLOOP.

If required you can use the

READ TABLE ITAB_ORIGINAL INDIX SY-TABIX.

TO remove duplicate rows:

SORT ITAB_ORIGIBAL.

Use...DELETE ADJACENT DUPLICATE ..COMPARING <FIELDS><fields>.

Hope it helps !!

Regards,

Vishal

Rewardif helpful

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 05:10:01 GMT

hi,

try doing this...

sort itab1.

loop at itab2.

read table itab1 with key field1 = itab2-field1 binary search.

itab2-fld1 = itab1-fdl1.

...

append itab2.

endloop.

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 07:13:24 GMT

LOOP AT ITAB1.
v_tabix = sy-tabix.
LOOP AT ITAB1.
 *--For each ITAB1 record you will be looping with all other records.
  if sy-tabix = v_tabix.
    continue.
*--this is the same record.no need to check this.
   endif.
write your code to compare & place to any other itab
ENDLOOP.
ENDLOOP.

Re: looping internal tables

Former Member — Thu, 24 Aug 2006 08:00:35 GMT

Hello

The best possible soln would depend on your detail requirement but as per the given details below can be one of the solutions.

--itab and itab1 have the same structure.

--your data is in itab.

itab1[] = itab[].

loop at itab.

clear itab1.

loop at itab1. {where condition}

--comparing the fields of itab with itab1.

endloop.

regards

Anurag