View Report of All Employees
What You Need to Know:
Question: Is there a report that will show all of my employees time (leave and working time) in one report?
Answer: Yes. In SAP these are the terms that refer to this function: SPINIFEXIT EASY REPORTER, Transaction: /SPIN/ER
- Add this transaction to your favorites by clicking the Favorites button, and choosing Insert Transaction:
- Enter the transaction:
- The Easy Reporter transaction will now appear in your favorites list for quick access. If you do not want to add this transaction to your favorites, you will need to enter /n/SPIN/ER in the transaction box to run Easy Reporter.
- To access the timesheet reports, open /SPIN/ER. Expand the Company Reporting folder and Time Reports folder to see the two timesheet reports. Double click either report to start:
- TIMESHEET_TOTALS report: shows totals information only for employees, which can be sorted by amount. (You can also create variants for reports on the Information tab at the bottom of the screen – instructions for creating variants are at the end of this document):
- The three tabs at the top represent the steps in the process. First enter the Report Data Period, which represents the payroll period. It defaults to the current period, but you can choose “other” period:
- Next, go to Select Employees to enter the employees individually, or by org unit. You can enter org unit ID’s using the Organizational Unit field, or use the Org Selection to get the Organizational Structure to choose from. You should always select the Payroll Area so that you only get the biweekly (or monthly) employees:
- Lastly, go to Run the Report to get report results. You can execute the report in the foreground, background, or schedule it in the background. You will probably execute in the foreground for reports that contain a small or minimal amount of data. Run reports in the background for large amounts of data (such as for hundreds of employees):
- You can choose to run the report in Run in Window mode or Run Full Screen mode. Run in Window will display the report output within the Easy Reporter window. Run in Full Screen mode will display the results across the entire screen. Here is the report output run in foreground using Full Screen mode:
- TIMESHEET report: this report shows more detail on time and leave entry, including dates, codes, etc. The same information for the same tabs will be needed as for the Timesheet Totals report.
First enter the Report Data Period, which represents the payroll period:
- Next, go to Select Employees to enter the employees individually, or by org unit. Again if you are looking at a specific payroll period you should enter that Payroll Area here:
- Lastly, go to Run the Report to get report results. To see more detail on any employee’s working time or leave, click the Expand Selection icon next to the employee name:
- This report can be saved as a spreadsheet. Click the Local File icon and choose Spreadsheet.
- You can then search your directory for the correct location for which to save the report, choose the file name, and click Generate:
- VARIANTS: After running a few reports, you may wish to save your version of the report data as a variant. Once you have a report open with the Report Data Period and Select Employees data entered, select the Save Report Variant icon from the toolbar. A dialog box will appear for you to name your variant:
- Enter a name for your variant and click the Save Variant button. Your variant will now appear on the Information tab at the bottom of the screen as a selection choice when you open the report. Select the button next to the report you wish to run. Go directly to the Run the Report button to get your report results. Please select the user specific variant so that only you can see and use it. If you need assistance running a report, you will need to change the variant to global so that we can see the variant and assist you.