Overview tab

Use this tab to maintain the overall data of a table definition.

General Information
Table
The name of the table, used as table identification code.

A table is uniquely identified by the combination of package code, module code, and table code.

Allowed values:

The table name is read-only. You can only specify a table name when you create a new table definition. Afterwards, you cannot change this name anymore.

Table names must have the following format: <package code><module code><table number>

Package Code 2 letters tt (tools)
Module Code 3 letters adv (application development)
Table number 3-digit number 001 (sequence number of table)
Label Name
The name of the label that contains the table description.

To open the label in the Label Editor, click the hyperlink.

Allowed values:

The label name is read-only. You can only specify a label name when you create a new table definition. Afterwards, you cannot change this name.

Description
The description of the table.
Allowed values:

The description is read-only, because the description text is stored in a label.

To change the description, click the Label Name hyperlink and edit the label in the Label Editor.

Update Ref. Message
The code of the message which appears if a user tries to change the primary key of a record referred to by another table.

To open the message in the Message Editor, click the hyperlink.

Example:

Table pkitm001, Item table, is linked to Update Reference Message pkitmt0001. This message contains the following text:

Item code cannot be changed, item is in use.

Table pksls041, Sales order line, refers to the Item table by its item code. If a user tries to change an item code in the item table, which is used in a sales order line, LN displays the defined reference message.

Delete Ref. Message
The code of the message, which appears if a user tries to delete a record referred to by another table.

To open the message in the Message Editor, click the hyperlink.

Example:

Table pkitm001, Item table, is linked to Delete Reference Message pkitmt0001. This message contains the following text:

Item code cannot be deleted, item is in use.

Table pksls041, Sales order line, refers to the item table by its item code. If a user tries to delete an item code in the item table, which is used in a sales order line, LN displays the defined reference message.

Relation Type
The relation type for the fields in this table.
Note: This indication is important for delayed lock facilities in the bshell. If you use a delayed lock, two users can change one record at the same time. However, they cannot change the same fields or the fields that are related to each other.
Allowed values:

Select one of the following relation types:

No relations All fields of the record are independent. When a user edits a field, another user can edit other fields of the record.
All Fields All fields of a record depend on other fields of this record. When a user edits a field, all fields are locked so other users cannot edit the record.
Specified Relations You can define groups of related fields. Some fields of a record depend on other fields of this record and some fields are independent. When a user edits a field, the related fields are locked. The other fields can be edited by other users.
InContext Model
The name of the InContext model that describes which fields are required for the context messages for this table.

To open the InContext model in the Table InContext Model Editor, click the hyperlink.

If no InContext model exists for the table, click the hyperlink to generate a model. The Table InContext Model Editor is started.

Related topics:
Field Relationships
This section contains the Field-Group records. This indicates which table fields belong to which field groups.

Fields can be arranged into groups to indicate their mutual relationships.

To add a Field-Group record, click Add and specify a group and a field.

To remove a record, right-click a record and select Remove.

Note: This section is only displayed if the Relation Type is Specified Relations.
Group
The identification of a group of related fields.
Allowed values:

A number in the range 0-9999.

Name
The name of the field, which is related to other fields with the same group number.
Allowed values:

Select a field from the list.

Description
The description of the field.

The description is read-only. It is filled automatically when you select a field.

Runtime
Convert: Convert Tables to Runtime
This link is only available if the table is checked in.
Click this link to convert domains and tables to the runtime data dictionary:
  • For LN servers with Enterprise Server 10.5 or later, the Convert to Runtime dialog box is started.
  • For LN servers with older Enterprise Server versions, the Convert to Runtime Data Dictionary (ttadv5215m000) session is started.

    You must be authorized to run this session.

Note: In the Convert to Runtime dialog box or the Convert to Runtime Data Dictionary (ttadv5215m000) session, select the package combination that contains the Project VRC of your current Software Project. Domains and tables in all Activities linked to the software project are converted. Therefore, not only tables in your own Activity VRC are converted, but changed tables in activity VRCs of other developers are also converted. Read the online help of the dialog box or session before you start the conversion. Create: Create Tables This link is only available if the table is checked in. Click this link to create this table for a range of companies: For LN servers with Enterprise Server 10.5 or later, the Create Tables dialog box is started. For LN servers with older Enterprise Server versions, the Create Tables (ttaad4230m000) session is started. You must be authorized to run this session.