topic Re: Key Fields accepts Null values in Application Development and Automation Discussions

Key Fields accepts Null values

Former Member — Tue, 13 Feb 2007 07:48:39 GMT

Hi All

I cretaed a ztable in data dictionary. It has 2 key fields

1) LOCATION (user defined).

2) SPRAS (Language field).

Here i don't want them to accept null values which they are doing .

what i need to do .

Thanks and regards

Re: Key Fields accepts Null values

Former Member — Tue, 13 Feb 2007 07:51:17 GMT

while creating the key field , select the check box <b>'Initial Values'</b>

Re: Key Fields accepts Null values

Former Member — Tue, 13 Feb 2007 07:57:56 GMT

Hi,

click on the initial value check box in the table and it will solve ypur problem

Thanks

Shiva

Re: Key Fields accepts Null values

Former Member — Tue, 13 Feb 2007 09:53:50 GMT

Naval,

While creating the table in SE11, just after we maintain the fields there are two columns as 'Key' and 'Initial Value'. You need to check the 'Initial Value' for the respective fields and it should not accept null values then.

Thanks.

Re: Key Fields accepts Null values

Former Member — Tue, 13 Feb 2007 10:01:07 GMT

hi Chandra and shiva

See what happens here ,table has 2 key fields . 'initial values are checked for both' .

Both are character fields and not numeric.

If it accepts null (blank) for both the fields then do not do same again

if null value has been entered for the first and some other value for the second field

then also same thing will not repeat.

if it accepts null value for the second and some value for the first then this will also not repeat as the property of key fields but requirement is not to accept Null value even for the first time for these 2 fields.

please reply asap. waiting for your reply

Naval

Re: Key Fields accepts Null values

Former Member — Tue, 13 Feb 2007 10:25:15 GMT

Naval,

If you have checked Intitial Values for the both the fields system will not accept null value for any of the field....

Re: Key Fields accepts Null values

Former Member — Tue, 13 Feb 2007 12:54:54 GMT

i din't solve the problem

Re: Key Fields accepts Null values

Former Member — Tue, 13 Feb 2007 14:20:13 GMT

Rahul

Problem is still the same even if both 'Initial values ' check boxes are checked .

Re: Key Fields accepts Null values

Former Member — Tue, 13 Feb 2007 14:53:25 GMT

Hi,

IF you do not want to store null values in both the fields then you can control only through program.

If you have table maintenance for this table, then make these two fields as mandatory, then there is no way that you can enter a null value.

For making this mandatory through table maintenance, go to SM30, and select this table and press maintain. Now go to the screen layout (Settings -> status ->dbl click screen number)

Change the properties of the fields to required fields.

Regards

Subramanian

Re: Key Fields accepts Null values

Former Member — Wed, 14 Feb 2007 04:00:59 GMT

Hi Subramanian

How can change the properties of the fields to required fields. Can you explain a little bit.

Re: Key Fields accepts Null values

Former Member — Wed, 14 Feb 2007 04:13:50 GMT

Hi guys

Problem is still the same . I think it can only be changed by table maintainace as suggested by subramani but i didn't get how it can be done . Suggest me the steps .

Reply ASAP

Thanks and Regards

Naval

Re: Key Fields accepts Null values

Former Member — Wed, 14 Feb 2007 05:59:08 GMT

download this document and try accordingly:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

Regards

Shiva