Skip to Content
0
Former Member
May 28, 2008 at 06:30 AM

Perforce issue in loop

22 Views

Hi experts,

In my program I have used this loop to populate article text(makt-maktx) and ean number (mean-ean11) in records fetched from mara on the basis of matnr.

in my test server mara contains 46k records and in marc there are 80k records corresponding to materials in mara.

my problem is that this loop is taking more than 6 minutes to execute causing the program to go in runtime error.

Guys can you help me with how can i improve the performance

LOOP AT i_mara INTO w_mara.

CLEAR w_marc.

w_marc-maktx = w_mara-maktx.

IF w_mara-eantp IN r_eantp.

w_marc-ean11 = w_mara-ean11.

ENDIF.

MODIFY i_marc FROM w_marc TRANSPORTING maktx ean11

WHERE matnr = w_mara-matnr.

ENDLOOP.

Thanks in advance.