Hi,
My requirement is to modify material value of tables where ever matnr is available. previously followed alphanumeric external numbering for material no. Now this external alphanumeric materail no value to be modified with numeric no. This numeric no and alphanumeric no fields are kept in another custom table for mapping purpose.
Now I want to mass update all the tables where ever matnr is there, since we are going for upgradation.
Since lakhs of records are available in tables like vbap, mseg, resb, ekpo etc., it is taking lot of time.
Can any one suggest the better code for optimum performance.
presently code is like this.
open cursor for
select statement.
do
fetch the package size into itab.
modify dbtabname from table itab.
enddo.
we could not commit inside the do also.
please suggest the optimum performance code to mass update the table.
Thanks
Gnani