topic Re: T code to Copy Data from one table to another table in Application Development and Automation Discussions

T code to Copy Data from one table to another table

Former Member — Tue, 03 Aug 2010 09:24:50 GMT

Hi,

I want copy all data of one table to its copy table. Anyone knows transaction code to copy data from one table to another table.

Regards,

Jigar Thakkar.

Re: T code to Copy Data from one table to another table

former_member776318 — Tue, 03 Aug 2010 09:28:53 GMT

Are your source and target tables in the same client or different ones?

Re: T code to Copy Data from one table to another table

Former Member — Tue, 03 Aug 2010 09:30:04 GMT

Hi,


itab1[] = itab2[].

regards, Dieter

Re: T code to Copy Data from one table to another table

Former Member — Tue, 03 Aug 2010 09:32:36 GMT

Hi,

You can not copy data from one table to another table

but you can copy schema of a table to another table in se11.

If you want you can write a addon prog to do this..

Thanks.

Re: T code to Copy Data from one table to another table

kerem_kayacan — Tue, 03 Aug 2010 09:38:17 GMT

You can develop a little program to do that. It shouldn't take much effort.

Re: T code to Copy Data from one table to another table

Former Member — Tue, 03 Aug 2010 09:38:55 GMT

Both table is on same client.

Re: T code to Copy Data from one table to another table

Former Member — Tue, 03 Aug 2010 09:38:56 GMT

Hi Jigar,

If your tables belongs to the same system then you can copy data faster with TMG (Table Maintenance View)...here you can copy and save multiple lines at one go

If your original and copy table belongs to different system then check this community project [SAPLINK|http://code.google.com/p/saplink/]....here one Plugin is available for transferring Table contents

Re: T code to Copy Data from one table to another table

andreas_mann3 — Tue, 03 Aug 2010 09:49:28 GMT

Have'nt you read the comment of Kerem, have you?

there'll be no standard tcode..you 've to create your own program..

Re: T code to Copy Data from one table to another table

Former Member — Tue, 03 Aug 2010 09:51:15 GMT

Ok.. Thanks for your help..

Re: T code to Copy Data from one table to another table

former_member778253 — Tue, 03 Aug 2010 10:25:04 GMT

Create a small program.

Extract data from T1 - database table and put it in one internal table - itab1.

loop the itab1 data .............

insert itab1 into tab2. (tab2 - second database table)

endloop.

try this....

hope it works....