Kontakt

Ansicht
Dokumentation

ABENDDIC_DATABASE_TABLES_INIT - DDIC DATABASE TABLES INIT

ABENDDIC_DATABASE_TABLES_INIT - DDIC DATABASE TABLES INIT

ROGBILLS - Synchronize billing plans   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

- Flag for Initial Values in Database Tables

Table fields of DDIC database tables can be flagged for initial values. On the database, this flag is set to NOT NULL. When a new field is inserted into an existing DDIC database table, this flag can be used on all platforms to force an assignment of the type-dependent initial value to this field in all rows. The flag is always set automatically for key fields.

If a new table field without the property NOT NULL is inserted into an existing table, the field is given a null value in all rows. There is no equivalent to the null value in ABAP. It can only be queried in using the special WHERE condition IS $[NOT$] NULL.

Generally, table fields on most database platforms are created as NOT NULL, even if the flag for the initial value is not set in the ABAP Dictionary. Furthermore, all fields are given the property NOT NULL:

  • When a new table is created

With the exception of key fields on some database platforms, new fields are not created as NOT NULL only if they can be appended or inserted using ALTER TABLE without an adjustment (if the flag is not set in ABAP Dictionary). The NOT NULL definition of a database field can be seen by displaying the database object in the dictionary tool.

If the flag is set for an entire include structure, it only applies to those structure components where the flag is also set and not to all components. If the flag is not set for an include structure, all flags set for the included structure are ignored.

Notes

  • The flag cannot be set for the following data types:
  • LCHR, LRAW, and the obsolete VARC. No initial value is assigned to these data types.

  • NUMC and RAW with a length greater than or equal to 70.

  • GEOM_EWKB

It is possible to set the flag for the data type RAW with a less than 70 even though it is not assigned an initial value.
  • Except when inserting new fields, the indicator is not needed and the initial value is always set, which is especially true for adjusting tables.
  • In tables with many rows, it can take a long time to set the type-dependent initial value and the initial value flag should only be used if absolutely necessary or if the table has a small number of entries.





BAL_S_LOG - Application Log: Log header data   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 3900 Date: 20240419 Time: 065706     sap01-206 ( 36 ms )