Table Selection

With the properties and hooks that are defined for the extension type Table Selection, you can include fields from the selected table. The included fields are displayed and read-only.

When you add a Table Selection, you have two options:

• Referenced Table
• Other Table

If you choose Referenced Table, you can select tables that are linked to the main table of the session. This can be a multilevel reference. For example, for a Business Partner, you can make a reference to the Language of the Country of the Address of the Business Partner.

You can select the same Referenced Table multiple times, but only if the reference path to that table is different. For example, you can reference to a Language from the Business Partner directly, but also by the Country of the Address of the Business Partner. In this case, automatically a new Sequence Number is assigned to the Table Selection.

If you choose Other Table, you can select any other table. In this case, you must specify the query part to join with this table yourself. Note that this is always handled as an inner join. Ensure that the record in the other table exists, otherwise the record of the main table is not displayed. If you cannot ensure that the record in the other table exists, do not use the Table Selection. Use a Calculated Field with the Nested Select option.

See Select property.

This table shows the available properties: