Main Content

Query Manager

Finally, a complete SAP HR reporting solution!

Add muscle to your reporting capabilities with EPI-USE's Global Reporting Tool – Query Manager. This tool is easy to use and it's interface vastly extends access to SAP HR information by offering interactive queries and detailed reporting. Query Manager allows the query and reporting of 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, e.g. "Create a monthly report showing employees total cost data by cost center, including the cost information based on % splits or cost center reassignments."
  • Time Results: leave balances and quotas, e.g. "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: e.g. "Download into Excel all 401K and benefits deductions grouped by cost center for the month."

Easy to Use Interface

Screenshot: Tax Report Example

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.

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® software releases

Supports 4.6c, 4.7, mySAP™ ERP 2004, and SAP® ERP 6.0.

More information

For more information, download the datasheet or fill out the contact form.