topic Re: adding new Column in existing table in Application Development and Automation Discussions

adding new Column in existing table

Former Member — Thu, 18 Feb 2010 09:19:21 GMT

Hi,

We have one dialog program transaction in which we are entering data of customer related to c form information with that transaction it is updating one ztable which we have made , in that table there are 11 column at present , now according to our user requirement we want to add one additonal filed on that transaction one one addiotionla column in the table what can be the problem if i add new column in that table evne there is lot of data present in that table till now.

regards,

zafar

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 09:31:52 GMT

Add column and do this

se14~~->Enter the table name~~>Active and adjust database

if u want stored data then select save data

if you want to delete data select the option delete data

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 09:42:20 GMT

add field from SE 11 and field save it..

and for activation go to

Utilities -> Database Object -> Database Utility -> Activate and adjust database(click on this button and before clicking select Save Data check box if you want previous data and if not then select delete data checkbox)

Edited by: Sachin Bidkar on Feb 18, 2010 10:42 AM

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 10:09:48 GMT

Hi,

Thanks for your reply,

just want to confirm on ething as i am adding fnew field today but i want my all previous data as it is and in this new filed for previous data it should be baln.

regards,

zafar

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 10:16:32 GMT

yes for previous data it will be blank for new field and for rest fields it will be same as previous

if you want this then you have to do for that

Utilities -> Database Object -> Database Utility -> Activate and adjust database(click on this button and before clicking select Save Data check box)

Edited by: Sachin Bidkar on Feb 18, 2010 11:16 AM

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 10:24:23 GMT

Hi,

I believe your your requirement will be fulfilled by adjusting the table using T Code SE14.

But first try doing it in sand box or some dummy table and check for the results so that

you don't loose any data by mistake.

Regards,

Raveesh

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 10:26:23 GMT

Hi,

I believe your your requirement will be fulfilled by adjusting the table using T Code SE14.

But first try doing it in sand box or some dummy table and check for the results so that

you don't loose any data by mistake.

Regards,

Raveesh

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 10:26:23 GMT

Hi,

I believe your your requirement will be fulfilled by adjusting the table using T Code SE14.

But first try doing it in sand box or some dummy table and check for the results so that

you don't loose any data by mistake.

Regards,

Raveesh

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 10:36:20 GMT

raveesh,

is it neccessary to check? as i did here for may ztables its working absolutely fine...

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 11:01:39 GMT

No. It is not necessary.

I was just saying it do so that we can have additional precautions.

If it is working fine, then you can go ahead with it.

Regards,

Raveesh

Edited by: raveesh saurabh on Feb 18, 2010 12:02 PM

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 11:42:10 GMT

Zafar, is it working? have you tried?

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 11:53:27 GMT

Hi sachin,

I have not try now along with this i have modify the program that i am doing now i willl give feedback on this after my modification.

regards,

zafar

Re: adding new Column in existing table

Former Member — Thu, 18 Feb 2010 12:20:38 GMT

ok no probs..but it works..

Re: adding new Column in existing table

Former Member — Fri, 12 Mar 2010 04:10:55 GMT

Re: adding new Column in existing table

Former Member — Tue, 26 Apr 2016 16:33:32 GMT

This message was moderated.