Scribd
Upload
117 views

SAP Query

This document provides steps for creating SAP queries including: 1) Creating a user group, infoset, and query. 2) Infosets can join tables or use a logical database to select fields for the query output. 3) Queries are assigned to user groups and designed using an interface. 4) QuickViewer can also generate reports from tables, joins, infosets, or logical databases.

Uploaded by

Abderrezak Ghazel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
117 views

SAP Query

This document provides steps for creating SAP queries including: 1) Creating a user group, infoset, and query. 2) Infosets can join tables or use a logical database to select fields for the query output. 3) Queries are assigned to user groups and designed using an interface. 4) QuickViewer can also generate reports from tables, joins, infosets, or logical databases.

Uploaded by

Abderrezak Ghazel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 10

 SAP Query – Creation:

Step 1: Creation of User Group – SQ03

Step 2: Creation of Infoset – SQ02

Step 3: Creation of Query – SQ01

The Terminologies:

SAP Query – Area:

SAP Query Area is a set of objects having queries, InfoSets and User Groups which are
consistent.

Following Query Areas:

 Standard Area – They are Client Specific Queries and do not create an Work
Bench Request
 Global Area  – Queries in the Global Area are Client Independent

SAP Query – User Group Creation:

Transaction Code: SQ03


Create a logical set of User Group to which the InfoSet Queries would be assigned.

SAP Query – Info Set Creation – TABLE JOIN:

SAP database have several numbers of tables in which the transactions, master data
gets stored and it’s practically not feasible to have all such fields for selection when
creating a query. Hence before the start of creating a query, InfoSet creation is
required.

It allows selecting Fields from either the tables selected or the logical database used to
get display/select in the output.

Transaction Code: SQ02 –

The InfoSet creation can be made with the Combination of Tables (Table Join), Direct
read from a Single Table or with the help of Logical Database.

The Red Box marked Icon allows adding more tables under the join.
Field Group contains the Fields which are required either to get in the report output or
in the selection screen.

Drag the Fields for the “Data Fields” to the relevant Field Groups to appear in the
report.

You can even change the text of the Fields that is getting displayed over the Output.

Once the InfoSet is created, it needs to be generated by click on  “Generation” icon.
Any changes made to the InfoSet, it needs to be re-generated everytime.

SAP Query – Assigning to User Group:

Transaction Code: SQ03

All the InfoSet queries which are created to be assigned to one or more user group

Click on Save button for the assignment.

SAP Query – Query Creation:

Transaction Code: SQ01

Once the InfoSets are created and assigned to User Group, Query needs to be designed.
It is basically known as Query Painter in which we design basic lists in WYSIWYG mode
(what-you-see-is-what-you-get).

We need to select the User Group first in which query needs to be designed. Click on  
icon to select the user group.
Specify the Query Name and click on the Create Option.

Select the InfoSet which had been created.

Following screen would appear:

We can select the Output Format, Variant assignment over the Basic List.

Click on    to select the required Output/Selection Field.


Click on Save Option to make a final design.

To Run the Query Click on Execute Button:


SAP Query – Info Set – LOGICAL DATABASE:

The LDB is special type of ABAP program that combines the contents of certain related
database tables and retrieves some related data and make it available to application
programs. The LDB usually consists of the components like Structure, Selections and
Database programs.

In simple words Logical Database can be referred as Cluster of Tables together.

Transaction Code: SE36

Following are some useful Logical Database from accounting perspectives:

 ADA      Assets Database


 AUK      Settlement documents
 BRF       Document Database
 BRM      Accounting Documents
 CEK      Cost Centers – Line Items
 CIK       Cost Centers – Actual Data
 CKA      Costing
 CKC      Order BOM
 CKW     Costing run: Material Selection
 CPK      Cost Centers – Plan Data
 KDF      Vendor Database
 PAK      CO-PA Segment Level and Line Items
 SDF      G/L Account Database

Example:
Once the Table are copied follow the same steps as mentioned above for creation of
Field Groups, Query Creation & Execution.

SAP Query – QUICKVIEWER – SQVI:

Quick Viewer is tool to generate report with basic lists. Quick View Reports are user
dependent. While defining a Quick View Tool report data can be accessed from Tables,
Logical Database, Table joins & from Infosets also.

Transaction Code: SQVI


We get an option of extracting the data from a Table / Table Join / Logical Database / SAP
Infoset

Once all the required tables are been assigned and joined, click no the Back Icon to
Create the Selection / Output Screen.
Select all the required fields, which are needed as a part of Selection Screen and
Report Output Layout and save the Quick Viewer Query.

To execute teh Query, Click on  Execute Button to the run the Quick Viewer.

Above are the simple options of creating report with the help of Queries.

BR, Jaymin R. Bhatt


FollowLikeRSS Feed

You might also like