SAP BI Java SDK

Package com.sap.ip.bi.sdk.dac.relational.query.sapq

Provides interfaces for data structures relevant to SAP Query.

See:
          Description

Interface Summary
IBISapqCommandProcessor Extension of the Relational Command Processor to support Select-Options instead of standard WHERE conditions.
IBISapqQueryCall Simplified contents of the Relational Query Model pre-processed into a form that the BI SAP Query Connector can pass to the SAP Web Application Server.
IBISapqSelectOption Record of an ABAP/4 SELECT-OPTIONS table.
IBISapqSortField The sorting criteria for SAP Query (basically, column name and sorting direction).
 

Class Summary
IBISapqSelectOption.Enum Simple typesafe enumerator.
IBISapqSelectOption.Kind Typesafe Enumerator for SELECT-OPTIONS Kind.
IBISapqSelectOption.Option Typesafe Enumerator for SELECT-OPTIONS Option.
IBISapqSelectOption.Sign Typesafe Enumerator for SELECT-OPTIONS Sign.
 

Package com.sap.ip.bi.sdk.dac.relational.query.sapq Description

Provides interfaces for data structures relevant to SAP Query. This package documentation contains the following sections:

Overview

SAP Query is a reporting tool for systems running SAP Web Application Server, and is also accessible via an ABAP BAPI. This package provides interfaces to the data structures used when accessing SAP Query via this BAPI (Functiongroup RSAQ).

Metadata Mapping

SAP Query uses the following metadata objects:

These objects have been mapped to the relational model used in the SDK in the following manner:

SAP Query SDK Relational Model Description
SAPQUERY Catalog placeholder catalog
SAPQUERY Schema placeholder schema
Functional Area Table  
Functional Area Fields Column  

Usergroups could have been a potential candidate for either catalog or schema, but as their support will be discontinued, this was not chosen.

As the results of generic queries in SAP Query can be far more complex than the mapping to a relational table would allow (for example, several separate results as the result of one query) this was not feasible within the framework of the relational query model of the SDK. Therefore, Functional Area was chosen as the representation of a relational table instead, still allowing full access to the entities offered within SAP Query, with the restriction however that queries need to be generated for a Functional Area via the SDK.

SAP Query does not support queries involving more than one functional area at once (in other words, JOINs are not possible).

SELECT-OPTIONS

As SAP Query uses the runtime of the underlying SAP Web Application Server and provides access not only to relational tables, but also to Logical Databases and Reports via the same BAPI, query selections and restrictions (specified as WHERE conditions in SQL) are limited to a subset of the expressions permissible in the relational model. Where possible, WHERE conditions are translated to their equivalent representation in SAP Query called SELECT-OPTIONS, or else an exception is raised. Details of the subset are can be found in the SELECT-OPTIONS Semantic document as well as in the SAP online help for the SAP Web Application Server (see For Additional Information, below).

Query Execution

SAP Query query execution supported via the SDK consists of the following phases:

  1. SAP Query query based on the functional area and metadata provided (fieldlist for the selection, etc.) is generated on the fly. SAP Query query is executed with the SELECT-OPTIONS restrictions (converted from the original relational form of the relational query).
  2. SAP Query result is retrieved (simple text-based JCo table) and converted to a relational result set (SDK implementation of java.sql.ResultSet) and returned. Due to the implementation of the BAPI, the entire result of such a query is retrieved at once (even though java.sql.ResultSet would allow a cursor-based fetch model).

For Additional Information

Since:
3.50

SAP BI Java SDK

Copyright © 2004-2006 by SAP AG. All Rights Reserved.
SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.
These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies (SAP Group) for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.