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

About ABAP Querry.

Former Member
0 Kudos

Can anybody tell me how can i create a ABAP (Adhoc) querry to a custom created report.

Please give me detailed description.Because i dont have any idea about Adhoc querries.




Former Member
0 Kudos

Hi Skanth,



Former Member
0 Kudos



please go through this link



Former Member
0 Kudos


In this link you will find a step by step guide for ad hoc queries.

Reward if helpful.

Former Member
0 Kudos


it may help u.

In order to use Ad Hoc Query, the following components must be created:

§ Functional Areas

§ User Groups

§ Ad Hoc Queries (canned, prepared queries)

Functional Areas:

A functional area presents data from one or more database tables in lists, i.e. fields from the

infotype(s) are presented as fields that can be selected and/or extracted. Fields that exist as

codes may also have their code translation extracted.

Within a functional area, infotypes may be assigned to functional groups to improve clarity.

User Groups:

User Groups are assigned to a Functional Area and a user must be assigned to a user group in

order to be able to access a functional area for the creation of an ad hoc query.

To create a user group, go to:

à Tools à ABAP Workbench à Utilities à ABAP Query à User Group

For SAP’s documentation, go to SAP on-line documentation ‘User Groups’


To maintain users in a specific user group, go to:

à Tools à ABAP Workbench à Utilities à ABAP Query à User Group

Click on ‘Assign users and functional areas’ and enter the userid(s).

Users assigned to a user group may have the authority to create new or modify existing queries.

Click on the check box behind the userid if the user has the authority to maintain queries.

For more on the limitations, refer to the ‘Authorizations’ section.

Ad Hoc Queries:

Initially, AMS will create a pool of used Ad Hoc Queries. These are to be based on the results of a

survey that gathered the requirements for the ‘most often’ used queries.



kindly reward if helpful.