12-01-2008 8:17 AM
What is NUll Value how is it different from Space or blank. how do we set table field to Null or Not NULL?
12-01-2008 8:21 AM
Hi
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
12-01-2008 8:21 AM
Hi
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
12-01-2008 8:37 AM
hi
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