Database Table Modification!

[Former Member]

Hi!

I want to change database table i.e for e.g a table contains 10 fields with data in database i want to add 3 more fields to that table so that the data should not be removed or changed & after i ve added the fields i want to insert records to the 3 fields i ve created to the corresponding record.

Can u pls tell me how to achieve this task.

Thanks

[Former Member]

hi Rahul,

Do this way ...

Goto se11 and enter the name of the table in which you want to enter the fields,

enter the fields and if any error occurs just goto UTILITIES->DATABASE UTILITY-> ACTIVATE AND ADJUST DATABASE.....

Also see the links,

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb61446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb61446011d189700000e8322d00/frameset.htm

Regards,

Santosh

[Former Member]

hi Rahul,

Refer this .... might be some help

Regards,

Santosh

[Former Member]

hi Rahul ,

Go to se11, go to the change view of that table n add the fields..

If the new fields are not key fields , then add the fields and activate the table

If the new fields are key ields then after adding the fields , go to menu- utilities and adjust the table with the option save data

[Former Member]

Hi Rahul,

For your requirement " i want to insert records to the 3 fields i ve created to the corresponding record"

You will have to write a separate program i think.

Regards,

Sameer