Table Fields (ttadv4522m000)

Use this session to maintain the input fields which belong to the table definition.

Use the appropriate menu to:

  • Renumber the fields of the table.
  • Maintain labels in the Labels (ttadv1140m000) session, starting at the code of the current table field.
  • Insert a field before the marked table field.
Table

The code of the package for which the table is defined.

Table

The code of the module for which the table is defined.

Table

The identification code of the table.

Note: A table is uniquely identified by the combination of package code, module code and table identification code.
VRC

The version code of the package for which the table is defined.

VRC

The release code of the package for which the table is defined.

VRC

The customer extension of the package for which the table is defined.

Note: It is only relevant in case of customized software.
No.

The field number determines the sequence of the fields in the table definition.

Note: An index can be optimized by some database drivers (ISAM) if the parts of the index are adjacent (as index parts and table fields) and have data type string, byte or enumerate. An optimized index will speed up searching.
Field

Specifies the name of the field which can be used in forms, reports and in scripts in the following way: <table name>.<field name> The field name must be unique within the table.

Example

table : pksls040 (package - module - table number) field name: orno The field can be referred to by using pksls040.orno.

Comb.

If this check box is selected, the field is combined. A combined field consists of two or more normal (not combined) fields. The child fields of a combined field can be maintained by the Child Fields by Combined Field (ttadv4523m000) session.

Note: A combined field can be used for references and indices.
Domain

Specifies the package code of the domain of the table field.

Domain

Specifies the domain of the table field that defines the data type and several characteristics of the field.

Note: If the table field is a combined field, no domain can be given.
Data Type

Specifies the internal representation of data.

Length

If the data type of the domain is string, this field specifies the length in characters. If the data type is multi-byte string, this field specifies the number of positions on which the characters can be placed.

Related Label/Description

The code of the label which is used as a description of the table field.

Note: This field can only be accessed if the Label Description field is empty.