WebSphere Adapter for SAP Software

Selecting business objects and services

To specify which data you want to query, you provide information in the enterprise service discovery wizard.

Before you begin

Make sure you have set the connection properties for enterprise service discovery.

About this task

Specify search criteria that the enterprise service discovery wizard uses to query data on the SAP server. The enterprise service discovery wizard returns the data that meet the search criteria.

To specify the search criteria, use the following procedure.

How to perform this task

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

    The Filter button is now enabled.

  4. Click Filter.
  5. Enter information about the table.
    1. In the Filter Properties for Discover By Name or Filter Properties for Discover By Description window, type the name of the table.

      You can type part of the name and use the wildcard (*) character.

    2. Click OK.
    3. Expand Discover By Name (filtered) or Discover By Description (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.
    4. Select the table and click Add to import list.

      In the example shown in the previous figure, the table name is KNA1.

    5. In the Configuration Parameters for table window, indicate which columns you want included in the query and click OK.
      Figure 2. The Configuration Parameters window
      A screen capture of the Configuration Parameters for KNA1 window.
  6. To include another table in the query, perform the following tasks:
    1. Click Filter and type the name of the table (for example, ADRC). Then click OK.
    2. Expand Discover By Name (filtered) or Discover By Description (filtered) by clicking +.
    3. Select the table and click Add.
    4. Under Choose Parent Table, select the first table (KNA1 in the example).
    5. Under Map primary key columns to parent-table foreign key reference columns, select a value to link the tables.

      For example, you might select ADRNR for ADDRNUMBER.

    6. Indicate which columns you want included in the query and click OK.
  7. Click Next.

Result

The enterprise service discovery wizard has returned the data that matches the search criteria.

What to do next

Specify a name for the business object and the directory to which it should be stored.
Related concepts
Business objects
Related reference
Metadata of SQI business objects
Operations of SQI business objects
Naming conventions for SQI business objects

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)