topic Re: Copying table data to another table in Application Development and Automation Discussions

Copying table data to another table

Former Member — Wed, 05 Mar 2008 21:14:41 GMT

I have a table with data and similar table with no data.

How to copy the table data into another table. Can any one suggest easy method?

Re: Copying table data to another table

Former Member — Wed, 05 Mar 2008 21:17:19 GMT

use this

LOOP AT table 1

MOVE-CORRESPONDING table1 TO table2.

APPEND table2.

ENDLOOP.

Corresponding is used when both the tables have same field names. plz Make sure

thanks

Re: Copying table data to another table

Former Member — Wed, 05 Mar 2008 21:17:52 GMT

For Internal Tables...


T_TABLE2[] = T_TABLE1[].

For dictionary tables...

[Taking good care of Z Data|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3340] [original link is broken] [original link is broken] [original link is broken];

Greetings,

Blag.

Re: Copying table data to another table

Former Member — Wed, 05 Mar 2008 21:17:57 GMT

itab[ ] = jtab[ ].

Re: Copying table data to another table

Former Member — Wed, 05 Mar 2008 21:37:58 GMT

Those tow are database tables.

Example : Need to copy data from database table ztest1 to another database table ztest2.

Re: Copying table data to another table

Former Member — Wed, 05 Mar 2008 21:43:13 GMT

Then you have download that data int o an internal table in your program then should update into second internal table.

select * from ztable1 into itab.

if not itab[] is initial.

modify ztable2 from table itab.

endif.

Thanks,

Naren

Edited by: Naren Someneni on Mar 5, 2008 3:44 PM