Download QUERY User Guide - Winshuttle Software

Winshuttle QUERY User Guide
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, it is checked in a
single table authorization table. If it exists, the 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 is applied only to output fields. It is not applied to selection fields.
Starting a query
The selecting stage is the first stage in the query builder process of QUERY. You are defining your
query.
You have options for how you build a query, including the following:

Create a new query (.qsq file) and define all the search criteria.

Re-use saved queries.

Open a query template.
To start a new query

On the QUERY welcome screen, click New
.
To open a query template

On the Select pane, click Create Query using Winshuttle Templates.
To re-use an existing query

On the QUERY welcome screen, click Open
.
Tables and the Winshuttle Data Dictionary
Depending on the data source you choose while creating a query, the building block of any
Winshuttle QUERY could be tables, Infosets or SAP queries, or logical databases. These items are
found within the Winshuttle Data Dictionary.
The Winshuttle Data Dictionary
The Winshuttle Data Dictionary contains the most frequently used SAP tables, logical databases,
and infosets and SAP queries.
42