topic Re: optimising loop in Application Development and Automation Discussions

optimising loop

sudha_naik — Fri, 24 Aug 2007 11:07:14 GMT

Hello all,

Is there any way in which we can optimise this loop ??

LOOP AT I_SEA WHERE MATNR EQ I_MATNR.

T_SEA = I_SEA.

APPEND T_SEA.

ENDLOOP.

Regards

Sudha

Re: optimising loop

Former Member — Fri, 24 Aug 2007 11:10:04 GMT

Plz can you give clear information in your question.

Regards,

Vimal

Re: optimising loop

Former Member — Fri, 24 Aug 2007 11:10:27 GMT

T_SEA[] = i_SEA[].

DELETE T_SEA where MATNR NE I_MATNR.

Re: optimising loop

seshatalpasai_madala — Fri, 24 Aug 2007 11:12:05 GMT

Hi,

Try

APPEND LINES OF I_SEA TO T_SEA.

DELETE T_SEA WHERE MATNR <> l_MATNR.

Do not do


T_SEA[] = I_SEA[]. "This will overwrite existing data

Regards,

Sesh

Re: optimising loop

Former Member — Fri, 24 Aug 2007 11:13:44 GMT

Hi,

Instead of using header line you can use fields symbols.

Field-symbols <f_sea> type <type of internal table i_sea>.

Loop at i-sea assigning <f_sea> where matnr EQ i_matnr.

wa_tea = <f_sea>.

append wa_seat to t_sea.

endloop.

Field symbols dioes not required any space... it point outs directly the data and pushes it further/

rewards if useful.

regards ,

nazeer

Re: optimising loop

varma_narayana — Fri, 24 Aug 2007 11:17:18 GMT

Hi Sudha..

this will be much better if both the Tables have same structure...

T_SEA[] = I_SEA[].

Delete t_sea where matnr ne i_matnr.

Reward if Helpful.

Re: optimising loop

sudha_naik — Fri, 24 Aug 2007 11:33:09 GMT

tsea[] = isea[]

delete tsea

This code consumes more time than the loop.

Re: optimising loop

Former Member — Fri, 24 Aug 2007 11:37:15 GMT

Hi Sudha,

The performance would depend on the no. of Entries in I_SEA which are equal to I_MATNR.

Since you are saying that the loop is taking less time as compared to T_SEA = I_SEA. Then the no. of records with I_SEA-MATNR = I_MATNR are less.

So this cant be further optimizied & the loop which you have placed is perfect.

Best regards,

Prashant

Re: optimising loop

seshatalpasai_madala — Fri, 24 Aug 2007 11:41:18 GMT

Hi,

Performance always depends on the kind of data and amount of data you have in this case.

For some cases your code can be good in performance and for some cases mycode can give you the performance.

So as you said if the performance is good with your code then its good for the current data you have.

Regards,

Sesh