Title

Description

Relation

Displays and allows editing of basic relation information:

●      Type – when opened displays the relation type as shown in the relation matrix of the Relationship Editor. The type automatically changes to manual as soon as a change is made to the relation.

●      Relation Name – field displaying the name of the current relation. Open the drop-down list in the event of multiple relations between the two objects, and choose the desired relation.

Use the buttons at the top of this section as follows:

●      New – creation of new relations between the current objects

●      Rename – if desired, renaming of relations as convenient

●      Delete – deletion of the current relation

●      Reset – clearing of all modifications done in the entire editor and reverting the direct relation, as derived from the back-end application.

This button is active only for relations for which the source and target objects have a direct relation, even if that relation is currently in the background, having been deleted.

In the event of multiple relations, select or clear the Default Relation checkbox at the bottom of the section to specify whether or not the selected relation is the default.

Object-Alias Map

A table in which aliases are mapped to instances of business objects from which data is returned. A single object may have a number of aliases, depending on the number of times instances of that object are used.

Each instance of each object involved in the relation, is mapped to its own unique alias. Each instance is equivalent to an instance of the object in the FROM clause of a query.

The columns of the table are as follows:

●      Selection column with radio button for each row

●      Type – containing an icon indicating the role played by the object instance in the relation. The type refers to:

○       source – the object from which the relation begins

A, in an A to B relation

○       target – the destination object of a relation

B, in an A to B relation

○       bridge – an intermediary object needed to complete a relation

B, in an A to B, B to C relation (A to C via B)

●      Set – specifies that the selected instance is set as the representative alias (represents the object for the purpose of relation resolving).

If more than one instances of the source and/or target objects exist, it is the responsibility of the content administrator to select as representative the most relevant instance.

●      Object – containing the object name of the specific instance

●      Alias – containing an unique identifier for the object instance

Below the table are the following buttons:

●      Add Alias – adds an additional instance of  business object for the one displayed in the currently selected row of the table. The alias of the newly created object instance is generated automatically.

●      Remove Alias – removes the selected object instance

●      Set as Representative Alias

Source, bridge, and target representative aliases:

During runtime, it is the representative source instance, in the first of a series of relationships, that will be filtered according to the dragged value.

The representative target instance, in the last of a series of relationships, determines the object from which the output fields in the Select clause will be taken, in the event of pure SQL. Although in some cases, the parameters of a specific iView may determine the output fields, regardless of the representative alias.

The first or last in a series of relationships may refer to the first or last relation in a single direct relation.

Adding a bridge object:

Right-click on a business object in the Business Object folder of the Portal Content Catalog, and choose Add to Object-Alias Map.

Relation Condition

A set of drop-down selection fields in a row, representing a relation expression:

●      a source object selection field listing all the object contained in the object‑alias map

●      an attribute field for selecting a property of the preceding source object

●      an operator selection field

●      a target object selection field listing all the object contained in the object‑alias map

●      an attribute field for selecting a property of the preceding target object

Use the Add button to the right of the selection fields to add conditions to the relation expression in the text field located at the bottom of the editor.

The text field:

The actual relation condition, or WHERE clause of the query, is determined by the contents of the text area below the row of selection fields. The selection fields are a convenience for adding conditions automatically, as are the buttons for parentheses and And, located to the right of the text field.

The text area may be edited manually as well. You may use expressions for adding functions not covered by the tools of the editor, although functions used must be supported by the SAP connector. See SAP Connector: Supported Capabilities.

The text area can be a powerful and flexible tool. For more information on the use of expressions, see the section "Editing Queries" below.