Ad hoc query

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

I have used the transaction, but do not see how you could choose multiple infosets for one query. Have you found a way?

[suresh_datti · Accepted solution]

Infotypes or Infosets?

Infotypes - yes you can create an Infoset with mustiple infotypes & Query off the Infoset.

Infoset - No, I don't think you can use mutiple Infosets ina single query.

What exactly is your reqt?

~Suresh

[Former Member]

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

[Former Member]

Hi,

Please upload your screen shot in www.photobucket.com. After you upload, it will give you a link, which you can paste it here.

Hope this helps,

Reward points if helpful,

Thank You,

[Former Member]

Thank you.

The following are twoe screen shots. The first is of the infoset and the second is of a query attempt in ad-hoc. in the query screen shot, as disucussed, no field options can be brought up (possible personnel numbers in this case). This is different as similar infosets previously created in the same group allow for field options. I have compared the two infosets and unable to identify the difference

Any ideas on what could be occuring? Appreciate all assitance.

http://i188.photobucket.com/albums/z91/lb_1905/Infoset.jpg

http://i188.photobucket.com/albums/z91/lb_1905/query.jpg

[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,

[Former Member]

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

[Former Member]

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,

[Former Member]

Great. so I created an infoset, put it in a user group and tested it. When toad-hoc to use and it works - BUT there is one thing i cannot get to work, the possible selection for a field. (ie. the filed for selection is personal ID but that field does not link to seach options as other queries that exist in the system) Any idea what I am doing wrong?

[Former Member]

Hi,

Good.

Did you select IT0001 and IT0002 from the logical database PNP?

I am sure you should definitely have a selection criteria for personnel number field.

If not, please upload a screen shot of the same. Let me have a look at it.

Reward points if helpful,

Thank You,

[McF]

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