ERP Database - The Unofficial ERP Knowledge Base

Facebook Twitter del.icio.us Digg it
ERP Database contains a huge collection of articles related to ERP System and Software. Many of the articles are specifically related to SAP. All these ERP/SAP articles are freely available to everyone.

If you would like to submit an article or share any document related to ERP or any specific ERP software. Please mail it to support@erpdb.info. Please make sure that the documents are not copyrighted.
Social Bookmarks:

What is SAP Query or ABAP Query?

Print This Post Email This Post Written by jimstex on Apr 7th, 2010 | Filed under: ABAP

ABAP Query (also known as an SAP Query or Query) is a powerful tool used to generate simple reports without any coding. Typically, an ABAP query isĀ  created first by defining a User Group and a Functional Group. The functional group can either be created with reference to a logical table or a database table. Once the functional group is defined, the user group is assigned to the functional group. The last step is to create the query on the functional group that is generated.

An ABAP Query can be used to create the following three types of reports:

  • Basic Lists: Reports with basic formatting without any calculated fields.
  • Statistics: Reports with statistical functions such as average, percentages, etc.
  • Ranked Lists: Ranked lists are used for analytical purposes.
Share

If you like this post, you may as well like these too:

  1. ABAP Programs: A simple query 1 2 3 4 5 6 7 REPORT ZSOURCE1101. * Work area for a database table TABLES CUSTOMERS. * Reading all entries of the database table SELECT * FROM CUSTOMERS....
  2. ABAP Programs: Ordering query results 1 2 3 4 5 6 7 8 9 REPORT ZSOURCE1108. * Work area TABLES CUSTOMERS. * Reading table entries in a specified order SELECT * FROM CUSTOMERS ORDER BY...
  3. SAP Query Reporting Download Here...
  4. Query Based Taxonomies It is impossible to centralize all the information in a single repository so the Knowledge management provides A unified view, taxonomies and set of common services. on top of heterogeneous...
  5. Convert Quick View into a Query The Quick View reports can easily be converted into SAP Queries. To do this, choose first the query group that you are assigned to and that you will want to...



Leave a Reply