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
Now give a name for the query, in our case ZHR_EMPDET and click Create
Select the infoset that was created from the list and click Ok icon
Give a meaningful title for your report. Click on
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
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….
Click on execute to see the report as follows