System Types Joins

Use this page to Add Table Join Relationships.

To access this page:

  1. Select Common > System Types in the Navigation pane.

  2. Click the Tables icon for a System Type.

  3. Click the Joins icon for a System Type table.

NOTE: Excel Integration has been enabled on this page. Refer to Use Excel Integration for more information.

Field Description
NAME Displays the name of the relationship. For example, Join MARA to MARC (Material to Plants).
LEFT SYSTEM TYPE TABLE ID Displays table on the left side of the join.
RIGHT SYSTEM TYPE TABLE ID Displays table on the right side of the join.
Fields Click the System Types Join Fields page to add, edit and delete fields on the table being joined.
WHERE CLAUSE Displays the Where Clause used for the relationship to apply the join correctly during auto-generation.
COMMENT Displays a user-entered comment about the relationship join.
DSP SUPPLIED