4. Foreign Key Relationships

Question 1

Foreign Key Relationships

Answer 1

Is a field (or combination of fields) that represents the primary key of another table. Relationships between tables are represented in the ABAP Dictionary by foreign keys.

Question 2

Foreign Key Table

Answer 2

The table that contains the foreign key fields

Question 3

Value Table

Answer 3

The table containing the set of allowed values attached to a domain.

Question 4

Check Table

Answer 4

The table that is referenced by a foreign key. A check table is either identical to a value table, or is another table containing a subset of the records in a value table.

Question 5

Field-By-Field Assignment

Answer 5

When performing a field-by-field assignment, all key fields in the check table are used to determine valid entries in the foreign key table.

Question 6

Partial Foreign Keys

Answer 6

When creating a partial foreign key, certain fields are flagged as generic. These fields are ignored by the system when validating records that are inserted into the foreign key table.

Question 7

Constant Foreign Keys

Answer 7

When creating a constant foreign key, certain fields are assigned a literal value. Only records in the check table with that value in the corresponding field are used to determine whether records in the foreign key table are valid.