Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

T code to Copy Data from one table to another table

Former Member
0 Likes
1,515

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,051

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.

9 REPLIES 9
Read only

former_member776318
Participant
0 Likes
1,051

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

Read only

0 Likes
1,051

Both table is on same client.

Read only

0 Likes
1,051

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

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

A.

Read only

0 Likes
1,051

Ok.. Thanks for your help..

Read only

Former Member
0 Likes
1,051

Hi,


itab1[] = itab2[].

regards, Dieter

Read only

Former Member
0 Likes
1,052

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.

Read only

kerem_kayacan
Active Participant
0 Likes
1,051

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

Read only

Former Member
0 Likes
1,051

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

Read only

former_member778253
Active Participant
0 Likes
1,051

Hi

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....