Get Started
/ Blogs
SAP Query Creation &
Execution Table Join &
Logical Database
May 9, 2014 | 375 Views |
Jaymin Bhatt
more by this author
FIN (Finance)
share
0 share
0 tweet share
0
Follow
SAP Query Overview:
SAP Query is used to create reports for users who have little
knowledge about SAP Table data storage structure. SAP Query
allows evaluating data in the SAP system.
SAP Query 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.
SAP Query Features:
Following are the major components which are associated with
SAP Query:
Info Sets Are base for the Query and it contains one or
more database table details
Queries For the User to create and generate the Query
User Group To restrict set of Users for a specific Query
plus for Authorizations
Quick Viewer A simple tool for quick report generation
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 its 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
Alert Moderator
5 Comments
You must be Logged on to comment or reply to a post.
Kumar R
May 9, 2014 at 3:32 pm
Good Document
Jaymin Bhatt Post author
May 9, 2014 at 4:25 pm
Thanks
GT SAP
May 9, 2014 at 5:36 pm
Very nice documentation. Thanks, Jaymin.
Prashant Govind Rane
May 11, 2014 at 12:29 pm
Hello Jaymin,
Thanks for sharing the document.
Is it possible for you to share one example of logical database query for
ADA? Thanks in advance!
my email ID rane_pg@hotmail.com
B/R
Prashant Rane
Mariks .
May 12, 2014 at 12:38 pm
Thanks for the sharing valuabledocument
Privacy Terms of Use Legal Disclosure Copyright Trademark Sitemap Newsletter
