topic Re: Db Table in Application Development and Automation Discussions

Db Table

Former Member — Tue, 15 May 2007 04:45:25 GMT

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.

Re: Db Table

Former Member — Tue, 15 May 2007 04:48:26 GMT

HI Satya,

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

Regards,

Santosh

Re: Db Table

Former Member — Tue, 15 May 2007 04:49:54 GMT

Hi,

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

Bye,

Satya.

Re: Db Table

Former Member — Tue, 15 May 2007 04:51:58 GMT

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

Re: Db Table

Former Member — Tue, 15 May 2007 04:53:39 GMT

HI,

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

thanks,

sksingh

Re: Db Table

Former Member — Tue, 15 May 2007 04:54:57 GMT

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.

Re: Db Table

Former Member — Tue, 15 May 2007 04:55:27 GMT

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.

Re: Db Table

Former Member — Tue, 15 May 2007 04:57:24 GMT

hi Satya,

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

Regards,

Santosh

Re: Db Table

Former Member — Tue, 15 May 2007 04:59:05 GMT

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.

Re: Db Table

Former Member — Tue, 15 May 2007 04:59:08 GMT

Hi ,

what about the character data ?

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

then about that data ?

how it will adjust ?

Bye,

Satya.

Re: Db Table

Former Member — Tue, 15 May 2007 05:10:45 GMT

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........

Re: Db Table

Former Member — Tue, 15 May 2007 05:11:29 GMT

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.