How To Fix E2184 - Foreign key &-& can only be changed in included table

E2184 - Overview

• Message type: E = Error

• Message class: E2 - DE Data Dictionary

• Message number: 184

• Message text: Foreign key &-& can only be changed in included table

What causes this issue?

You switched in change mode to a foreign key for an included table in
name range CI_ (or SI_) or an append structure.

System Response

The foreign key is only displayed. It cannot be changed.

How to fix this error?

Only change foreign keys for such structures in the structure itself.
The change then affects the included tables as well.
In general it is possible to define the included foreign key in the
included table differently from the included table.
The special cases described above can however be seen as
application-specific or customer-specific elements of a table,
which should avoid modifying the standard table. Foreign key
maintenance in the standard table would however be a modification.

Error message extract from SAP system. Copyright SAP SE.

E2184 - Details

• The SAP error message E2184, which states "Foreign key &-& can only be changed in included table," typically occurs when you are trying to modify a foreign key relationship in a way that is not allowed by the system's data integrity rules. This error is often encountered in the context of data modeling or database table maintenance, particularly when dealing with transparent tables and their relationships.
  
  Cause:
  
  
  Foreign Key Constraints: The error indicates that you are attempting to change a foreign key field in a table that is not the primary table for that foreign key relationship. In SAP, foreign keys are defined in a way that they must be maintained in the table where they are originally defined.
  
  
  Included Tables: If you are working with a structure that includes multiple tables (like a table with a structure that includes fields from other tables), the foreign key must be modified in the table