Skip to Content
Author's profile photo Former Member

Procedure for SAP query in SAP HR

Reporting using SAP Query  tool is as follows:

Creating Query : Go to transaction SQ01, if it doesn’t mention the user group that you just created then click on

ScreenHunter_101 Jan. 25 09.01.jpg

Now give a name for the query, in our case ZHR_EMPDET and click Create

ScreenHunter_102 Jan. 25 09.03.jpg

Select the infoset that was created from the list and click Ok icon

ScreenHunter_103 Jan. 25 09.04.jpg

Give a meaningful title for your report. Click on

ScreenHunter_104 Jan. 25 09.05.jpg

ScreenHunter_105 Jan. 25 09.08.jpg

The fields that you require to be in the output of the report click on check box in List Column next to that field as shown below….select cost centre, employee name , position from Data fields on the left of the screen….and save

ScreenHunter_106 Jan. 25 09.09.jpg

Now go back to first screen of transaction SQ01, it will show the query that was just created, click on execute to test the query by inputing any selection criteria…in this scenario, Personnel Area (SAML) taken….

ScreenHunter_107 Jan. 25 09.11.jpg

ScreenHunter_108 Jan. 25 09.11.jpg

Click on execute to see the report as follows

ScreenHunter_109 Jan. 25 09.13.jpg

Assigned tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.