Define foreign key &-& for join operation correctly

What causes this issue?

The foreign key relationship between two tables linked in a view is
incorrect.
Normally, the ABAP/4 Dictionary allows only allows base tables to be
linked to a view if a foreign key exists between the
tables and all foreign key fields originate from the base table.
If a foreign key relationship is changed later, there may be an
inconsistency between the view definition and the active foreign key
relationships.

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?

Define the foreign key so that all foreign key fields are fields of
the table. If this is not possible, enter an '*' (partial foreign
key) or a constant enclosed in apostrophes (constant foreign key)
in place of the table name.

Error message extract from SAP system. Copyright SAP SE.