Query interface for SAP Software
The Query interface for SAP Software (QISS) provides you with the means to retrieve data from application tables on an SAP server or to query SAP application tables for the existence of data. The adapter can perform hierarchical data retrieval from the SAP application tables.
Query interface for SAP Software supports outbound interactions for read operations (RetrieveAll and Exists) only. You can use this interface in local transactions to look up records before write operations (Create, Update, or Delete). For example, you can use the interface as part of a local transaction to do an existence check on a customer before creating a sales order. You can also use the interface in non-transaction scenarios.
Query interface for SAP Software supports data retrieval from SAP
application tables, including hierarchical data retrieval from multiple
tables. The interface supports static as well as dynamic specification
of where clauses for the queries.
The Adapter Connection wizard finds
the application data tables in SAP, interprets the hierarchical relationship
between tables, and constructs a representation of the tables and
their relationship in the form of a business object. The wizard also
builds a default where clause for the query.
You can control the depth of the data retrieval, as well as the amount of information, by using the maxRow and rowsSkip properties.
Query interface for SAP software (QISS) supports hierarchical data retrieval from the SAP application tables. By using this interface, the adapter can determine the existence of data in SAP application tables, or retrieve all the data in SAP application tables. For example, to check if customer Bob exists in SAP system, the Adapter Connection wizard can be run to discover the SAP application table KNA1. The wizard then generates the business object for KNA1 along with other SCA service artifacts. At run time, the SAPRequest node passes the KNA1 business object to the adapter to call the QISS interface, the adapter retrieves the table data from SAP, and returns the result to the node.