Tables (ttadv7111m000)

Use this session to define which tables are related to a business object or to a business object component.

Only use this session for business objects/components that are Based on "DAL 2/Table". Do not define tables for business objects/components that are based on "FS/Session".

The tables you define serve several purposes.

  • The root table contains the primary key of the business object or component.
  • The reference table stores references from an external application to the current business object. A business object instance for which references exist cannot be deleted.
  • The other tables are tables that store data of the business object and refer to the root table.
Note: 
  • If a business object contains components, the tables must be defined in the components.
  • You can select tables that do not occur in the package and module of the business object.
  • You must define one root table per business object or component.
  • You can define only one reference table per business object or component.
  • If you do not define a reference table, it will not be possible to generate standard methods to update or delete external references.
  • For a reference table, you can enter a table definition code that does not yet exist. The table definition for reference tables is fully standardized. Therefore, you can generate this table definition when you convert the BOR model to run time through the Convert BOR to Runtime (tlbct1210m000) session.
  • It is not allowed to change the table definition for reference tables manually.

Reference Tables

Several protected attributes are required to operate on reference tables.

To operate on reference tables, the following conditions must be met:

  • The following standard methods must exist:
    • CreateRef
    • DeleteRef
  • These methods require the following attributes:
    • The identifying attributes of the business object or business object component.
  • These methods and attributes must exist both in the public and the protected layer of the business object or business object component.

Reference Tables

To operate on reference tables, the CreateRef and DeleteRef standard methods exist.

This table shows the properties of CreateRef and DeleteRef:

Method Required Arguments Input/Output Mandatory
CreateRef
  • All arguments that are mapped to the identifying attributes of the business object or component.
Input All arguments are mandatory.
DeleteRef
  • All arguments that are mapped to the identifying attributes of the business object or component.
Input All arguments are mandatory.

LN can generate these methods, or else you can define them with the specified properties.

Field Information

Root Table

If this check box is selected, the table is a root table.

It is mandatory to define a root table for each business object or component.

The root table has the following characteristics:

  • It contains the primary key of the business object.
  • The other tables contain references to this table.
Reference Table

If this check box is selected, the table is a reference table.

The reference table stores references to business objects instances. A business object instance for which references exist cannot be deleted.

You can define only one reference table per business object or component. If you do not define a reference table, it will not be possible to generate standard methods to update or delete external references.

For a reference table, you can enter a table definition code that does not yet exist. The table definition for reference tables is fully standardized. Therefore, you can generate this table definition when you convert the BOR model to run time through the Convert BOR to Runtime (tlbct1210m000) session. It is not allowed to change the table definition for reference tables manually.

Table

The package code of the table.

Table

The module code of the table.

Table

The three-digit code of the table.

Description

The description of the table.