SAP NULL VALUE - Glossary

Get Example source ABAP code based on a different SAP table
  


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.