| 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:
- 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 following standard methods
exist. LN can generate
these methods, or else you can define them with the specified
properties. Properties of standard methods that operate on reference
tablesMethod | 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. | 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 three-digit code of the table. Description The description of the table. | |