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
Showing results for 
Search instead for 
Did you mean: 

ABAP QUERY

Former Member
0 Kudos

hello ,

can u explain me what is ABAP QUERY and why we use this ?

Thank you very much.

Regards,

Vijaya.

2 REPLIES 2

shafiq_rehman3
Active Contributor
0 Kudos

ABAP Query is used to create adhoc reports, i.e. they are quickly developed and even end user can create them and change them according to their needs.

To create them you first have to create an infoset (SQ02), most probably you will be using Logical Database or you will be joining tables to create infoset.

Then you create user group (SQ03), and assign users who can create and run reports out of that infoset.

Then you create actual reports (a.k.a queries) (SQ01) using that infoset.

For details see: http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Introduction.asp

Former Member
0 Kudos

hi vijayalakshmi,

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.

hope its clear to you,

Reward if usefull,

Thanks,

Kalyan.