Integrate Sap Query into ESS and MSS Reporting Launchpad in EHP6

[Former Member]

Create Custom Sap Query in ECC and integrate with MSS Reporting Launchpad:

MSS Reporting Launchpad integration with MDT provides flexibility for adding Custom SAP queries into MSS reports.

The business benefit is that there is no need of creating additional authorisation objects and redesign the SAP ABAP Web dynpro reports similar to SAP Queries to restrict managers to view only the details of his/ her own direct / indirect reports

This document explains step by step configuration of bringing SAP Queries into MSS Reporting Launchpad.

Step1: Create a custom query for example in T.Code SQ01

Step2: Generate the query

Query-->More Functions-->Generate Program

This will generate a program in Table TRDIR

Step3: IMG-->Manager’s Desktop-->Enhancement of Function Codes-->Define Function Codes

Step4: IMG-->Manager’s Desktop-->Enhancement of Function Codes-->Define Structure of Function Codes

Step5: IMG-->Human Resources Information System-->Define Task Functions

Note: The program name entered here should be from Table TRDIR

Step6: Run Program: RP_MSS_CONVERT_MDT_TO_LPD_CUST

Step7: Got to T.code LPD_CUST

Note: System creates a new node for Employee Data with New MDT Entries and generates the reports in it. You can drag and drop in Employee Data Node.

Also system generates a number which is different from Table T77I3.

Step8: Goto to portal and Login as Manager and see the out put of the Report

Click on Launch Report to view the output of the report.

Enjoy working with SAP HCM:-)