Common

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.

SYSTEM SUPPLIED

If checked, this content is installed with the Stewardship Tier and cannot be edited.

If unchecked, the content was added by a user or process.

NOTE: This is a display-only check box. It cannot be updated.