You use the Query interface for
SAP Software for outbound processing only.
The message flow that makes the request uses the interface
information that was generated by the Adapter Connection wizard.
The following list describes the sequence of processing
actions that result from an outbound request that uses the query interface
for SAP Software.
- The adapter receives a request, which includes a table object,
from a message flow.
The query business object can be
in a container business object, or it can be received
as a table business object.
- The adapter determines, from the table object sent with the query,
the name of the table to examine.
- The adapter determines the columns to retrieve or examine.
- The adapter determines the rows to retrieve or examine.
- The adapter responds.
- For a RetreiveAll operation, the adapter returns a result
set in the form of a container of query business objects, which represent
the data for each row retrieved from the table. If the query is received
as a table business object (not inside a container), the rows are
returned one at a time, as they are retrieved.
- For the Exists operation, the adapter returns an indication of
whether the data exists in the SAP table.
- If no data exists, the adapter generates an exception.