Table -Mandatory fields -Intial Values

[Former Member]

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

[Former Member]

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

[Former Member]

hi,

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

regards

prajwala

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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