To set up procedure result tables

Some stored procedures can return one or more result sets, just as a standard SQL statements can. To use these with a business object, you must map fields from the stored procedure result table to attributes of your business object as described below.

  1. Go to Data Sources.
  2. Right-click on the data source and select Mappings.
  3. Locate the stored-procedure mapping for which you want to set up a result table. Right-click on this mapping and select Procedure Result Tables from the context menu.

    The Mapping Procedure Result Tables window opens. It shows the current result-table settings (if any).

  4. For each field returned by the stored procedure, set the following:

    Field

    Type the field name just as it will be returned by the procedure.

    Type

    Type the data type that will be returned.

    Key

    Select the business object attribute to which the field should be mapped from the drop-down list.

    Click on Add to add the field to the result table. Use the Update and Delete buttons to edit or change an existing, selected field definition, respectively.

  5. Click OK to save your settings.