topic Re: Table Copy in Application Development and Automation Discussions

Table Copy

Former Member — Mon, 23 Nov 2009 05:15:35 GMT

Sir,

I would like to copy sflight table to zsflight with data on same client.

How can I do that, please explain me.

Thanks

Manoj.

Former Member — Mon, 23 Nov 2009 06:16:29 GMT

Hi Manoj,

SE11-> Table Name-> Ctrl + F5.

Regards,

Pulokesh

awin_prabhu — Mon, 23 Nov 2009 08:26:06 GMT

Hi Manoj,

For creating table ZSFLIGHT, follow what Pulokesh has said.

To copy data from SFLIGHT to ZSFLIGHT write a small program like below,

TABLES zsflight.

DATA: itab TYPE STANDARD TABLE OF sflight.

SELECT * FROM sflight INTO TABLE itab. " Get data from SFLIGHT

IF NOT itab[] IS INITIAL.

INSERT zsflight FROM TABLE itab. " Insert data into ZSFLIGHT

ENDIF.

Note: By default current client will get filled in 'MANDT' field.

Thanks,

Former Member — Mon, 23 Nov 2009 10:23:37 GMT

SE11 --> dictionary object --> Copy

And write a report program to copy the records of existing table to new table.

Hope you get it.

Former Member — Mon, 23 Nov 2009 11:36:48 GMT

Hi,

To copy a table goto SE11 --> Write the table name ---> dictionary object ~~> Copy~~-> give new table name -

> press the ok button.

To copy the contains of table to the new table a new code need to write.

DATA: itab TYPE STANDARD TABLE OF sflight.

SELECT * FROM sflight INTO TABLE it_sflight.

IF NOT itab[] IS INITIAL.

INSERT zsflight FROM TABLE it_sflight.

ENDIF.

Thanks,

Suman