About ABAP Querry.

[Former Member]

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.

regards.

sreekanth.

[Former Member]

Hi Skanth,

http://help.sap.com.

Regards,

John.

[Former Member]

hi

good

please go through this link

http://www.ams.utoronto.ca/Assets/output/assets/adhoc_2990830.pdf.pdf

thanks

mrutyun^

[Former Member]

Hi,

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

http://www.ams.utoronto.ca/Assets/output/assets/adhoc_2990830.pdf.pdf

Reward if helpful.

[Former Member]

Hi,

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’

Users:

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.

regards,

vasavi.

kindly reward if helpful.