Datasheet
the ImPlementAtIon guIde (Img) 23
TIP
In relational databases, a key eld is a unique identier for a table. This eld is
used as a reference to the same data in other tables. For example, your employer uses
your Social Security number as a unique identier for information about you. Rather
than listing all the relevant statistics about you in every table, a relational database con-
nects the various kinds of information through a single key eld that represents “you.”
A foreign eld is another sort of key eld, but it’s the key eld for a “foreign” table. For
example, say your employer needs a table containing names and addresses. In this table,
the key eld might be the last name of the employee. The last name would certainly also
be referenced in a table containing Social Security numbers, but it would be a foreign key
there—used only to verify that two people with the same last name stay unique as enti-
ties in the various tables.
The Data Browser and Common Tables to Display
e Data Browser is a useful tool for displaying data table contents. Transaction
SE12 is used to display the structure of a table, and the Data Browser, which is run
via transaction code SE16, displays the contents of a table. Figure 1.12 shows the
conguration screen for creating a company code. e same detail can be viewed
through SE16 by using table T001. e dierence between these two options will be
how SAP presents the data in a conguration screen, oen linking more than one
table to the screen presented.
FIgurE 1.12 Creating a new company code conguration screen
Figure 1.13 shows the results of running transaction code SE16 and entering BSEG
as the table name. You can choose from the listing of options for narrowing the
results that you would like returned to you.
23288c01.indd 23 2/19/09 10:55:36 PM