topic Re: Table -Mandatory fields -Intial Values in Application Development and Automation Discussions

Table -Mandatory fields -Intial Values

Former Member — Wed, 17 Dec 2008 03:22:23 GMT

All,

Created a custom table with mandatory fields with Intial values. But now I want these mandatory fields with out Intial values.I tried to disable it and activate the table, But these intial values are comes back(enabled automatically) after table activated. Also I tried with SE14, but it returns the same.

Some one please suggest me on this Issue .

Regards,

srs

Re: Table -Mandatory fields -Intial Values

Former Member — Wed, 17 Dec 2008 03:28:30 GMT

mandatory fields key(primry key) should not be modified after it has been set ....

Re: Table -Mandatory fields -Intial Values

Former Member — Wed, 17 Dec 2008 08:52:38 GMT

hi,

By default all the primary key fields take initial values. we can't change it.

regards

prajwala

Re: Table -Mandatory fields -Intial Values

Former Member — Wed, 17 Dec 2008 11:13:16 GMT

Hi Sridhar,

You are trying to break the definition of the Primary Key. A primary key will have initial values and that is why the duplicate entries are not allowed when you update the table data.

Regards,

-Syed.

Re: Table -Mandatory fields -Intial Values

Former Member — Thu, 18 Dec 2008 05:34:43 GMT

Hi,

You can not modify the primary key fields once it is set.

instead to delete the default value..delete all the enteries for that values from table and then deleta it.

Regards,

Rajesh Kumar

Re: Table -Mandatory fields -Intial Values

Former Member — Mon, 22 Dec 2008 09:10:35 GMT

By default all the primary key fields take initial values. and that is why the duplicate entries are not allowed when you update the table data.You can not modify the primary key fields once it is set.

Regards

Md.MahaboobKhan

Re: Table -Mandatory fields -Intial Values

Former Member — Mon, 22 Dec 2008 09:20:27 GMT

Delete the primary key field, activate and adjust the database using tcode se14 and recreate the field.

Re: Table -Mandatory fields -Intial Values

Former Member — Tue, 23 Dec 2008 07:48:47 GMT

Hi sridhar swarna

the problem you have got is with the mandt fields

these firleds are also called as primary fields which are unique in nature and are really important for retrieval of data from the db table.

the primary key will have initial values and now go to table maintennace generator and delete the old mandt field then create new field and assign as per your reqmnt.

thanks

srikanth.p

Re: Table -Mandatory fields -Intial Values

Former Member — Wed, 07 Jan 2009 05:04:26 GMT

Hi,

You cannot disable the once set value for the primary ker fileds and activate it again,as once value set for the key fields they will remain as it is. But this doesnot mean you cannot do it .

Delete all the enteries from the table, delete the maintainence generator,activate the table.

Again maintain the maintainenece generator and activate the tabel, and now do the eneteries.

though this is bit lenghty procedure but will will solve the problem.

Pooja

Re: Table -Mandatory fields -Intial Values

Former Member — Wed, 04 Feb 2009 11:37:10 GMT

Hi Sridhar

key fields of a table will automatically be flaged as initial after activation.

Neither you can leave it blank nor you can change it.This initial flag will give

the type specific initial value to the field.

Hope this cleared your doubt

Regards

Menon