GRC
HR
SCM
CRM
BI


Blog

 

Tips for creating an HR and payroll report using SAP query

by Danielle Larocca

June 14, 2011

Tips for creating an HR and payroll report using SAP query

This HR tip comes directly from a presentation I delivering at HR 2011 called “Overcome the most frustrating HR and payroll reporting challenges using SAP query”.

Create an HR/Payroll Report using SAP Query

  • Go to Transaction Code SQ01
  • Enter a name for your report in the Query field and click the Create button
  • You will be prompted to select a data source (these are setup separately see article) 

You Walk Through 7 Basic Screens to Create a Report

1. Give the report a name

2. Select infotypes

3. Select fields from the infotypes

4. Add fields to the report selection screen (optional)

5. Specify the order and output of your fields

6. Fill out the selection screen

7. Your finished report!

Screen #1 – Title Format

  • Enter a name for your report in the Title field
  • Select the Save button
  • Use the Forward arrow button to move to the next screen

Screen #2 – Select Field Groups

  • Place a checkmark next to each infotype that you want to include fields from
  • Use the Forward arrow button to move to the next screen

& nbsp;Screen #3 – Select Fields

  • The infotypes will then list all of the fields on that infotype. Select the fields to include in your report.
  • Place a checkmark next to each infotype that you want to include fields from
  • Use the Forward arrow button to move to the next screen

Screen #4 – Add Fields to the Selection Screen

  • This screen lists all fields selected on the previous screen 
  • Place a checkmark next to each field that you want to appear on the reports “Selection Screen” upon execution
  • Use the Basic List button to move to the next screen

 Screen #5 – Basic List Line Structure Screen

  • Specify the Line you want each field to appear on
  • Specify the Sequence you want the fields in
  • Indicate any Sort, Total or Count as needed by field

 Screen #6 – Selection Screen

  • Whenever a report is executed in SAP, a “Selection Screen” appears giving you the opportunity to specify what data you want to see in the output (i.e., data as of today for active associates in the US only)
  • Select the F8 button on your keyboard to execute the report

Screen #7 – Your Finished Report

For more on HR reporting, join me on Tuesday June 21 at 1pm for a live Q&A.

Register here --  sapinsider.com/daniellelaroccahrforum -- and download a preview of the new, updated version of my HR Expert article “5 HR Reporting Options : How Do You Choose?". Then post any of your HR reporting questions for the one-hour Q&A, Tuesday, June 21 1-2pm ET on Insider Learning Network.

 

An email has been sent to:






More from SAPinsider



COMMENTS

Please log in to post a comment.

No comments have been submitted on this article. Be the first to comment!


SAPinsider
FAQ