ARTICLE
Null Value
Initial value of an empty column in a row of a
database table . Null values can be
processing using Native SQL
statements, but they have no equivalent as the content of
data objects in ABAP. Only the
WHERE addition enables a special condition
IS NULL for null values. Modifying
Open SQL statements (
INSERT , UPDATE
, and MODIFY ) generally do not create
null values, provided that a view is not being
processed that does not comprise all columns of a database table.
However, depending on the database
system , empty strings can also be displayed
as null values. Null values can still arise in database tables if the
new columns are appended to filled tables. If using the Open SQL
statement SELECT to perform reads, null values
can be produced by aggregate
functions and outer joins . When passed to
data objects, these values are transformed to type-appropriate
initial values , but are handled as
standalone values in the additions GROUP BY
and ORDER BY .
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved