Table Relations (ttocm0104m000)

Use this session to maintain the table relations of an object type.

The primary key of the root table identifies an object type. For example, a SalesOrder object is identified by the tdsls400.orno table field. An object may consist of one record, but usually consists of multiple records from multiple tables. This session describes which records belong to an object.

This table shows the components that define each table relation:

Component Corresponding field in this session
The child table Table from
A foreign key field of the child table Field Name
The parent table

The foreign key in the child table refers to the primary key of the parent table.

Table to
A filter expression

A filter expression is mandatory if no hard reference exists in the data model.

Condition

Example

This diagram shows a sample table relation definition of the SalesOrder object type:

This table shows the corresponding relations:

Table from Field Name Table to Condition
tdsls401 orno tdsls400  
tdsls402 orno tdsls400  
tcibd420 prbo tdsls400 prbt=tcprbt.tdsls401

The tcibd420 table has no direct relations to other tables. Through the filter expression prbt=tcprbt.tdsls401 you can validate to which object type a record from tcibd420 belongs.

Field Information

Model

A code to identify the object model.

Standard

This check box indicates whether the model is a standard or a customized model.

You cannot maintain a standard model or its child components, such as actions and table relations.

You can delete a standard model if it is not deployed.

Object Type

A code to identify the object type.

Line

ID to uniquely identify a table relation of an object type.

Table from

The child table.

Field Name

The foreign key field of the child table.

Table to

The parent table.

Condition

The filter expression of the table relation.

A condition is mandatory if no hard reference exists in the data model.

Company field from

The code of the table field, in the child table, which contains a company number.

Standard

This check box indicates whether the relation is a standard or a customized relation.

If you copy a model from a standard model, the relations in the new model are standard; the new model itself is not standard.

If you modify or create a relation, the Standard check box is automatically cleared.

Note: If you change the attributes back to the standard definition, the Standard check box stays cleared.