08-08-2007 2:53 PM
Hi Abapers,
I have one custom table say 'ynacctr1', now i have copied this table to another table say 'ynacctr2'. structure got copied but how to copy the contents to newly created table...
Kindly help me.
Thanks,
Radhika.
08-08-2007 2:56 PM
Hi!
Use SM30 to copy them manually. For this you have to set the table maintenance generator in SE11 for that table.
IF you don't want to do it manually, you have to write a program for it.
Regards
Tamá
08-08-2007 2:56 PM
Hi!
Use SM30 to copy them manually. For this you have to set the table maintenance generator in SE11 for that table.
IF you don't want to do it manually, you have to write a program for it.
Regards
Tamá
08-08-2007 3:06 PM
HI,
Write small program for this.
data : itab like standard table of ynacctr1.
select * from ynacctr1 into itab.
if sy-subrc eq 0.
modify ynacctr1 from itab.
endif.
Thanks
mahesh
08-08-2007 3:14 PM
08-08-2007 3:30 PM
Solution: if it is a view, contents also gets copied automatically.
But if its a table, only structure gets copied. inorder to copy contents we can create table maintenance gen. and copy manually or through select query we can do it...
Thanks,
Radhika.
08-08-2007 3:36 PM
Hi,
The table contents will be copied when you copy a table, Gto SM30 and copy the contents, and come back to newly created strucutre from SM30 and press nEw Entries and paste those entries
Regards
Sudheer