ABAP Query

[Former Member]

Hi all,

Please let me know when to use ABAP query and is it really used in development.

Thanks in advance.

Sri.

[Former Member]

Hope u can go thru the online doc

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

regds

gv

[jayanthi_jayaraman]

Hi,

ABAP/4 Query is a powerful report to generate simple reports. Mainly, there are four different ways to define data source in ABAP/4 query.

The four methods are

1. Table join using basis table.

2. Direct read of table.

3. Logical database

4. Data retrieval by program (Internal Program / External Program).

Check this link for more information.

http://www.sappoint.com/abap/ab4query.pdf

Kindly reward points by clciking the star on the left of reply,if it is useful.

[Former Member]

<b>Why ABAP/4 Queries?</b>

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.

<b>Type of Report Desired</b>

Before starting to write an ABAP query, its advisable to decide the type of report that the user wants. ABAP query provides the following type of reports:

Basic List Simple report

Statistics Report containing statistical functions like Average &Percentage

Ranked List Report written for analytical purpose

Refer this link too

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

Hope this helps.

Kindly reward points for the useful answers.

[Former Member]

Hi Sriram,

ABAP/4 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.

Type of Report Desired

Before starting to write an ABAP query, its advisable to decide the type of report that the user wants. ABAP query provides the following type of reports:

Basic List Simple report

Statistics Report containing statistical functions like Average &Percentage

Ranked List Report written for analytical purpose

Also Check this Link.

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

Kindly Reward Point if u find it useful.

Thanks&Regards,

Ruthra.R

[Former Member]

Hi,

Mostly ABAP query used by functional consultants. many time is for single use and its very easy to develop.

transactions are used for Abap query is

SQ03 - > Create User Group ( who are having access

rights )

SQ02 - > Create InfoSet and Assign the User group to

Infoset

In the Infoset, we can frame infoset by Table join, Logical database and Data Retrieval by program. Here we can write our coding also.

SQ01 - > Design the query with help of infoset

( we can include select option also )

Cheers,

Sasi