02-28-2006 5:18 AM
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!
02-28-2006 5:33 AM
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
02-28-2006 5:21 AM
You can just include or append the table structure into the new table...
Click Append structure into your SE11.
02-28-2006 5:21 AM
hi Viraylab,
give the name of the table and goto
dictionary Object -> copy
give the other name there
regards
satesh
02-28-2006 5:26 AM
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!
02-28-2006 5:28 AM
The table name can be only 16 characters long.
Restrict your name ztm_accounted_variance
like : ztm_acc_var
02-28-2006 5:37 AM
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
02-28-2006 5:39 AM
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!
02-28-2006 5:43 AM
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.
02-28-2006 5:32 AM
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.
02-28-2006 5:33 AM
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