A Business Component Can Reference Data from a Joined Table

A business component can reference data from an extension table and a joined table. A party business component is a business component that references the S_PARTY table as the base table. The main data for a party business component comes from a joined table. A join defines the relationship that exists between the business component and the additional table. For more information, see How the S_Party Table Controls Access.

A joined table provides rows on a one-to-one basis to the business component. The foreign key relationship that exists between the joined table and the base table of the business component creates this basis. For every record in the business component that corresponds to a row in the base table, a corresponding row can exist in the joined table. Every record in the base table does not include a record in the joined table.

The following figure shows how fields in a business component (Primary Key, Field F1, Field F2, Field F3, Field F4) can reference columns in a base table (Primary Key Column, Column B1, Column B2, Column B3 Foreign Key) and a joined table (Primary Key Columns, Column J1, Column J2). In this figure:

• Primary Key references Primary Key Column, Field F1 references Column B1, and Field F2 references Column B2.

• Field F3 references Column J1 and Field F4 references Column J2.

• Column B3 (Foreign Key) in Base table references Primary Key Column in Joined table.