topic Additional Fields to user defined table in Application Development and Automation Discussions

Additional Fields to user defined table

Former Member — Tue, 30 Jan 2007 13:56:07 GMT

Hi,

May i know the steps to add fields to a user defined table ?? .

Thxs,

Vind.

Re: Additional Fields to user defined table

Former Member — Tue, 30 Jan 2007 13:59:45 GMT

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.

You can add by structure INCLUDE also.

Yuvaram

Re: Additional Fields to user defined table

Former Member — Tue, 30 Jan 2007 14:02:07 GMT

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

Re: Additional Fields to user defined table

Former Member — Tue, 30 Jan 2007 14:12:09 GMT

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

Re: Additional Fields to user defined table

Former Member — Tue, 30 Jan 2007 14:15:07 GMT

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.

Re: Additional Fields to user defined table

Former Member — Tue, 30 Jan 2007 14:23:36 GMT

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 )