plz throw some light on how to prepare ABAP QUERY

[Former Member]

hi,

sap gurus,

why and how ABAP QUERY is created

plz throw some light on this

regards,

balaji.t

09990019711.

[Former Member · Accepted solution]

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

Regards,

Rajesh Banka

[Lakshmipathi]

Dear balaji

Every business is unique and SAP provides reporting tools for its users. For simple reports, you can use the ABAP/4 Query instead of writing reporting programs. If the reports specifications is not very complex, using the query will save you a lot of time. In the query, you can create your own calculation variable, define the sorting criteria, define the field arrangement and define whether you want to have totals.

Steps to create a query :-

=> SQ02 - Create the Functional Areas

=> SQ02 - Assign to User groups

=> SQ00 - Create the Basic Lists/Statistic/Ranked List

--> Basic Lists are details reports. Every records in the table are printed.

--> Statistic are summary reports. The records with the same keys are group together.

--> Ranked list are ranking report. e.g. The top 10 sales values.

thanks

G. Lakshmipathi

[Former Member]

hi balaji,

The purpose of the SAP Query are for users with no programming knowledge. It is also used by abapers to create simple reports for the users.

You can easily create three types of query reports :

1. Basic lists (details list)

2. Statistics (counting etc.)

3. Ranked lists

When you start using version 4.6x, you can see a Quick Viewer button in the Query Main screen. It is suppose to be much simplier that the original Query but it is up to you to decide whether is it true.

To create a report with the QuickViewer, all you need to to do is enter texts such as titles, and select the fields and options that define the structure of the report. You can assign a specific sequence to the fields by numbering them.

If necessary, you can edit the lists either through drag and drop in WYSIWYG mode, or by using the functions in the available toolbars. Data can also be send to external programs such as MS Excel or MS Word for further processing.

The only problem with QuickViewer is that it cannot read cluster table.

also pl check the link for more info :

[abap query|http://www.sap-basis-abap.com/sapquery.htm]

regards

sadhu kishore