Skip to Content
Author's profile photo Former Member

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:-)

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Informative Article !

      Author's profile photo Rajasekar Thangaraj
      Rajasekar Thangaraj

      Great way to use SAP Query in MSS Reporting .

      Thanks for Sharing.

      Author's profile photo Former Member
      Former Member

      Hello

      I am wondering if you can help

      I am trying to run program RP_MSS_CONVERT_MDT_TO_LPD_CUST and i being told it doesn't exist.


      I have found program APB_LPD_LPA_CUST_TO_LPD_CUST which is doing a conversion but it is missing vital information like the system alias', so my applications won't launch.


      Any ideas?



      Author's profile photo Former Member
      Former Member

      Thanks for the info 🙂

      Are MSS REP and MSS REP2 reports running Web Dynpro ABAP or is one of the launchpads running SAPGUI HTML via ITS?

      Author's profile photo Vijay agarwal
      Vijay agarwal

      Hi Finderup,

      Did you find out answers.As I am trying to activate MSS Reports as explained above. But after all settings Report output open in SAPGUI HTML . We want output in WD ABAP. Are there any other way to get WD abap based reports. As output in GUI HTML will provide employee to backend access.

       

      Thanks,

      VJ

      Author's profile photo Jazib Tariq
      Jazib Tariq

      Hello Gita,

       

      I am getting below issue in MSS report. Kindly reply if you know the solution.

      https://answers.sap.com/questions/157085/mss-reporting-issue-function-code-his-rezzs-18-doe.html

      Author's profile photo Jean-Michel Lukowski
      Jean-Michel Lukowski

      Hi all!

      It has been asked to me to had the "my reports" lane to the employees / ESS role.

      Is it possible? And if yes how??

      I added the attended role into the parameter "HRMSS_REPORT_LPD" in the "Personalization" tab of the corresponding role but without any effect. I hoped that the lane will automaticaly been Added but it is not the case!

      Any help is welcomed 😉

      Thanks,

      Christophe.