Table Definitions (ttadv4120s000)
Use this session to maintain tables in a package VRC. A table is used to store data in the database. The fields of a table identify which data is stored.
Field Information
- Package
-
The table's package code.
- VRC
-
The package version code for which the table is defined.
- VRC
-
The release of the package for which the table is defined.
- VRC
-
The customer extension of the package for which the table is defined.
Note: The customer extension is only relevant for customized software. - Module
-
The module code to which the table belongs.
- Table
-
The table identification code.
A table is uniquely identified by the combination of package code, module code, and table code.
- Date
-
The date.
- User
-
The name or initials of the designer who created the table definitions.
- User
-
The name of the Tools user.
- Update Ref. Message
-
Select the message code, which appears if a user tries to change the primary key to which another table refers. For example Table: pkitm001 Item table Reference message update: pkitmt0001 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 the item code in the item table, which is used in a sales order line, Tools gives the defined reference message.
- Delete Ref. Message
-
The message code, which appears if a user tries to delete the primary key referred to by another table. For example Table: pkitm001 Item table Reference message delete: pkitmt0001 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 the item code in the item table, which is used in a sales order line, Tools 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. Notice that they cannot change the same fields or the fields that are related to each other. - Expired
-
If this check box is selected, the table has expired for this package VRC and its derivatives.
- Tech.Documentation
-
If this check box is selected, documentation is available for the table.
- Release Notes
-
If this check box is selected, release notes are available for the table.