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 |
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
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
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
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
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
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.
More information:
-> Checking for dependent elements
>Delete Flag (action)
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
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
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.
More information:
-> Checking for dependent elements
<Delete Flag
attribute
master attribute for relation (T_ENT_REL)
type, entry
string, entry required
max. no. of characters
1
selection tool
menu
multilingual field
no
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
attribute
master attribute for relation (T_ENT_REL)
type, entry
string, entry optional
max. no. of characters
20
selection tool
no
multilingual field
yes
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
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
Create Ref 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
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)
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