Skip to Content
0
Former Member
Apr 24, 2009 at 10:06 AM

How to do batch update for high number of records?

80 Views

Hello friends,

I have internal table i_tab with 500000 records,

and i want to update all these records in the database. I have a Function module to update this records.

so , if i do like...

Loop at Itab
	CALL FUNCTION 'UPDATE_DATA'         " Any update function
		IMPORTING
			field1 = field 1
		TABLES
			ev_table = I_TAB[]  " 500000 records

Endloop.

But It is taking too much time.

Does any body know about how can I update records in the batch?

like....batch of 2500 records at the time.

Please give me the example or code for this.

Thanks in advance,

Ronny