| # 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. 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. |