BC030_2.04.1

Foreign Key Relationships

BC030_2.04.2

Objectives

•

The participants will be able to:

–

Define a Foreign Key and explain its usage

–

Explain the prerequisites for constructing
Foreign Key relationships

BC030_2.04.3

Definition of Foreign Keys

BC030_2.04.4

Uses of Foreign Keys

•

Maintain data integrity

•

Provide help texts

•

Create aggregate dictionary objects

BC030_2.04.5

Prerequisites for Constructing

Foreign Key Relationships

•

The Foreign Key Field and the primary key of the
Check Table

must

share the same domain.

BC030_2.04.6

Check Table

Check Table

Value Table

Value Table

Foreign Keys: Key Terminology

Foreign Key Table

Foreign Key Table

BC030_2.04.7

Check

Table

Valu

e

Tabl

e

Foreign Key Terminology:

Check Table / Value Table

can be

the
same

BC030_2.04.8

Foreign Key Terminology:

Check Table  Value Table

Check

Table

Valu

e

Tabl

e

BC030_2.04.9

Data

Dictionary

Establishing a Foreign Key

Relationship in the ABAP Dictionary

BC030_2.04.10

Creating a Foreign Key

Relationship

Foreign Key
Pushbutton

BC030_2.04.11

Maintaining a Foreign Key

Relationship’s Attributes

Enter a Short
Text

Maintain the Foreign Key
Type

Maintain Cardinality
n:m

BC030_2.04.12

Summary

•

The participants should be able to:

–

Define a Foreign Key and explain its usage

–

Explain the prerequisites for constructing
Foreign Key relationships