Please explaing the exact difference between each

[Former Member]

Please let me know what is the exact difference in following terms.

ABAP Query

SAP Query

Adhoc Query

Infoset Query

I understand that SAP query and Infoset Query are new terms used for ABAP query and Ad hoc query with new releases. And for HR module it's still called Adhoc query.

However, I need to know what is the difference during usage point of view or functionality wise. Quick Help would be apprecaiated.

[Former Member]

HI,

<b>ABAP Query:-</b>

www.sappoint.com/abap/ab4query.pdf

<b>SAP Query:-</b>

http://goldenink.com/abap/sap_query.html

<b>Ad-Hoc Query:-</b>

http://www.insightcp.com/res_15.htm

<b>Infoset Query:-</b>

http://www.sap-img.com/human/how-to-create-infoset-query.htm

Regards

Sudheer

[venkat_o]

Hello Friend,

Have a look at these sites .

<b>1</b>. http://help.sap.com/saphelp_47x200/helpdata/en/23/7fde36857ccd15e10000009b38f889/frameset.htm

<b>2</b>.

http://help.sap.com/saphelp_47x200/helpdata/en/b4/bbcd34f7b911d2963d0000e82de14a/frameset.htm

Thanks,

Venkat.O

[Former Member]

Thanks Venkat...I have gone throu it but cud u explain in layman terms the exact differences

[Former Member]

Hi,

ABAp query is sap tool to develop report.

using transaction sq01.

Regrads

Amole

[Former Member]

Hi

When you create a query (Transaction SQ01), you must first assign a InfoSet which usually represents a specific view of a logical database. You can select the required fields from this InfoSet and then define their format and the processing procedure to be used.

When you start the query, a report generator creates a report program which corresponds to the list definition. This program reads, processes, and outputs the data in list form.

<b>The query function is a utility which helps end users who have no programming knowledge to create their own report programs</b>

plz reward if useful

[Former Member]

Hello,

All these are reporting tools. It has been designed for users with little or no knowledge of the SAP programming language ABAP.

ABAP Query or SAP Query is an ABAP Workbench tool that enables users without knowledge of the ABAP programming language to define and execute their own reports.

In ABAP Query, you enter texts and select fields and options to determine the structure of the reports. Fields are selected from functional areas and can be assigned a sequence by numbering.

ABAP Query offers the following types of reports:

• Basic lists (Ordinary reports)

• Statistics (Reports with statistical functions)

• Ranked lists (Analytical reports)

If necessary, you can edit lists using Drag&Drop and the functions in the available toolbars.

The SAP Query comprises five components: Queries, InfoSet Query, InfoSets, User Groups and Translation/Query. You can get the steps for creating sap queries in this link.

http://goldenink.com/abap/sap_query.html

Classic reporting- the creation of lists, statistics and ranked lists- are covered by the InfoSet Query and Queries components. Other components’ range of functions cover the maintenance of InfoSets, the administration of user groups and also the translation of texts created in the SAP Query.

The InfoSet query is a tool within the SAP Query that you can set as an alternative to component queries. This tool for maintaining queries is suitable for both developing queries as well as ad-hoc reporting.

The InfoSet query can be set for reporting in all areas of the R/3 system.

When the InfoSet query is set in HR for ad-hoc reporting, the name ad-hoc query is used instead of InfoSet query.

Adhoc Query is used to create reports to meet requirements that are not satisfied by standard reports. By selecting selection fields and output fields, you can access data stored anywhere within the Human Resources System. You do not require programming skills to create reports using Adhoc Query.

The advantage of Ad Hoc Query is that it enables occasional system users or people with little experience to define their own reports according to their personal requirements in an easy and quick fashion. It is an ideal query tool for anyone who needs to obtain human resource information when and as needed.

Check Chapter 20 in this pdf file.

<b>http://searchsap.techtarget.com/searchSAP/downloads/Teach_yourself_SAP_C20.pdf</b>

Regards,

Susmitha.

Dont forget to reward points for useful answers.