creating a table based on a user created table

[aris_hidalgo]

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!

[Former Member]

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

Click Append structure into your SE11.

[Former Member]

hi Viraylab,

give the name of the table and goto

dictionary Object -> copy

give the other name there

regards

satesh

[aris_hidalgo]

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!

[Former Member]

The table name can be only 16 characters long.

Restrict your name ztm_accounted_variance

like : ztm_acc_var

[Former Member]

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

[aris_hidalgo]

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!

[Former Member]

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.

[jayanthi_jayaraman]

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.

[Former Member]

HI

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