Common

System Types Joins

Use this page to Add Table Join Relationships.

To access this page:

  1. Click Common > System Types in Navigation pane.

  2. Click Tables icon for a System Type.

  3. Click Joins icon for System Type table.

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

If checked, this content is installed with the platform 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.