topic Re: copying table in Application Development and Automation Discussions

copying table

Former Member — Wed, 08 Aug 2007 13:53:35 GMT

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.

Re: copying table

Former Member — Wed, 08 Aug 2007 13:56:43 GMT

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á

Re: copying table

Former Member — Wed, 08 Aug 2007 14:06:07 GMT

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

Re: copying table

Former Member — Wed, 08 Aug 2007 14:14:06 GMT

directly it copies all the fields

Re: copying table

Former Member — Wed, 08 Aug 2007 14:30:43 GMT

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.

Re: copying table

Former Member — Wed, 08 Aug 2007 14:36:01 GMT

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