SAP QUERY
SAP Query is used to create reports for users who have little knowledge about SAP Table data storage structure. SAP Query allows evaluati
system.
SAP Query offers users a broad range of ways to define reporting programs and create different types of reports such as basic lists, statisti
SAP Query - Features:
Following are the major components which are associated with SAP Query:
1. Info Sets - Are base for the Query and it contains one or more database table details
2. Queries – For the User to create and generate the Query
3. User Group – To restrict set of Users for a specific Query plus for Authorizations
4. Quick Viewer - A simple tool for quick report generation
SAP Query - Area:
Following Query Areas:
1. Standard Area – They are Client Specific Queries and do not create an Work Bench Request
2. Global Area - Queries in the Global Area are Client Independent
SAP Query – Creation: TCODE
Creation of Quick Viewer (User Specific) SQVI
Creation of User Groups SQ03 User Group - (Finance, AP,AR, HR etc)
Creation of Infosets SQ02
Creation of Query SQ01
Creation of Quick Viewer – SQVI
SQVI is a simple report that can be written directly in the production system, I.e., there is no need for transporting information between sy
consultant (or even business user) with a good understanding of SAP tables can write a query with SQVI.
Note
The Difference between the SQVI and SQ01/SQ02 are the Queries which we are written in SQ02/SQ01 are Transportable. Where in SQVI w
Queries in production system.
ucture. SAP Query allows evaluating data in the SAP
eports such as basic lists, statistics, and ranked lists.
nsporting information between systems. Any functional
e Transportable. Where in SQVI we directly written the
Requirement to Create Custom Report for specific user
Company want GL Master Data Report as per format.
Selection Parameters
G/L Account to
Chart of Accts to
After Entring the any Selection Parameters Report should Display.
G/L Account Chart of Accts Balance sheet acct G/L account Group account number Account Group Created by
Table for GL Master Data
SKA1 G/L Account Master (Chart of Accounts)
SKB1 G/L account master (company code)
Requirement to Create Custom Report for specific user
Company want GL Master Data Report as per format.
Selection Parameters
G/L Account to
Chart of Accts to
Company code to
After Entring the any Selection Parameters Report should Display.
Company code G/L Account G/L Acct text Chart of Accts Balance sheet acct Account Group Created by
Table for GL Master Data
SKA1 G/L Account Master (Chart of Accounts)
SKB1 G/L account master (company code)
Created Dt House Bank Account ID
Requirement to Create Custom Report with Tcode.
Company want Vendor Master Data Report as per format.
Selection Parameters
Vendor Code to
Company Code to
Name to
City to
PIN Code to
State to
Account Group to
County Key to
Created by to
After Entring the any Selection Parameters Report should Display.
Table for Vendor Master
LFA1 Vendor Master (General Section)
LFB1 Vendor Master (Company Code)
LFBK Vendor Master (Bank Details)