Problem in table maintenance

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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