topic Re: data transfer between 2 tables in Application Development and Automation Discussions

data transfer between 2 tables

Former Member — Fri, 19 Sep 2008 05:30:22 GMT

HI Guys,

i have a table like table1 with 4 fields, and 5 records, data.

i had created another table2 with just copy from table1.

so both tables table1,table2 having same structure.

now the question is how to copy the data i.e, 5 records from table1 to table2.

plz let me know the clear scenario.

Thanks in Advance,

Amit.

Former Member — Fri, 19 Sep 2008 05:31:22 GMT

table2[] = table1[].

Former Member — Fri, 19 Sep 2008 05:31:25 GMT

Hi,

try this way if structures are same

table1[] = table2[].

Cheers,

Kothand

Former Member — Fri, 19 Sep 2008 05:31:54 GMT

table2[] = table1[]

GauthamV — Fri, 19 Sep 2008 05:31:58 GMT

hi,

use move or move-corresponding statement.

Former Member — Fri, 19 Sep 2008 05:32:30 GMT

select * from table1 into itab.

insert <table2> from table itab.

Former Member — Fri, 19 Sep 2008 05:35:26 GMT

hiiiiiii

use

move itab2 to corresponding fields of itab2.

this will surely help you.

Former Member — Fri, 19 Sep 2008 05:40:51 GMT

if you have created standard internal tables then to copy data from one table tab1 to another table tab2 use

append lines of tab1 to tab2.

if you have created tables in abap dictionary then to copy data from one table tab1 to another table tab2 use

data :itab type table of tab1 with header line.

select * from tab1 into table itab.

loop at itab.

insert tab2 from itab.

endloop.