Tag: technology

By creating an implicit join between the Opportunity business component and the S_PARTY table

By using the intersection table S_OPTY_STG

By creating a link between Opportunity and Sales Stage business components

By creating a join from the Opportunity business component to the S_STG table

Name of the join specification object definition must be unique within the join

Destination column is required if the join occurs on a column other than ROW_ID

Source field denotes the name of the field on which the destination table will be joined

The Join Specification specifies the table to be joined

Child business component

Inter table

Destination field

Inter child column

Set the Type Value property on the picklist to the LOV Type as created in S_LST_OF_VAL

Specify the Business Component to be used by the Pick List object

Set the runtime property to TRUE on the control or list column object

Create a Pick Map definition

It requires dedicated space for each child record on a view

Multi-value field is required for an MVG

It is an alternative to a detail view for managing parent and related child records

It cannot be built on M:M relationships

Using Join one can achieve M:M relationship

Explicit Join Fields are read-only

Explicit joins need to be created in Tools

Joins are between two applets

Use Business Objects and Links definitions

Query using the column ‘Foreign Key Table’ in tools

Use Flat Tab

Using Business components and Join definitions

Runs just one query to retrieve parent record and the primary child record

Retrieves all child record in one query

Increases space on the View

Can have zero or more MVF

To eliminate duplicate data

To verify import success

To speed up processing

To truncate EIM tables after import

TBCs provide a way to create task-specific data that can be displayed and edited in the user interface

TBCs are used to house data to control the flow or logic and are cleared when a task is completed

TBC does not stored the data in the database

TBC is based on S_TBC table