How to setup SAP Table field NULL or NOT NULL

[Former Member]

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

[Former Member]

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

[Former Member]

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