Selecting Procedures

Begin building an SAP R/3 query by selecting a procedure (BAPI). You can only select one procedure per query. Select a procedure on the Query Builder - Start page.

Available Procedures displays application components (for example Sales and Distribution); business objects (for example, SalesOrder); BAPIs (for example, GetList); and BAPI parameters, return value, and result sets.

These are from the SAP Business Object Repository (BOR) of the connected R/3 Application Server. The procedures displayed depend on the SAP R/3 version and configuration and your SAP R/3 user permissions.

*  To select a procedure:

  1. Select which procedures (application components, business objects, and BAPIs) to display.

    To select which procedures to display, click the arrow to the right of the list box under Available Procedures and select an option. (For example, you could select Business Object View, Financial Accounting Only, and Payroll Accounting Only.) To display all of the procedures, select Full Hierarchy View.

    SQR Production Reporting Studio organizes the procedures according to their definition in SAP R/3.

  2. Display the desired procedure.

    To display the data contained in a procedure, click the plus sign (+) next to the procedure.

  3. Select the procedure.

    • Drag a procedure (BAPI) from Available Procedures to Selected Procedure.

    • Select a procedure and click Right Arrow button.

Each procedure can contain:

OptionDescription

Parameters

Values passed to and from BAPIs. Parameters can be input, input/output, or output.

Return Value

The return value for the BAPI.

Result Sets

The data returned after executing a BAPI.

Tip:

For information about an object under Available Procedures, point to the object. For example, pointing at the GetList BAPI, under the SalesOrder business object, under the Sales and Distribution application component, displays a tooltip that says: GETLIST: List of all orders for customer.