Refine Relation/Aggregate Relation

These sublists are used to create and manage relations to and from the current entity.

Entity Name Name of the relation's child entity
View name of the relation between the entities
Table Name name of the relation's database table
Refine List name of the relation's default refine list
Aggregate List name of the relation's default aggregate list
>Check Value controls the deletion of records in the parent table
>Delete Flag controls the child entity's behavior when records are deleted from the relation table
<Check Value controls the deletion of records in the child table
<Delete Flag controls the parent entity's behavior when records are deleted from the relation table
Object Title the relation's title
Comments comments on the relation record

Shift makes child entity the current entity
Create Ref List creates the relation's default refine list
Create Agg List creates the relation's default aggregate list
Relation Access opens the relation's access privileges form

Entity Name

Name of Entity 2, the relationship's child entity

attribute master attribute for entity (T_ENTITY)
type, entry string, entry required
max. no. of characters 20
selection tool modally window (list with entities already created)
multilingual field no

Entity 2 is the entity to which the relation points. Take care that it is not represented as a foreign table or foreign view. You can only enter (or select in the dialog) existing entities.

View

Name of the relation between the entities

attribute master attribute for relation (T_ENT_REL)
type, entry string, entry required
max. no. of characters 20
selection tool no
multilingual field no

The View is the unique ID for the relation. You need it to identify a specific relation between two entities when there is more than one.

You can alter the View after the record has been saved, but not if the database table and the refine or aggregate list have already been created. In this case, you need to delete these objects first.

Table

Name of the relation's database table

attribute master attribute for relation (T_T_ENT_REL)
type, entry string, no special characters, entry required
max. no. of characters 13
selection tool no
multilingual field no
hyperlink opens the related record of the registered table in the Relation Data form

After editing the relation record, you first need to create the table fields for the relation's attributes. Then you can physically create the table in the database.

Refine List

Name of the relation's default refine list

attribute master attribute for relation (T_ENT_REL)
type, entry string, specification optional
max. no. of characters 20
selection tool menu with existing lists and forms
multilingual field no
hyperlink opens the registered list in an own form

The default list can only be created when you already have a database table for the relation. The list contains the child entity's significant master attribute fields and the relation attribute fields. The default list record and its field assignment can then be found in the Mask Data form, and can be used as a template for other lists.

Note! Once a default list has been created, it cannot be overwritten by creating it again. You first need to delete it from the Mask Data form. The Field Selection menu lists all the lists and forms which already exist.

Aggregate List

Name of the relation's default aggregate list

attribute master attribute for relation (T_ENT_REL)
type, entry string, specification optional
max. no. of characters 20
selection tool menu with existing lists and forms
multilingual field no
hyperlink opens the registered list in an oewn form

The default list can only be created when you already have a database table for the relation. The list contains the parent entity's significant master attribute fields and the relation attribute fields. The default list record and its field assignment can then be found in the Mask Data form, and can be used as a template for other lists.

Note! Once a default list has been created, it cannot be overwritten by creating it again. You first need to delete it from the Mask Data form. The Field Selection menu displays all the lists and forms which already exist.

>Check Value

Value tested against the number of dependent master records in Entity 2 when dependent master records are deleted in Entity 1.

attribute master attribute for relation (T_ENT_REL)
type, entry Integer, entry required
max. no. of characters 3
selection tool no
multilingual field no

The Check Value determines when the user can delete a record from the parent entity's master table which is linked to records in the child entity's master table. If the number of linked records in the child entity's master table is smaller than the Check Value, the record can be deleted from parent entity's master table.

Entry:

0
deletion always possible

n
deletion only possible if the number of dependent child records in the master table is lower than n

More information: -> Checking for dependent elements

>Delete Flag (action)

Controls the behavior of the child entity's master table when records are deleted from the Refine List (relation table).

attribute master attribute for relation (T_ENT_REL)
type, entry string, entry required
max. no. of characters 1
selection tool menu with possible actions
multilingual field no

Entry:

- (default)
associated record in the child table is not deleted

D (delete)
DataView deletes dependent child records in Entity 2's master table

When master tables are linked to themselves (e.g. to display item or usage lists), entire structures could be deleted recursively. For safety's sake, DataView moves anything deleted recursively to the trash first.

More information: -> Deleting dependent elements automatically

<Check Value

Value tested against the number of dependent master records in Entity 1 when dependent master records are deleted in Entity 2.

attribute master attribute for relation (T_ENT_REL)
type, entry Integer, entry required
max. no. of characters 3
selection tool no
multilingual field no

The Check Value determines when the user can delete a record from the child entity's master table which is linked to records in the parent entity's master table. If the number of linked records in the parent entity's master table is smaller than the Check Value, the record can be deleted from child entity's master table.

Entry:

0
deletion always possible

n
deletion only possible if the number of dependent child records in Entity 1's master table is lower than n

More information: -> Checking for dependent elements

<Delete Flag

Controls the behavior of the parent entity's master table when records are deleted from the Aggregate List (relation table).

attribute master attribute for relation (T_ENT_REL)
type, entry string, entry required
max. no. of characters 1
selection tool menu
multilingual field no

Entry:

- (default)
associated record in the child table is not deleted

D (delete)
associated record in child table is not deleted

When master tables are linked to themselves (e.g. to display item or usage lists), entire structures could be deleted recursively. For safety's sake, DataView moves anything deleted recursively to the trash first.

More information: -> Deleting dependent elements automatically

Object Title

The relation's title

attribute master attribute for relation (T_ENT_REL)
type, entry string, entry optional
max. no. of characters 20
selection tool no
multilingual field yes

The title is used in error messages.

Note! You should always give your objects a title. If you don't, error messages will only contain the object's key, and you won't be able to find the object in a Search mask.

Comments

Comments on the relation record

attribute master attribute for relation (T_ENT_REL)
type, entry string, entry optional
max. no. of characters 255
selection tool no
multilingual field no

Shift

Opens the child entity's Entity Data form

Create Ref List

Creates the relation's default refine list

You can create the default list as soon as the relation has a master table (Create Table in the Relation Data form).

The default list holds the significant master attribute fields for the child entity fields and the relation attribute fields. The default list record and its field assignment can be found in the Mask Data form, and can be used as a template for other lists.

Note! Once a default list has been created, it cannot be overwritten by creating a new one. You first need to delete it from the Mask Data form.

Create Agg List

Creates the relation's default aggregate list

You can create the default list as soon as the relation has a master table (Create Table in the Relation Data form).

The default list holds the significant master attribute fields for the parent entity fields and the relation attribute fields. The default list record and its field assignment can be found in the Mask Data form, and can be used as a template for other lists.

Note! Once a default list has been created, it cannot be overwritten by creating a new one. You first need to delete it from the Mask Data form.

Access (menu only)

Opens the form for modifying access privileges (extends the standard Access function).

This function extends the scope of the standard Access function. Access privileges apply not only to the relation object, but also to all lists and forms which refer to it (i.e. every mask which the application calls with userexits such as iwf_lis_ref, iwf_lis_agg,...). For example, users with access to the masks may only edit records in them if they have also been granted access to the relation object.

More information: -> Access to records