PowerExchange for SAP NetWeaver User Guide for PowerCenter

10.5.1
- 10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0

Back Next

Setting the Select Option

You can restrict the number of rows returned from the SAP ECC source table. Configure the Select Option property in the source definition to select either a single row or a distinct set of rows from the source. By default, the Select Option property selects all rows from the source.

The property settings are:

Select All.
Default setting. Select all rows from a source.

Select Single.
Select a single row from a table using open SQL.

Select Distinct.
Select unique values from a table using open SQL or exec SQL.

The following table summarizes select options and the conditions for using them:

ABAP Generation	Select All	Select Single	Select Distinct
Open SQL	Yes	Yes	Yes
Exec SQL	Yes	No	Configure all sources to Select Distinct.
ABAP join syntax	Yes	No	Configure all sources to Select Distinct.
Hierarchy and IDoc definitions	n/a	n/a	n/a