Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Business Objects Layer > Business Components >

Intersection Business Components

---

An intersection business component is a business component based on an intersection table. It provides the means to display all of the combinations of data in a many-to-many relationship, instead of only one or the other one-to-many relationship of which it is composed.

Intersection tables implement many-to-many relationships. Some (such as S_OPTY_CON and S_ACCNT_POSTN) also provide intersection data through a join to one or the other master business component that uses the intersection table. Intersection data is data that resides in columns other than the two required foreign key columns in the intersection table, and is specific to the intersection of the two master business components. Intersection data columns are described in Intersection Data in the Intersection Table.

An example of an intersection data column exposed only through a join is the ROLE_CD column in S_OPTY_CON. This column specifies the role of each contact in each opportunity, and is exposed in contact records through the S_OPTY_CON join. Exposure through a join is adequate in many circumstances, namely when the many-to-many relationship only needs to be viewed from the perspective of one or the other master business component. In this example, the purpose of exposing the intersection data column is to identify the role of each contact in a list of contacts for one opportunity.

If it were necessary to view all contacts for all opportunities in a single list, an intersection business component based on the S_OPTY_CON table would be required.

An example of an intersection business component that is exposed in the user interface is Opportunity Product. It is based on the S_REVN table, and used in the applets in the Opportunity Products screen in Siebel Sales, shown in Figure 85.

Figure 85. Opportunity Products Screen

The list applet in this view displays all current opportunity-product combinations. When an intersection business component is used for the display and modification of data in an intersection table, it is not necessary to use an association applet to create new association rows. The user can add a new record in the list applet that displays the intersection business component, and enter or pick values in list columns that specify the two masters. In the case of the opportunity product list, an Opportunity and a Product list column are provided, and selection is made in one or the other, using the corresponding pick applet.

For more information on using intersection business components, see Updating Fields That Are Based on Columns in Extension Tables of Intersection Tables.

Bookshelf Home | Contents | Index | Search | PDF