topic Re: Copying tables in Application Development and Automation Discussions

Copying tables

Former Member — Fri, 05 Sep 2008 07:01:21 GMT

Hiee friends ,

I am new to abap .I copied a standard sap table [sflight ] to zsflight .the table is getting copied but the data in sflight is not getting copied into zsflight .

Is there any ways to copy both the table and its data contents to another customizable table .

Re: Copying tables

JozsefSzikszai — Fri, 05 Sep 2008 07:07:06 GMT

hi,

unfortunately there is no automatic way. you have to recreate the data through ABAP, or manually.

hope this helps

Re: Copying tables

Former Member — Fri, 05 Sep 2008 07:10:18 GMT

How can we do it through abap ??

Is it possible through bdc ?

Friends i am really new to abap ,so don't have indepth knowledge of abap .plse don't mind as me asking such questions.

Re: Copying tables

Former Member — Fri, 05 Sep 2008 07:11:54 GMT

Hi,

You can not copy the data of any database table whenever you are copying standard table to Custom table or ztable.

Only the definition is copied not the contents.

For data you have to enter manuallly through table maintenace generator of through program.

Regards,

sujit

Re: Copying tables

JozsefSzikszai — Fri, 05 Sep 2008 07:14:55 GMT

no problem, we all started somewhere...

you can't use bdc for this!

ABAP way:

1. select all data from sflight into internal table

2. instert all data into zsflight! (check INSERT statement in SAPHelp!)

Re: Copying tables

Former Member — Fri, 05 Sep 2008 07:22:36 GMT

Hi,

Create a program to fetch all the data from sflight, pu it into a internal table and then upload those data into ur ztable.

Thnaks,

Re: Copying tables

Former Member — Fri, 05 Sep 2008 07:26:30 GMT

Hi,

There is no direct way.What you can do create a zprogram, in this program create a workarea and an internal table of type sflight. Now fetch the data from sflight table into this internal table. Now with the help of this internal table insert the data into your ztable.

Regards

Abhijeet

Re: Copying tables

Former Member — Fri, 05 Sep 2008 07:30:30 GMT

Hi Lokesh,

To copy the data from a database table into a ztable,

you need to select the data from the database table into an internal table and insert the data into the target ztable, through ABAP Program.

Select * from sflight

into table t_sflight.

loop at t_sflight.

insert into <ztab1>....

endloop.

Regards,

Chandra Sekhar

Re: Copying tables

Former Member — Fri, 05 Sep 2008 11:05:17 GMT

Thanks friends for all these valuable reply .