topic Re: Table field attribute - nullable in Application Development and Automation Discussions

Table field attribute - nullable

Former Member — Fri, 27 Jun 2008 10:13:37 GMT

Hi gurus!!

We have a problem with an attribute of a table field.

When we create a table field, depending on the data type we specifiy (CHAR, RAW, NUMC...) the system indicates the nullable attribute to YES or NO.

We don't know if the nullable attribute depends of the data type and if we can change the value of this attribute from SAP.

We see the nullable attribute value directly from DB2 console.

We would like to change this value from SAP, we don't know if we must do something when we create the table field...

Thank you very much in advanced,

Edorta

Re: Table field attribute - nullable

Former Member — Fri, 27 Jun 2008 11:37:25 GMT

The initial value cannot be set for fields of data types LCHR, LRAW, and RAW; for all others types switch on/off the column 'Initial Value' when maintaining the table definition (transaction SE11).

Regards,

John.

Re: Table field attribute - nullable

Former Member — Fri, 27 Jun 2008 14:29:48 GMT

Hi Edorta.

I suggest, This issue needs to be taken great interest and research.

To initiate, I suggest.

We must must not include any default values as they may lead to nullablility.

By Java, maybe Webdypro integration this problem can be tackled.

I am still researching on this problem you are facing.

Regards Harsh

Re: Table field attribute - nullable

Former Member — Fri, 04 Jul 2008 10:01:55 GMT

The finally found a solution to this issue,

When you enter in change mode to se11 to create a new field, you must insert into ok-code the null value.

This action allows a new flag in the properties of the field wich assign the null value to the fields.

Unfortunatelly, this option is only valid for new fields, no valid for already created fields.

I hope this helps somebody.

Edorta.