WebSphere Adapter for SAP Software

Selecting business objects and services

To query data on the SAP server, specify search criteria that the enterprise service discovery wizard uses to find the data on the server.

  1. From the Find and Discover Enterprise Services window, begin the process of searching for services by clicking Execute Query.
  2. Expand SQI and click Discover By Name.

    The Filter button is now enabled.

  3. Click Filter.
  4. Select the KNA1 table.
    1. In the Filter Properties for Discover By Name window, type KNA1. Then click OK.
    2. Expand Discover By Name (filtered).
      Figure 1. The Find and Discover Enterprise Services window
      A screen capture of the Find and Discover Enterprise Services window, showing the KNA1 object.
    3. Select KNA1 and click Add to import list.
    4. In the Configuration Parameters for KNA1 window, accept the defaults by clicking OK.
      Figure 2. The Configuration Parameters window, which you leave blank to accept the defaults
      A screen capture of the Configuration Parameters for KNA1 window.
  5. Click Discover By Name (filtered) and then click Filter.
  6. Select the ADRC table.
    1. Type ADRC and click OK.
    2. Select ADRC and click Add to import list.
    3. Under Choose Parent Table, select KNA1.
    4. Under Map primary key columns to parent-table foreign key reference columns, select ADRNR for ADDRNUMBER. Leave the default setting of NONE for the other columns.
      Figure 3. The Configuration Parameters window
      A screen capture of the Configuration Parameters for ADRC window, with KNA1 selected as the parent table and ADRNR selected in the ADDRNUMBER field.
    5. Select the default settings for Columns to be selected in query by clicking OK.
  7. Click Next.

Result

The enterprise service discovery wizard has found the tables you specified, and you have selected the data you want to query.

Terms of use |

Last updated: Mon 30 Oct 2006 03:34:56

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)