adding new Column in existing table

[Former Member]

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

[Former Member]

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

[Former Member]

hi

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Zafar, is it working? have you tried?

[Former Member]

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

[Former Member]

ok no probs..but it works..

[Former Member]

OK

[Former Member]

This message was moderated.

[Former Member]

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

[Former Member]

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

[Former Member]

raveesh,

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

[Former Member]

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

[Former Member]

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