topic Re: creating a table based on a user created table in Application Development and Automation Discussions

creating a table based on a user created table

aris_hidalgo — Tue, 28 Feb 2006 05:18:16 GMT

Hello experts,

I was tasked to create a table based on another user created table. The user created table that I want to copy is ZTM0019 and the table that I will create will be named as ZTM_ACCOUNTED_VARIANCE.So how will I go about it? Thanks guys and take care!

Re: creating a table based on a user created table

Former Member — Tue, 28 Feb 2006 05:21:17 GMT

You can just include or append the table structure into the new table...

Click Append structure into your SE11.

Re: creating a table based on a user created table

Former Member — Tue, 28 Feb 2006 05:21:40 GMT

hi Viraylab,

give the name of the table and goto

dictionary Object -> copy

give the other name there

regards

satesh

Re: creating a table based on a user created table

aris_hidalgo — Tue, 28 Feb 2006 05:26:45 GMT

Hello again guys,

I am trying to type in ztm_accounted_variance in se11 and unfortunately it does not accept the whole word maybe because its too long. Any other suggestions? Thanks!

Re: creating a table based on a user created table

Former Member — Tue, 28 Feb 2006 05:28:24 GMT

The table name can be only 16 characters long.

Restrict your name ztm_accounted_variance

like : ztm_acc_var

Re: creating a table based on a user created table

jayanthi_jayaraman — Tue, 28 Feb 2006 05:32:51 GMT

Hi,

As told,you can give only 16 character.

In SE11,Enter the table name ZTM0019.

Then click the copy icon above it.

Then in the popup,give your table name.

Re: creating a table based on a user created table

Former Member — Tue, 28 Feb 2006 05:33:19 GMT

1 Go to the Dictionary: Initial Screen.

2 Choose the Tables radio button.

3 Press the Copy button on the Application toolbar.

4 Enter the name of the From and To tables.

5 Press the Continue button. You are returned to the Dictionary: Initial Screen and the message ++ appears in the status bar at the bottom of the window.

6 Press the Activate button on the application toolbar to activate the new table.

HOPE THIS WILL WORK OUT FOR YOU.

IF ITS WORKING FOR YOU PLEASE REWARD POINTS

REGARDS

ANOOP

Re: creating a table based on a user created table

Former Member — Tue, 28 Feb 2006 05:37:33 GMT

Hi Viray,

Goto SE11 Give the name as ZTM_ACC_VARIANCE press F5 to create give all the mandatory fields -> Activate the table. Come back to se11 main screen -> dictionary Object -> copy -> ZTM0019

Hope it helps...

Lokesh

Re: creating a table based on a user created table

aris_hidalgo — Tue, 28 Feb 2006 05:39:20 GMT

How come when I click the append structure on se11 I receive an error tahts says table has no fields. This table that I am creating must be of the same structure on another user created table.Thanks guys!

Re: creating a table based on a user created table

Former Member — Tue, 28 Feb 2006 05:43:08 GMT

If you want to add extra fields other than the table content use append structure.

Else use Copy in SE11. Enter table name and press Copy button and enter the source and dest table.

Now you will have a table created like the src table.