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.