cancel
Showing results for 
Search instead for 
Did you mean: 

Adhoc Queries in SAP

Former Member
0 Kudos

Can somebody suggest a good material for writing adhoc queries in SAP.

Thanks,

Swarna.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

• You need to create User Groups and Functional Areas first (before you create any queries) - to which you will have to assign the relevant users.

• Remember that Query Areas - whether Standard or Global - have an effect on the view of the reports that are with the User Group and Functional Area selected.

• When creating a functional area which calls the PCH (org mgt) database, don't populate the field "selection screen version". Choosing either 900 or 901 from the drop-down options, will result in a different screen selection which does not allow the option of entering the evaluation path.

• When setting up a functional area which calls the PNP (PA) or PCH (Org Mgt) database, remember to include all the required PA and Org Mgt infotypes.

• If any changes are made the Functional Area has to be re-generated to activate the changes.

• Remember that when first creating a functional area, to check the fields that are defaulted by SAP. Delete the fields that are not used on your system and include ones that will be required when creating a query.

• Remember to change the "selected functional group" when switching fields "on" in the functional area. The fields are placed into the current "selected functional group" when turned "on".

• Change the descriptions of the fields when setting up the functional area. The long text is used when choosing the field and the header is the field name that is output with the report data.

• If you wish to add more infotypes to your functional area, use the menu path: Edit --> Add Info Category.

• In order to convert query objects (for example - after an upgrade), you need to run the programs RSAQSUMM followed by RSAQUM40.

• To find all the ABAP Query reports in the system, use transaction code SE38. Type in the string "AQ*" (without the quotes) and change the maximum number of hits to include all entries. You will find all the ABAP queries have the notation AQ50/User GroupReport Name====== where 50 is the client number.

• You can use the report RSAQR3TR to transport user groups, functional areas and queries. Use transaction code SE38 to run the report or look for the truck symbol (transport icon) on the relevant screen.

Useful Transaction Codes

• SQ01 - ABAP Query

• SQ02 - Functional Areas

• SQ03 - User Groups

sikindar_a
Active Contributor
0 Kudos

nice explanation prakash

Former Member
0 Kudos

Hi Prakash,

A quick question can call function modules in ADHOQ query? if yes how.

Thanks and best regards

Rajeev

Former Member
0 Kudos