65 / 577
65
PUBLIC
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ
Defining Table Join Types and Cardinality
Joining Tables
Inner Join
Returns rows when there is at least one match in both tables. Combines
records from the left and right table exactly when the specified criteria are
met. If the criteria are not met, no record is created in the result set.
Left (Right)
Outer Join
Returns all rows from the left (right) table, even if there are no matches in the
right (left) table. If records match, they are combined, otherwise the columns
are empty.
Referential Join
Text Join
n..1
1..1
n..m
Used to join a multilingual description table to a master data table (e.g. Material_ID
Description). The text join always filters on one language, and thus one needs to specify a
language column in the text table. The language is filtered based on the view settings (per
default taken from the user profile)
Semantically an inner join that assumes that referential integrity is given, that is, joining of
tables with primary keys and corresponding foreign keys.