Black Friday is ending this Friday! 40% off with coupon CYBER40 - Sign up here

Close
  1. SAP Glossary
  2. SAP BusinessObjects Data Federator
  3. not-null constraint


What is 'not-null constraint' in SAP EIM-DI-DF - SAP BusinessObjects Data Federator?


not-null constraint - Overview


not-null constraint - Details


  • Key Concepts: A not-null constraint is a type of data integrity constraint in SAP BusinessObjects Data Federator (EIM-DI-DF). It ensures that a column in a table cannot contain any null values. This means that the column must contain a value, even if it is an empty string or zero.
    How to use it: To use a not-null constraint, you must first create a table in SAP BusinessObjects Data Federator. Then, when creating the columns for the table, you can specify that certain columns must have a not-null constraint. This will ensure that any data entered into those columns must have a value.
    Tips & Tricks: When creating a not-null constraint, it is important to consider the data type of the column. For example, if the column is an integer type, then it cannot contain an empty string or zero as these are not valid values for an integer type.
    Related Information: Not-null constraints are just one type of data integrity constraint available in SAP BusinessObjects Data Federator. Other types of constraints include unique constraints, primary key constraints, and foreign key constraints. All of these constraints help to ensure that the data stored in the database is valid and accurate.

    Already have an account? Login here!





not-null constraint - Related SAP Terms

Rating
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant