Table Copy

[Former Member]

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]

Hi Manoj,

SE11-> Table Name-> Ctrl + F5.

Regards,

Pulokesh

[awin_prabhu]

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]

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]

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