How To Fix MC505 - Bitte Fremdschlüssel &-& für Join-Operation korrekt definieren

SAP Error Message - Details

• Message type: E = Error

• Message class: MC - Aggregate: views, matchcodes, lock objects

• Message number: 505

• Message text: Bitte Fremdschlüssel &-& für Join-Operation korrekt definieren

Was verursacht dieses Problem?

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.

Systemantwort

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Wie behebe ich diesen Fehler?

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.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE