SAP Query Infoset
This post will list the most important links to consider in order to learn/master SAP Query and SAP Infoset using the SAP Tcodes SQ01 and SQ02.
First it starts with answering the question what SAP SQ01. Then it lists some useful SAP Queries tutorials.?
Let’s start by a short definition for SAP Queries:
SAP Query is used to create reports not already contained in the default. It has been designed for users with little or no knowledge of the SAP programming language ABAP.
It’offers users a broad range of ways to define reporting programs and create different types of reports such as basic lists, statistics, and ranked lists. (source)
Read also
You use info sets to group together key figures that are logically related. Info sets are particularly useful if you repeatedly need to call up the same key figures together.
For example, you can create an info set of all the key figures you need to check regularly.
There are two types of info set:
The members of a single-level info set are key figures.
The members of a multi-level info set are one or more subordinate info sets.
Thus, a multi-level info set can be seen as a hierarchical structure that refers to other info sets (see figure below). (source)
Here the list of SAP Infoset and Queries Transaction Code:
Tcode | Description |
---|---|
SQ01 | SAP Queries: Maintain queries |
SQ02 | Maintain InfoSet |
SQ03 | SAP Query: Maintain user groups |
You may want to check these SAP Query Books.
The following link covers some main business use of SAP Queries. I found it very helpful. You will find SAP Query Tutorials about:
All the SAP Queries Tutorials can be found here.
When dealing with SAP infoset and Queries, you may want to consider the following tips:
In order to change the color of some columns on the query’s report, go to SQ01 > Basic List.
Just drag&drop the color from the Right Tool-Box into the field.
You can set the Query areas on SQ02 > Environnment > Query Areas.
On Development Server, usually create the Infoset in Global Area in order to generate transport report.
On Quality Server or Production Server, select the Standard Area. In fact, the Infoset in Standard Area are client-specific.
Find the whole lists of Tips here: 10 Useful Tips on Infoset Queries
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…