SAP DDIC DATABASE TABLES CHECKTAB



Get Example source ABAP code based on a different SAP table
  



ABAP_DDIC - Check Table
Table fields of a DDIC database table whose data type is determined by a DDIC data element can be assigned a check table. The value table of any DDIC domain of the data element is used as a default value. A table field to which a check table is assigned is called a foreign key field and becomes a part of the foreign key of the table. The table itself becomes a foreign key table. The primary key of the check table is the foreign key of the foreign key table. Each key field of the check table corresponds to a field in the foreign key table. The corresponding field pairs must have the same data type.



Latest notes:

Fields whose data type is specified directly (not by using a DDIC data element) cannot be assigned a check table.
As long as a DDIC database table is a check table, none of its key fields can be deleted and the order of the key fields cannot be modified.
As long as a DDIC database table is a check table, its primary key can be expanded only by appending new key fields to its end. The existing foreign keys then automatically become generic regarding the new key fields.
A client field cannot be inserted later into an existing check table.
NON_V5_HINTS
A special column can be used to flag obsolete data in check tables.
ABAP_HINT_END