Main Content

Query Manager

EPI-USE America is celebrating the Year of SAP Tools

Finally, a Complete SAP HCM Reporting Tool

Add muscle to your reporting capabilities with EPI-USE’s Global Reporting Tool – Query Manager. This tool’s easy to use interface vastly extends access to SAP HR information by offering interactive queries and detailed reporting. Query Manager allows querying and reporting on Master Data, HR Cluster Data, PA and PD Infotypes, HR Configuration Tables, Audit Trail (PCL4), and User Master Data.

Advanced Cluster Reporting

Query Manager (QM) is the only query tool that allows detailed reporting on payroll and time results stored within the SAP HR clusters.

  • Payroll Results: breakdown of retro-results, payroll accumulations and wage type split details, for example “Create a monthly report showing employees total cost data by cost center, including the cost information based on percentage splits or cost center reassignments.”
  • Time Results: leave balances and quotas, for example “List employees in my division who took less than 10 hours sick leave last quarter” or “Query on the overtime counter to report on employees who will start to receive overtime at a given point in time.”
  • Master Data and Results Combination: for example “Download into Excel all 401K and benefits deductions grouped by cost center for the month.”

Easy-to-Use Interface

Query Manager eliminates the gap between those who need information and those who can access it. All users can now employ the power of SQL by using a simple drag-and-drop interface. The "query by example" abstraction enables the use of powerful data retrieval features while hiding the complexity of native SQL.

Query Manager Screen Capture

The Query Manager Advantage

  • Create reports without the need for an ABAP programmer.
  • Generate reports from live data without having to first extract the data into an external file.
  • Query Manager generates a normal PA or PD logical database ABAP report. Standard HR authorizations and use of default selection screens are automatically supported.
  • Complete scalability. Query Manager employs the most optimal ABAP coding techniques to deliver reports that perform even better than "hand written" reports.
  • Relieves users of the need to realign report development from one SAP HR release to the next plus Query Manager seamlessly integrates with SAP Query.

Supported SAP/mySAP releases

Query Manager supports SAP R/3 versions 4.6B, 4.6C, and Enterprise.

Datasheet

Download the Query Manager Datasheet (PDF: 225 KB) for more information.