Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Diff between Adhoc Query and ABAP Query

Former Member

‎03-05-2008 6:08 AM

0 Kudos

Hi All,

Can anybody tell me the difference between adhoc query and abap query.?

Thanks,

Anil

3 REPLIES 3

Former Member

‎03-05-2008 6:13 AM

0 Kudos

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.

Former Member
In response to Former Member

‎03-05-2008 6:20 AM

0 Kudos

Hi,

really i am not clear with your answer.

can u please elabarate and take one example..

Thanks,

Anil

Former Member

‎03-05-2008 6:47 AM

0 Kudos

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