Question:
Hi,
I have a problem, I want to make a copy of ekpo table in other 'z' table with the same structure, and I want to know if someone knows a faster way by abap program, for make this copy.
Thanks
Answer:
Well, load it in stages .. read a chunk of the entries at one time like say every 10K and update it into the Z table .. use OPEN CURSOR & FETCH and keep track the last cursor .. to start reading the DB table so that you won't need to reread the whole table again.
Answer:
And use the WITH HOLD addition of OPEN CURSOR.
use INTO TABLE and PACKAGE SIZE additions in the FETCH statement,
and use CALL FUNCTION 'DB_COMMIT'. after inserting the selected entries into the new Z_table.
BTW, why do you need a copy? It will be out-of-sync very soon.