diff between sap query and abap query

[Former Member]

diff between sap query and abap query

[Former Member]

Hello,

They are the same thing. Prior to 4.6C, it was called ABAP Query probably because it under ABAP Workbench in the menu path.

Thanks,

Venu

[Former Member]

Both are same..

Check these links...u can find more information about ABAP query..

http://help.sap.com/saphelp_nw04/helpdata/en/b7/26ddebb1f311d295f40000e82de14a/frameset.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40bec8da-4cd8-2910-27a9-81f5ce10...

Regards,

Maha

[Former Member]

Hi,

ABAP query is mostly used by functional consultants.

SAP Query :

Purpose

The SAP Query application is used to create lists not already contained in the SAP standard system. 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.

Features

SAP Query's range of functions corresponds to the classical reporting functions available in the system. Requirements in this area such as list, statistic, or ranked list creation can be met using queries.

All the data required by users for their lists can be selected from any SAP table created by the customer.

To define a report, you first have to enter individual texts, such as titles, and select the fields and options which determine the report layout. Then you can edit list display in WYSIWYG mode whenever you want using drag and drop and the other toolbox functions available.

ABAP Query,:

As far as I Believe, is the use of select statements in the ABAP Programming. This needs a knowledge of Open SQL commands like Select,UPdtae, Modify etc. This has to be done only by someone who has a little bit of ABAP experience.

To sum up, SAP queries are readymade programs given by SAP, which the user can use making slight modification like the slection texts, the tables from which the data is to be retrieved and the format in which the data is to be displayed.ABAP queries become imperative when there is no such SAP query existing and also when there is a lot of customizing involved to use a SAP Query directly

use either SQ02 ans SQ01

or SQVI tr code

for more information please go thru this url:

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp

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

Please check this PDF document (starting page 352) perhaps it will help u.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

check the below link will be helpful for u

once you create query system generates a report starting with AQZZ/SAPQUERY/ABAGENCY2======= assing this report to tr code for the same

regards,

vasavi.

reward if it is helpful.

[Former Member]

Re: Diff. bet ABAP and SAP Query

Posted: Nov 26, 2007 3:16 PM in response to: baskaran sriniv... E-mail this message Reply

SAP Query

The SAP Query application is used to create reports not already contained in the default. It has been designed for users with little or no knowledge of the SAP programming language ABAP.

ABAP Query: Two types

Open SQL

Open SQL consists of a set of ABAP statements that perform operations on the central database in the SAP Web AS ABAP. The results of the operations and any error messages are independent of the database system in use. Open SQL thus provides a uniform syntax and semantics for all of the database systems supported by SAP. ABAP programs that only use Open SQL statements will work in any SAP system, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP Dictionary

Native SQL

Open SQL allows you to access database tables declared in the ABAP Dictionary, regardless of the database platform you are using. Native SQL allows you to use database-specific SQL statements in an ABAP program. This means that you can use database tables that are not managed by the ABAP Dictionary, and therefore integrate data that is not part of the SAP Web AS ABAP System.

Regards.

[Former Member]

hi,

ABAP Queries

These are the report which users can prepare without knowledge of the ABAP programming language to define and execute their own reports. Normally Functional Consultants use these ABAP query tool to create and run simple reports by themselves instead of coding by ABAPer. Its flexible and convinent. However you should be well thorough with different tables to map query and fetch data.

ABAP Workbench tool that allows users without knowledge of the ABAP programming language to define and execute their own reports.

Users enter texts and select fields and options in order to determine the structue of the reports. Fields are selected from functional areas and can be assigned a sequence by numbering.

Three types of report are available:

Basic lists

Statistics

Ranked lists

SAP Reports are Programmes which are used to fetch data from SAP database under specified selection criteria and show in list viewer. Later you can view, download & take decisions appropriately.

There are many standard reports in SAP for various modules. For SD Module watchout TCode SD01. You can always code your own report they way you want in some cases.

SAP QUERY

The SAP Query application is used to create reports not already contained in the default. 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 reports and create different types of reports such as basic lists, statistics, and ranked lists.

Features

The SAP Query comprises five components: Queries, InfoSet Query, InfoSets, User Groups and Translation/Query.

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.

All data required by a user for a report can be read from various tables.

To define a report, you first have to enter individual texts, such as titles, and select the fields and options which determine the report layout. In the WYSIWYG mode, you can edit the lists using Drag & Drop and various toolbars.

reward points if helpful,

shylaja