Introduction: InfoSets, SAP queries, and logical databases

QUERY > QUERY Tutorial > Introduction: InfoSets, SAP queries, and logical databases

Back to

Introduction: InfoSets, SAP queries, and logical databases

InfoSets and SAP queries

SAP queries and InfoSet queries are SAP end-user query reporting tools. They are valuable tools for generating customized reports. In particular, business users derive real benefit from them, because they would otherwise rely on programming staff to generate reports from the system.

Note: You can use only one InfoSet in a query.

Security handling

The table containing authorization objects for fields (see Authorizations) is used in securely extracting records for InfoSet/SAP Queries.

Security is applied on InfoSet/Query corresponding to the presence of table and field in authorization table. For example if MARC-WERKS is present in InfoSet/Query then its existence is checked in single table authorization table. If it exists then data is filtered accordingly.

There is difference between how it is handled for InfoSet query and SAP query:

For InfoSet query: It does not depend whether you have selected a field as output or not.
For SAP query: Security will be applied only for output fields. It is not applied if a field is just a selection field.

To access SAP queries and InfoSets which are already created in SAP, use Winshuttle QUERY.

Introduction to LDBs

Logical databases (LDBs) are special ABAP programs that retrieve data and make it available to application programs. The most common use of logical databases is still to read data from database tables by linking them to executable ABAP programs.

A logical database provides a particular view of database tables in the R/3 System. The data structure in a logical database is hierarchical. Many tables in the R/3 System are linked to each other using foreign key relationships. Some of these dependencies form tree-like hierarchical structures. Logical databases read data from database tables that are part of these structures.

You can use LDBs with Winshuttle QUERY only if the Winshuttle Function Module is installed on the SAP server you use.

Note: You can query only one logical database at a time. If you try to add a second LDB to Query Builder, the first selection will be removed as well as any fields that you selected.

Security handling

The inbuilt logic for security inside the LDBs is respected by QUERY. There is no other additional layer of security.

Also in this section

The QUERY screen

Logging on to SAP

Introduction: Getting started with QUERY

Introduction: Building a query

Introduction: QUERY templates

Introduction: Mapping your fields to a result file

Introduction: Submitting files for review

Introduction: Running queries