SAP ABAP Message Class E2 Message Number 455 (No suitable relationships defined for the tables)

☛

SAP_BASIS (Software Component) SAP Basis Component
⤷

BC-DWB-DIC-ED (Application Component) Dictionary Maintenance
⤷

SEDD (Package) DDIC Editor

Message class	E2
Short Description	DE Data Dictionary
Message Number	455
Documentation status		Space: object requires documentation
Authorization check Error Message
Changed On	20130531

No suitable relationships defined for the tables

Diagnosis

All tables that are inserted in a lock object have to be linked to each other by foreign key. There are a number of restrictions for the links:

The foreign key relationships of the tables of the lock object must form a tree. The tables are the nodes of the tree. The links of the tree mean "are the check table for".
The foreign key fields must be key fields of the foreign key table.
The foreign key relationships defined between the base tables of the lock object for a field of one of the base tables may be checked against more than one other field. A field therefore may neither occur twice as foreign key field in a relationship nor may it be checked against two differenet fields in two different foreign key relationships.
There is a restriction for cross-structure foreign keys. If a field is assigned to a field lying outside the check table, the table from which this field originates must lie in a sub-tree that has the check table of this foreign key relationship as root.

System Response

Based on the defined relationships, no more tables may be added.

Define suitable foreign key relationships for the tables you use.

Last changed on/by		20140121	SAP
SAP Release Created in