How To Fix DT404 - Inconsistent foreign key &-& not inherited

DT404 - Overview

• Message type: E = Error

• Message class: DT - Table activation (incl. indexes)

• Message number: 404

• Message text: Inconsistent foreign key &-& not inherited

What causes this issue?

A foreign key is to be inherited from an included table to the
including table. The foreign key was found to be irreparably
inconsistent.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Check the foreign key definition of the table.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DT404 - Inconsistent foreign key &-& not inherited ?

  The SAP error message DT404 "Inconsistent foreign key &-& not inherited" typically occurs in the context of data modeling, particularly when working with Data Dictionary objects like tables, views, or structures in ABAP Dictionary. This error indicates that there is an inconsistency in the foreign key relationship defined in the database tables.
  
  Cause:
  
  Foreign Key Definition Issues: The foreign key relationship is not properly defined or is inconsistent. This can happen if the foreign key field in the child table does not match the primary key field in the parent table.
  Data Type Mismatch: The data types of the foreign key field and the corresponding primary key field do not match.
  Missing Inheritance: If a table is supposed to inherit a foreign key relationship from a parent table but does not, this error can occur.
  Changes in Table Structure: If the structure of the tables has been changed (e.g., fields added or removed) without properly