Bookshelf v7.5: Verifying That a Field Can Be Used in a Mapping

Pricing Administration Guide > Using Mappings in Pricing Factors > The Process of Setting Up a Pricing Factor with a Mapping >

Verifying That a Field Can Be Used in a Mapping

A mapping's search specification, in either the Pricing Mapping list or the Pricing Mapping Definition list, refers to a business component field. The business component field must fit the following conditions for the pricing factor to execute successfully:

The business component must have been defined explicitly in Siebel Tools.

If the business component contains an entry in the Join field for the extension tables with the business component base table, then certain additional conditions, described in the following procedure, must be met. The business component must contain an entry in the Join field for the extension tables with the business component base table.

To verify that a field can be used in a mapping

Open Siebel Tools.

In the Object Explorer view, choose Siebel Objects > Business Component.

Select the business component for the field to be checked.

For example, for the List Price field, select the PriceList business component.

In the Object Explorer list, choose Siebel Objects > Business Components > Fields.

The Fields list appears, showing information about the selected business component.

Note the table named in the Join field:

If the table name in the Join column ends in _X or _XM (such as the Area Code field in the example described in Example: A Mapping Based on the Opportunity Business Component), or if it is not specified in the Join column at all, (such as Currency Code in the example), you can use the business component field in a mapping. In either case, you do not need to complete this procedure.

If the Join field contains a table name that does not end in _X or _XM (such as List Price and the S_PRI_LST_ITEM table or Payment Term and the S_PAYMENT_TERM table), complete this procedure before continuing with the mapping definition.

In the Object Explorer view, choose Siebel Object > Business Component > Join.

Examine the Tables field in the Joins list:

If the table noted in Step 5 appears in the list, you can use the business component field in the mapping. In the example described in Example: A Mapping Based on the Opportunity Business Component, the table S_PAYMENT_TERM is listed in the Table column and can be used.

If the table noted in Step 5 does not appear in the list, you cannot use the business component field in the mapping. In the example, the table S_PRI_LST_ITEM is not listed in the Table column and cannot be used.