5.1.11

SAP Note 17161 - Foreign key from included tables

Symptom:

The following error messages referring to foreign keys from included tables occur during activation: W AD280 Frd. &-&: Check table & is not transitive re. value tables
E AD274 Frd. &-&: & and & refer to different domains

Cause and prerequisites

In earlier versions, foreign keys were included once and were then handled like the foreign keys of the including tables. This means that changes to the foreign keys of the included table did not affect the including table.
As of Release 3.0, you can determine in the including table whether changes to the foreign key of an included table should be inherited by the including table or not. The inheritance is switched on as a default.
However, for reasons of upward compatibility, all existing foreign keys must be considered as "not inherited".

Solution
The best thing is to check all foreign keys of the affected table to see whether they would be better as "inherited" foreign keys.
To do this, dissolve the sub-structure in the table maintenance where the check field is located. Then switch on the flag "Inherited from the included sub-structure" in foreign key maintenance. The foreign key of the sub-structure will then be copied immediately, and future changes to the included key will affect the including keys.
Important: the display of the check table has not been corrected yet. This only involves an error in the display, however. Once you save and call the sub-structure again, the display of the check table will be corrected.

No comments:

Post a Comment