topic Re: Database Table Modification! in Application Development and Automation Discussions

Database Table Modification!

Former Member — Sun, 24 Jun 2007 07:51:21 GMT

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

Re: Database Table Modification!

Former Member — Sun, 24 Jun 2007 08:00:58 GMT

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

Regards,

Santosh

Re: Database Table Modification!

Former Member — Sun, 24 Jun 2007 08:06:39 GMT

hi Rahul,

Refer this .... might be some help

Regards,

Santosh

Re: Database Table Modification!

Former Member — Sun, 24 Jun 2007 09:37:13 GMT

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

Re: Database Table Modification!

Former Member — Sun, 24 Jun 2007 09:41:32 GMT

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