topic Re: nedd help in Application Development and Automation Discussions

nedd help

Former Member — Wed, 25 Jul 2007 19:23:18 GMT

I am using 3 internal tables. First I am fetching the data from itab1 , by using itab1 again I am fetching data into itab2.

I am declaring the itab3 fields whose are contains in both itab1 and itab2. I am populating the data into itab3 by using itab1 and iatb2.

loop at iatb2.

read table itab1 with key …key all fileds…

itab3-filed1= itab1-filed1.

itab3-filed2= itab2-filed2.

endloop.

But it is taking lot of time. Please advice any peformence technique.

regards,

Ajay reddy

Re: nedd help

Former Member — Wed, 25 Jul 2007 19:26:03 GMT

hi Ajay,

do this way

loop at iatb1.
read table itab2 with key …Include all the key fields…
 if sy-subrc = 0. 
  itab3-filed1= itab1-filed1.
  itab3-filed2= itab2-filed2.
  append itab3.
  clear itab3.
 endif.
endloop.

Re: nedd help

Former Member — Wed, 25 Jul 2007 19:36:35 GMT

Hi Santhosh,

if i use the same code suggested by you. in debuging mode. time is expired .

if i populate large amount , i am getting the same.

please adivice any .

regards,Ajay reddy

Re: nedd help

Former Member — Wed, 25 Jul 2007 19:39:29 GMT

hi,

sort the internal tables with the key fields and use

binary search

statment in the read table statement ...


sort itab1 by <key fields>.
sort itab2 by <key fields>.
loop at iatb1.
read table itab2 with key …Include all the key fields…binary search. 
 if sy-subrc = 0. 
  itab3-filed1= itab1-filed1.
  itab3-filed2= itab2-filed2.
  append itab3.
  clear itab3.
 endif.
endloop.

Re: nedd help

Former Member — Wed, 25 Jul 2007 19:39:54 GMT

HI,

Are you sure the this loop is taking time or the select statement taking the time..

check ur select statements

Sort the Tables itab1 and itab2 by the same key..

loop at itab1.

read table itab2 with key 1 , 2 ,3 <b>binary search.</b>

if sy-subrc eq 0.

append itab3.

endif.

endloop.

Re: nedd help

Former Member — Wed, 25 Jul 2007 19:47:46 GMT

thaq Santhosh and mahesh.

given points .

regards,

Ajay reddy