SAP Query is a tool to generate report without ABAP Coding.
Types of reports provided by SAP Query are :
1. Basic list - A Simple report
2. Statistics - A report containing statistical functions like Average & Percentage
3. Ranked list - A report written for analytical purpose.
T-code : SQ01
Types of reports provided by SAP Query are :
1. Basic list - A Simple report
2. Statistics - A report containing statistical functions like Average & Percentage
3. Ranked list - A report written for analytical purpose.
T-code : SQ01
Steps to create a query :
SQ02 - Create Infoset - Indicates from which part of the SAP database the data is going to be retrieved and how the data is to be retrieved by the query i.e.here we define the tables and joins between them.
You can add coding if required in the Code Section.
SQ02 - Create Infoset - Indicates from which part of the SAP database the data is going to be retrieved and how the data is to be retrieved by the query i.e.here we define the tables and joins between them.
You can add coding if required in the Code Section.
SQ03 - Create User group - Here we assign the users who are authorized to use this query and assign the Infosets to usergroup.
SQ01 - Create Query - To create a query.Here we assign the Infoset to the query and choose the fields to be displayed on the selection screen of query and the fields to be displayed on the output list of query report.
SQ07 - Translation of Query - This is to translate the texts of Queries (like Title header and Selection screen texts),Infosets and Usergroups.