How to setup SAP Table field NULL or NOT NULL

Former Member — Mon, 01 Dec 2008 08:17:31 GMT

What is NUll Value how is it different from Space or blank. how do we set table field to Null or Not NULL?

Re: How to setup SAP Table field NULL or NOT NULL

Former Member — Mon, 01 Dec 2008 08:21:24 GMT

Do This

In SE11 under tab Fields, the third column(check box) is used for the same i.e "Indicator that NOT NULL is forced for this field".

Ranga

Re: How to setup SAP Table field NULL or NOT NULL

Former Member — Mon, 01 Dec 2008 08:37:06 GMT

A Database NULL value represents a field that has never been stored to database - this saving space, potentially.

Usually all SAP tables are stored with all fields, empty fields are stored with their initial value.

But: If a new table append is created and the newly-added fields do not have the 'initial value' marked in table definition, Oracle will just set NULL values for them.

as mentioned: There is no NULL value to be stored in an ABAP field. The IS NULL comparison is valid only for WHERE clause in SELECT statement. WHERE field = space is different from WHERE field IS NULL. That's why you should check for both specially for appended table fields.

If a record is selected (fulfilling another WHERE condition) into an internal table or work area, NULL values are convertted to their initial values anyway.

hope this helps

regards

Aakash Banga

topic Re: How to setup SAP Table field NULL or NOT NULL in Application Development and Automation Discussions

How to setup SAP Table field NULL or NOT NULL

Re: How to setup SAP Table field NULL or NOT NULL

Re: How to setup SAP Table field NULL or NOT NULL