The Basics of ABAP Query
The neeed for ABAP/4 Queries:
Time saving is why the application SAP Query is used to create lists not already contained in the SAP standard. It has been designed for users with little or no knowledge of the SAP programming language ABAP. 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.
This write up aims is to explain the concept of ABAP/4 query in a simple and straight forward manner. The reader of this document should have a moderate knowledge of ABAP concepts and authorizations for understanding the concept of ABAP query.
- The ABAP Query application is used to create reports not already contained in the default. It has been designed for users with less knowledge of the ABAP programming.
- ABAP Query offers users a wide range of ways to define reports and create different types of reports such as basic lists, statistics, and ranked lists.
- The ABAP Query comprises four components: Queries, Info Sets, User Groups and Translation of Query.
- Creation of a user group.
- Creation of infoset.
- Assignment of user group to infoset.
- Creation of the query based on infoset.
- SQ01- ABAP query
- SQ02 - Infoset
- SQ03 - User group.
- InfoSets are special views of data sources. An InfoSet describes which fields of a data source can be reported on in queries.
- End-users are able to work only with those InfoSets that are relevant to their particular area, as designated by the role or user group that they are assigned to.
- An InfoSet can be assigned to several roles or user groups.
- The User Groups component is used to maintain user groups. Users working in the same application are assigned to the same user group.
- It does not matter who actually defined a query in a user group. Every user assigned to the user group is able to execute the query. Users in a user group need to have the necessary authorizations before they are able to change or redefine a query.
- Every user in a system can be assigned to several user groups.
- A lot of texts are generated when defining queries, InfoSets, and user groups. These texts are displayed in the language that we chose when we log on to the SAP system.
- We can compare the text/languages using this component.
- - BASIC LIST - Presents data in the order defined by the functional area .It supports sorting and summation .
- - STATISTIC - Shows the statistical figures calculated from the basic data.
- - RANKED LIST - A ranked list is a specialization of a statistic.
ABAP Queries can be transported to different clients by the following two ways:
1) By using the standard program 'RSAQR3TR'
2) By using the transport option available on the application
bar in Transactions SQ02 or SQ03.
