Skip to Content

Integrate Sap Query into ESS and MSS Reporting Launchpad in EHP6

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

/wp-content/uploads/2014/01/1_354443.png

Step2: Generate the query

Query–>More Functions–>Generate Program

This will generate a program in Table TRDIR

/wp-content/uploads/2014/01/2_354445.png

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

/wp-content/uploads/2014/01/3_354458.png

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

/wp-content/uploads/2014/01/4_354460.png

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

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

/wp-content/uploads/2014/01/5_354479.png

Step6: Run Program: RP_MSS_CONVERT_MDT_TO_LPD_CUST

/wp-content/uploads/2014/01/6_354480.png

Step7: Got to T.code LPD_CUST

/wp-content/uploads/2014/01/7_354490.png

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/wp-content/uploads/2014/01/8_354492.png

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

/wp-content/uploads/2014/01/9_354506.png

Enjoy working with SAP HCM:-)

6 Comments
You must be Logged on to comment or reply to a post.