topic Re: performance issue while transferring data from one itab to another itab in Application Development and Automation Discussions

performance issue while transferring data from one itab to another itab

Former Member — Mon, 18 Dec 2006 07:18:37 GMT

hi experts,

i have stored all the general material details in one internal table and description, valuation details of the meterial is stored in another internal table which is of standard table. now i need to tranfer all the data from these two internal tables into one final internal table but it is taking lot of time as it has to transfer lacs of data.

i have declared the output table as shown below

DATA:

t_output TYPE standard TABLE

OF type_output

INITIAL SIZE 0

WITH HEADER LINE.

(according to the standard i have to declare like this and the two internal tables are declared similar to the above one)

could somebody suggest me how shall I procced through this...

thanks in advance....

ragerds,

Deepu

Re: performance issue while transferring data from one itab to another itab

Former Member — Mon, 18 Dec 2006 07:32:52 GMT

sort itab1 by matnr.

sort itab2 by matnr.

loop at itab1.

move itab1-field to itab3.

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

if sy-subrc = 0.

move: itab2-field to itab3.

endif.

append itab3.

endloop.

Re: performance issue while transferring data from one itab to another itab

Former Member — Mon, 18 Dec 2006 07:45:41 GMT

Hi Deepu ,

I think you have to loop on the internal tables and populate the third table , this is the only way which i can remember .

Regards

Arun

Re: performance issue while transferring data from one itab to another itab

Former Member — Tue, 19 Dec 2006 15:25:59 GMT

Have a look at the following article which you may find useful:

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40729734-3668-2910-deba-fa0e95e2c541">Improving performance in nested loops</a>

good luck, damian

Re: performance issue while transferring data from one itab to another itab

Former Member — Wed, 20 Dec 2006 06:44:33 GMT

performance issue is solved by sorting the table with key fields.

thanks

deepu.

Re: performance issue while transferring data from one itab to another itab

Former Member — Wed, 20 Dec 2006 06:52:47 GMT

hi damian,

very thankful to your response....

thanks & regards,

deepu

Re: performance issue while transferring data from one itab to another itab

yes_sapteam — Wed, 20 Dec 2006 12:14:26 GMT

For nested loop there is a very good example in the "Environment->Performance example" menu item (the "Environment" menu is default in many transactions, e.g. SE38).

Go to this page (no TCode for it) and in the "Internal Tables" box look for the "Nested loops" example .

enjoy.

ayal.