Diagnosis It is not fully possible to define of the foreign key. When definingthe foreign key, a foreign key field must be assigned to each primarykey field of the check table or a field must explicitly be assigned aconstant or excluded from the check. The assignment in the check field uses the common domains of the pairof fields. The ABAP Dictionary data type and the length must beconsistent for all other pairs of fields. System Response The system automatically attempted to make a suggestion for thisassignment. However, the corresponding fields of the table to bechecked could not be assigned to all the primary key fields. Procedure In order to activate a table with foreign keys, the assignment of checkfields and foreign key fields must be complete. The missing fieldassignments must be maintained manually, whereby the fields to bechecked can come from a foreign table as well as from the table itself. Constants can also be used for the missing field assignments or thefield can be removed explicitly from the assignment to the key fieldsof the check table (generic foreign key). In this case the check isonly made against the remaining fields. |