Skip to Content
0
Former Member
Nov 06, 2005 at 12:08 AM

Mass modification of large data base tables

1063 Views

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