Skip to Content
0
Former Member
Nov 20, 2012 at 12:29 PM

Moving all content from large standard tables to Z-tables

452 Views

Hi All,

I have created a replica of the 3 standard tables into 3 Z Tables. Now my requirement is to dump all the standard table records into the newly created Z Tables. For that i need to create a report. Now my issue is if i write direct select query (Select * from mara into it_mara) then definetly the select query will go into dump coz of the huge data (there will be no where clause for any of the select query).

So please suggest some performance tips where i can fetch all the records from the standard table and dump the same in Z Tables without any performance issue.

I tried to use the Open Cursor method, but was unable to understand the concept of that. A piece of pseudo code will help me a lot.

Thanks in advance,

Santa