How To Fix MC755 - Les jointures doivent être définies par clé externe

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 755

• Message text: Les jointures doivent être définies par clé externe

Quelle est la cause de ce problème?

Join conditions were freely defined for a view. The current view type,
however, only permits joins which were defined with foreign key.
Tables containing no join conditions are also not allowed.

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

Réponse du système

Comment corriger cette erreur?

Normally the ABAP/4 Dictionary only permits the entry of freely defined
join conditions for database views. The current situation occurred due
to the change in the view type.
Choose the base tables with a foreign key relationship for all views
except for database views. The foreign key relationship is then used as
the join definition.
&NOTE&
The information that the join might have been derived from a
foreign key is not stored for database views. In this case you should
remove all the tables except for one. Use the 'Relationships' function
to include the tables after successfully converting the view type.

Extrait du message d'erreur du système SAP. Copyright SAP SE.