topic Problem in table maintenance in Application Development and Automation Discussions

Problem in table maintenance

Former Member — Mon, 29 Jan 2007 22:44:56 GMT

Hi experts,

I have created a custom table which contains one field as primary tey let us suppose field name is A.This field is chanracter data type.But it is allowinf Blank values also. Can anybody knows how to ristrict it.

Thanks,

Lakshmi.

Re: Problem in table maintenance

Former Member — Mon, 29 Jan 2007 22:52:36 GMT

Hi,

GO to SE51..Give the program name and screen number for the table maintenance..

Make the field as required..Then it will not allow blank values..

Thanks,

Naren

Re: Problem in table maintenance

Former Member — Mon, 29 Jan 2007 23:07:00 GMT

Naren,

other than changing the proram., any other solution. when creating the table you have to give two flags one is primary kay and other one is Initial. I think if you deselect that flag then it may come, but it is not remain deselected after activating it is selecting the flag automatically do you know why...?

Thanks,

lakshmi.

Re: Problem in table maintenance

Former Member — Mon, 29 Jan 2007 23:18:27 GMT

Hi,

Another solution is..

You can create a Maintenance view..

Go to SE11.

Press the view radio button..

Give a name..Press create button..

In the table/join conditions tab...Give the table name..

Give the view field names in the view tab.

In the selection conditions...

Give the table name, field name, <> , ' '

Generate the table maintenance for this view...Now it will not allow you enter blank values..

Thanks,

Naren

Re: Problem in table maintenance

Former Member — Tue, 30 Jan 2007 00:59:13 GMT

Hi,

For any combination of the primary keys, you can have one entry each with a blank value and without a blank value.

Maybe there is already an entry with that field as blank in the database. This could be one of the reason why it is not accepting another duplicate entry with that field as blank.

Regards

Subramanian

Re: Problem in table maintenance

Former Member — Tue, 30 Jan 2007 16:22:43 GMT

You are obsolutely correct subramnyan.But they dont want blank values in that field.Any how I have solved it using Events Thank you all for your great help.

Lakshmi