01-30-2007 1:56 PM
Hi,
May i know the steps to add fields to a user defined table ?? .
Thxs,
Vind.
01-30-2007 1:59 PM
If you have authorization then you can simply add fields by clicking change button.
for that you must have DATA elements defined with domains for your required fields.
or
You can add by structure INCLUDE also.
By
Yuvaram
01-30-2007 2:02 PM
Hi,
pls follow the following steps.
1.Goto transaction se11
2. enter table name press change
3.click inser line
4.add field name
5. enter field type :if its a new field type enter a new name ->double click create new field type
6. save and activate
PS: if its a key field it should come in the begining of the field list along with all key fields.
Regards,
Sumit
01-30-2007 2:12 PM
Hi,
While do the steps told above. If you are inserting the Primary keys and your table is already having some entries. then either you have to delete the entries or
try with this path.
SE11 -> Change -> Utilities -> Database Objects ->Database Utility -> Adjust and Activate.
Regards,
Aman
01-30-2007 2:15 PM
as it is a user defined table...it will be a Z table...so a developer will have access...go to change mode....add the relevant fields and relevant data elements. U need to adjust the table fields...
also goto table maintenance and delete the one which is already existing and create a new one so that the added fields will also get reflected in the SM30 maintenance to add entries.
01-30-2007 2:23 PM
You can add fields to the transparent table, using transaction SE11.
Go to the change mode, insert rows into the field names table.
Now, if
-> the table had no contents you can activate it in a straight-forward way.
-> if the table already had entries before you made changes, then you can just save it ( but won't allow you to activate ). You will have to go to SE14 to activate ( Adjust and activate )