Key Fields accepts Null values

[Former Member]

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

[Former Member]

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

[Former Member]

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

or

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

then also same thing will not repeat.

or

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

[Former Member]

Naval,

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

[Former Member]

i din't solve the problem

[Former Member]

Rahul

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

[Former Member]

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

[Former Member]

Hi Subramanian

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

[Former Member]

Hi,

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

Thanks

Shiva

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

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%20im...

Regards

Shiva