How do I create ad hoc query in SAP HR?

How do I create ad hoc query in SAP HR?

SAP AD HOC Query Tutorial (S_PH0_48000513)

1. Select a Work Area – queries linked to a specific client or to all clients.
2. Choose a User Group – to access available infosets.
3. Choose an Infoset – In the list select the desired infoset.
4. Click the Check Mark Button.

How do I create a custom infotype in SAP HR?

Steps to Customize infotypes

1. Go to Transaction PM01.
2. Enter the custom Infotype number which you want to create (Should be a 4 digit number, start with 9).
3. Select the `Employee Infotype’ radio button.
4. Select the `PS Structure Infotype’.
5. Click on Create.

What is ad hoc query in SAP HR?

SAP Ad Hoc Query is an operational reporting tool which is widely used in the SAP HR world. It is based on the notion of InfoSet. An InfoSet is a group of Infotypes on which you can report. An InfoSet is always specific to a submodule of SAP HCM, either PA (Personnel Administration) or OM (Organizational Management).

What is adhoc query?

A non-standard inquiry. An ad hoc query is created to obtain information as the need arises. Contrast with a query that is predefined and routinely processed.

What is infotype subtype in SAP HR?

Info Subtypes are known as sub units of an Infotype. Using subtype, you can easily manage and access the data in HR system and can control the Infotypes. You can easily assign different features to control the data like time constraints to sub types.

How to create Infoset in SAP?

How to Create Infoset? Right-Click on the infoarea and choose the option “Create Infoset” from the context menu. Transaction RSISET can also directly be used to create InfoSet. When the Info Set Builder is called for the first time, the below two display mode options as Tree (Tree Control).

How do I set up an Infoset for the HR application?

To set up an InfoSet for the HR application, proceed as follows: On the initial screen for maintaining InfoSets, enter a name for the InfoSet and choose Create . On the next screen, enter a name for the InfoSet and select one of the HR logical databases in accordance with your reporting requirements.

What database should I use to create Infosets for HR?

If you want to create InfoSets for HR, you can use logical databases PNP, PNPCE, PAP, and PCH (see HR Logical Databases ). The database you must use to create your InfoSet depends on the component in which the data you want to report on is stored.

What is the maintenance procedure for HR Infosets in SAP?

The maintenance procedure for HR InfoSets differs from the described procedure inasmuch as HR data fields are grouped together in infotypes. InfoSet management in SAP Query is also used for InfoSet Query. For more information, see Functions for Managing InfoSets .