topic regarding internal table loops in Application Development and Automation Discussions

regarding internal table loops

Former Member — Fri, 26 Jan 2007 19:40:18 GMT

hi gurus,

i have a situation, i need to filter records by adding on the where conditon in a internal table itab1 as i go down the program .

here is a sample,

read table itab1 with key col1 = '123'

col2 = 'abc'.

while sy-subrc = 0.

append itab1 to itab2.

sort itab2 by col1 col2 col3.

read table itab1 with key col1 = '123'

col2 = 'abc'.

endwhile.

in the next step i want to use the same logic but one more variable in where conditon.. <b>col3 = 'xyz'</b>, but here, i am going in to infinite while loop selecting same record ...how do i overcome that?

when i come to next step i want to select form itab2 and now what is situation of itab1 outside the loop? is it empty , can i use it to select from itab2 or should i declare itab3 ?

plz help me...i am not a abap guy..so kindaa stuck at this simple situation....

Message was edited by:

ravi a

Re: regarding internal table loops

Former Member — Fri, 26 Jan 2007 19:48:21 GMT

Below code moves data from itab to itab2 provided both have the same structure with same field names.

loop at itab where col1 = '123' and col2 = 'abc'.

move corresponding fields of itab1 to itab2.

append itab2.

clear itab2.

endloop.

Is this what you are looking for?

Thanks,

Santosh

Re: regarding internal table loops

Former Member — Fri, 26 Jan 2007 19:50:50 GMT

Hi ravi,

Could you please give some details of the situation you are handelling?

You can give contents of table or there might be other good ways to handle this.

From your explaination its purpose is not much clear.

Thanks,

ags..

Re: regarding internal table loops

Former Member — Fri, 26 Jan 2007 19:58:01 GMT

Are you trying to do something like:



DATA new_index LIKE sy-tabix.

READ TABLE itab1 WITH KEY col1 = '123'.
col2 = 'abc'.
new_index = sy-tabix.
WHILE sy-subrc = 0.
  APPEND itab1 TO itab2.
  new_index = new_index + 1.
  READ TABLE itab1 INDEX new_index.
  col2 = 'abc'.
ENDWHILE.
SORT itab2 BY col1 col2 col3.

Rob

Re: regarding internal table loops

Former Member — Fri, 26 Jan 2007 20:49:46 GMT

An alternative solution may be as given below:

Given itab1 is already declared. Also the selection from itab1 based on col1 and col2 is using fixed values like.'123' etc.


Data: itab2 like itab1,
         itab3 like itab1.

* copy itab1 into the other table
  itab2 = itab1.

* delete the irrelevant rows from itab2 based on the where clause
  delete itab2 where col1 ne '123' and col2 ne 'ABC'.

* copy itab2 into the other table
  itab3 = itab2.

* delete the irrelevant rows from itab3 based on the where clause
  delete itab3 where col1 ne '123' and col2 ne 'ABC' and col3 ne 'XYZ'.

After this, itab2 will have records that match with value in col1 and col2 as '123' and 'ABC' respectively.

itab3 will have records that match with value in col1, col2 and col3 as '123', 'ABC' and 'XYZ' respectively. Also it will have only those records which were also selected in itab2 as it was a copy of itab2.

Hope this helps.

Thanks

Sanjeev

Re: regarding internal table loops

Former Member — Fri, 26 Jan 2007 21:17:26 GMT

Hi,

Its better to have one more internal table with the final result you want:

Try this:

loop at itab1 where col1 = '123' and col2 = 'abc'.

loop at itab2 where col1 = itab1-col1

and col2 = itab1-col2

and col3 = 'xyz'.

move-corresponding itab1 to itab3.

move-corresponding itab2 to itab3.

append itab3.

endloop.

Regards

Subramanian

Re: regarding internal table loops

Former Member — Mon, 29 Jan 2007 03:30:53 GMT

Thanks a lot guys for all the helpful and fast answers.

Re: regarding internal table loops

Former Member — Mon, 29 Jan 2007 04:12:07 GMT

Hi,

the obvious answer is it goes into infinite loop. why? the logic u wrote for the read table id always true. and the read table written inside the while condition will not effect the SY-SUBRC for the while condition. what is the logic u actually want to write.

regards,

Aravind