Type Relation

You use the Type Relation form to create and manage type relations to the current entity.

Type Name name of the entity's type
Table name of the type's database table
Default List name of the type's default list
Default Form Name of the type's default form
Check Value controls the deletion of records in the master table
Object Title the type's title
Comments comments on the type relation

Create List creates the type's default type list
Create Form creates the type's default type form
Type Access opens the type's access privileges form

Type Name

Name of the entity's type

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

The Name is the type's unique ID in the application's data model.

The type name can be modified after the record has been saved, but not if the database tables or the default list or form have already been created. In this case, these objects must be deleted first.

Table

Name of the type's database table

attribute master attribute for type (T_ENT_TYP)
type, entry string, no special characters, entry required
max. no. of characters 13
selection tool no
multilingual field no
hypertext opens the type record of the registered table in an own form

After editing the type record, you create the table fields for the type attributes. then you can physically create the table in the database.

Default List

Name of the type's default list

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

The default list can only be created when you already have a table for the type in the database. The list contains the entity's master 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. You first need to delete it from the Mask Data form. The Field Selection menu displays all the lists and forms which already exist.

Default Form

Name of the type's default form

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

The default form can only be created when you already have a table for the type in the database. The form contains the entity's master attribute fields. The default form 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. 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 records in the type table when a record is deleted from the entity's master table

attribute master attribute for type (T_ENT_TYP)
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 master table with a type relation. If the number of linked records in the type table is smaller than the Check Value, the record can be deleted from the master table.

Entry:

0
deletion always possible

n
deletion only possible if the number of dependent type records in the associated type table is lower than n (if the relation is to the null entity, the number of relation records in the relation table must be less than n).

More information: -> Checking for dependent elements

Object Title

The type's title

attribute master attribute for type (T_ENT_TYP)
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 type record

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

Create List

Creates the type's default type list

You can create the default list as soon as the type relation has table in the database (use Create Table in the Entity Type form).

The default list holds the entity's significant master attribute fields and the additional 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 Form

Creates the type's default type list

You can create the default form as soon as the type relation has table in the database (use Create Table in the Entity Type form).

The default form holds the entity's significant master attribute fields and the additional attribute fields in a default layout. The default form 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 form has been created, it cannot be overwritten by creating a new one. You first need to delete it from the Mask Data form.

Type 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 type 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_typ, iwf_frm_typ,...). For example, users with access to the masks may only edit records in them if they have also been granted access to the type relation object.

More information: -> Access to records