Skip to Content
author's profile photo Former Member
Former Member

Ad hoc query

Good Day Experts;

I wish to create an ad hoc type query(user friendly with choices) but require information from multiple infotypes. Does a new infotype have to be created to make this work? Or is there a way to do this?

All information greatly appreciated.

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 25, 2007 at 06:18 AM

    Adhoc qurey can be done through transaction code S_PH0_48000510

    U can choose multiple infotypes data through it

    If u need any help,let me know

    I have worked on it

    Regards

    Jayeeta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 24, 2007 at 11:02 PM

    Hi,

    In t-code SQ02, under the data fields section choose the "Logical Database PNP". Here you can choose multiple infotypes of your choice.

    Hope this helps,

    Reward points if helpful,

    Thank you,

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      maybe you talk about a filed taht's label is misleading.

      Please go into the Ad Hoc Query.

      Place the mouse over the header in the tree of all available fields on the left side

      Press the right mouse button and choose the option "Technical Names on/off"

      A new coloumn is displayed in the tree displaying the technical name.

      Please poste this technical name and we can find out why the field behaves different.

      Regards,

      Michael

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2007 at 06:00 AM

    Ad Hoc Query Tips & Tricks

    • 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.

    • You can save an Ad Hoc Query and run it from ABAP Query where you have SAP standard selection options.

    • You can use the Ad Hoc Query to provide selected data for a specific report. Specify the report using the menu path Goto --> Start Report.

    • You can change the column order of the output by using the up and down keys of the Output tab. Select the relevant field and push it up or down.

    • 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.

    • The transaction code for Ad Hoc Query is PQAH

    • In version 4.6c and above, functional areas are now called InfoSets.

    • In version 4.7 there is another functional area for Public Sector. It is called PNPxx - you will recognise it. If you try and use the PNP InfoSet, the system prompts you to use the other one instead.

    • SAP will default an InfoSet (functional area) if you use transaction code PQAH (will default the one on which the last query was based). If you use other menu paths, then you get the chance to choose the InfoSet, as you can do when creating a query in SAP Query.

    • You can use the Complex Operations which allow you to choose 2 different data selections and report on the differences/union etc. Complex Operations can be chosen by using the menu path View --> Expert Mode within Ad Hoc Query.

    • If you are using 4.5 you can create the "explorer" look and feel of 4.6 by changing the settings in menu path Help --> Settings. Change the radio button from System Defaults to Active X. The changes take place from the next transaction call.

    • If you are using version 4.6 and would prefer to use the old view - you can change the view format - under settings on the menu path.

    • You can use the Ad Hoc Query to provide selected data for a specific report. Specify the report using the menu path Goto --> Start Report.

    • Click on the "select" icon to give you an indication of the number of records that have been selected.

    If you are using any version of SAP before 4.6C, you will not see any PCH (Org. Mgt.) functional areas. You can make use of these functional areas in SAP Query, but not Ad Hoc.

    You will also notice, that any query set up in SAP Query, which is based on a PCH functional area, can be run from within Ad Hoc query. Any Org. Mgt. fields - will be for output only and you won't be able to use them as selection fields.

    Ad Hoc Defaults

    The following items can be assigned to the User Parameters for Ad Hoc Query users to default certain parameters:

    AQB Default User Group

    AQS Default Functional Area

    i think this can help u out

    KumarB

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2007 at 02:46 PM

    yes used those infotypes.

    Woud be more than happy to upload a screen shot - except i don't know how. Pardon my ignorance but how can I upload a sreen

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Please try creating a custom field group in the infoset and drag-drop your required fields into it from the logical database PNP and try running the query in the ad-hoc.

      Maybe this might help.

      Let me know

      Reward points if helpful,

      Thank You,

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.