More resources

Query

Simplify SAP extracts and reporting

Winshuttle Query™ enables functional analysts and business users to use a familiar interface—such as Excel—to create ad-hoc reports from real-time SAP data, which can help improve a company’s operational and strategic decision making processes. Query is the perfect platform for companies that want to implement a non-technical solution that makes real-time SAP data more accessible.

See how B. Braun uses Query to save time and money

Why use it?

Query satisfies governance and audit requirements by complying with organizational-level security and standard SAP table security—a notable improvement over other more limited SAP query tools such as SE16, SQVI, SQ01, SQ02, and SQ03. It also introduces the patent-pending Adaptive Query Throttling™ technology that optimizes Query performance based on the SAP system load.

How does it work?

Query enables users to extract live SAP data in a simple three-step process:

Select: First, the user specifies the data source, selection criteria, and output fields, creating either a custom query or using one of the pre-built templates. Once finished, the user saves the query file in .qsq format.

Map: Next, the user chooses the report output type: Excel, Access, SQL, or forms, and then formats the template as desired with simple drag-and-drop operations.

Run: After creating the query file and establishing the layout of the output, the user can run the report immediately or schedule it to run later. They can also share the query file with Winshuttle Runner users or publish it to Excel so it can be embedded and executed directly from Excel.

On the back end, the SAP Certified Winshuttle Function Module, a no cost option, provides fully customizable enhanced security allowing table and field level authorizations. In addition, the Winshuttle Function Module performs SAP server load monitoring that limits the resources consumed by Query to ensure optimal SAP system performance. Network fine-tuning is addressed in the form of query “chunking” which processes each query in smaller, pre-defined “chunks”.

SAP query field and lookup attributes

Setting up Query execution scheduling

FAQs

What if a Tcode is not listed with its associated tables, can I add my own?

Yes, Query allows users to add and publish your own list of favorites to the Data Dictionary.

Does Query work with custom tables?

Yes. Query works with custom tables and custom fields within a standard table.

Apart from the standard SAP security and additional organizational-level security that Query provides, can I restrict the use of the tool in our SAP landscape?

Addressing Security Performance Usability with Query

An easy and secure way to extract live SAP® ERP data, allowing business users to do ad hoc data analytics and answer specific business questions rapidly would have a significant impact on the enterprise. This white paper describes Winshuttle Query and how it addresses performance, security, and usability concerns while giving users a way to extract live SAP data for ad hoc analysis.