Db Table

[Former Member]

Hi ,

I have Ztable with many fields. Now, I would like to change the data type of the one field From Char to Numeric. But we have so many records . How can i do i t? If I change it directly sap will accept and adjust it or not ?

Bye,

Satya.

[Former Member]

HI Satya,

Change the field name and follow this steps i.e,goto-> database utility->activate and adjust the database.

Regards,

Santosh

[Former Member]

Hi,

what about the data which is already exists in character fields ?

Bye,

Satya.

[Former Member]

Hi,

if u change the structure of a table u should adjust the structure in tcode se14.

data will not be same as earlier.that data also will be changed accordingly.

rgds,

bharat.

[Former Member]

Hi,

You can change datatype of the field from Char to Numeric. however after doing that table will not allow to activate because there are some already existing records. hence you have to go to transaction SE14 and adjust the database. after that table will allow for activation.

thanks,

sksingh

[Former Member]

HI,

already existing data will be converted to Numeric form as per new datatype.

thanks,

sksingh

[Former Member]

Thanks for your answer.

I will try it.

But what is this se14 ? what is the use of this transaction ?

what is the difference between se14 and adjust database utlity in se11 ?

Bye,

Satya.

[Former Member]

hi Satya,

Both are same. You can either adjust the database via SE11 OR SE14.

Regards,

Santosh

[Former Member]

hi,

navigatio::::: se11--> goto-> database utility->activate and adjust the database.

then table field which uused is adjusted according to the given type

with regards,

suresh babu aluri.

[Former Member]

Hi ,

what about the character data ?

Suppose in field data is like -- abcde...

then about that data ?

how it will adjust ?

Bye,

Satya.

[Former Member]

HI,

if abcde will be there it will be replaced by 0000... in case if u change the str from char to numc type.and also if the primary keys are same while altering the data like this some reocrd will be deleted.

the remaining fields data will not be altered in the records.

reward if helpful.

rgds,

bharat.

[Former Member]

hai ,

u can change the data element from char to numeric which has already some entries in it . After changing goto utilities -database utility and click on the 'adjust and activate the table '.

Do reward points if u r satisfied........