03-05-2008 6:08 AM
Hi All,
Can anybody tell me the difference between adhoc query and abap query.?
Thanks,
Anil
03-05-2008 6:13 AM
Hi Anil,
AD HOC in general sense means. a custom designed solution that is aimed at solving a particular or specific problem or task. An Ad Hoc cant be generalised meaning that it cant be reused for other purposes with no or minimal modifications. ABAP query on other hand is highly customizable for various problems which enhances the scope of reusability for that query.
reward if helpful.
03-05-2008 6:20 AM
Hi,
really i am not clear with your answer.
can u please elabarate and take one example..
Thanks,
Anil
03-05-2008 6:47 AM
Hi,
ABAP QUERIES:
Many times a need arises for SAP Users and Functional Consultants to generate quick reports without getting any ABAP coding done time taken to complete the coding in development, transport and test it in QA system and then transport to production is sometimes too long. In such cases, ABAP/4 query is a tool provided by SAP for generating these kind of reports.
This document aims at explaining 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 various objects that form an ABAP query can be created in the following 2 ways:
Tools => ABAP/4 Workbench => Utilities => ABAP/4 Query
OR
By executing the transaction codes mentioned below
SQ01 ABAP/4 Query
SQ02 Functional Area
SQ03 User group
Adhoc Queries:
The ABAP Query was designed for all modules and the Ad Hoc Query was designed exclusively for the Human Capital Management module. Beginning with version 4.6, things have changed. The ABAP Query is now called the SAP Query and its features have been enhanced. Additionally, the Ad Hoc Query tool can now be used with all modules in SAP under the name the InfoSet Query (although in the Human Capital Management module SAP still refers to it as the Ad Hoc Query).
regards,
vineela