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.