Blogs

Bring your HR queries to MSS with 1 click Koen Van Loocke  Business Card Company: Zurich Insurance Company Posted on Sep. 07, 2010 07:15 AM in ABAP, Human Capital Management, Web Dynpro

Subscribe Print Permalink Share

 

 

 

The user experience is pretty straight forward. A dropdown with the available queries is shown. Once the user selects a query, the result for his team members is shown in the grid. From there the standard ALV functionality can be used for further processing.

 

Technically, in the loading of the page, the team of the logged in user is read from the database using the standard team viewer functionality, called by function module HRWPC_RFC_GET_OBJECTS. The viewID can be specified in the url parameter Q_TEAMVIEW in the calling application and is defaulted to A_DIR.

The query list is retrieved using the function module RSAQ_READ_QUERY_CATALOG. The parameters for this function module are again provided by parameters in the URL

Q_USERGROUP, defaulted to /SAPQUERY/H2
Q_WORKSPACE, defaulted to G

Once the user selects a query from the dropdown, the query is executed using function module RSAQ_QUERY_CALL and the result is passed to the ALV WDA component. The internal table with the query results contains '-' in the field names. The WDA ALV component does not support this, so the RTTS is called to the rescue.

The whole coding contains less than 500 lines of code.

So far the short summary of the coding, the complete source code of this application is available as a nugget and can be downloaded here. The nugget will install these 2 components

WDYN ZSDN_MSSQUERIES
WDYA ZSDN_MSSQUERIES

How to install the nugget can be found here 

Koen Van Loocke   is currently working as a program manager for www.zurich.com

Comment on this weblog

Showing messages 1 through 5 of 5.
Titles Only	Main Topics	Oldest First

• Much better than Manager Desktop converted to webgui reporting !
  2010-09-07 07:34:45 Martin Gillet Business Card [Reply]
  
  Hi Koen,

  
  Thanks for sharing this, it looks quite nice/better than the standard reporting provided through webgui and Manager Desktop configuration to Manager Self Services...
  I'll surely test it soon.

  
  Thanks again,
  Martin

• Thanks for sharing
  2010-09-07 07:20:40 Thomas Jung  Business Card [Reply]
  
  It is great that you are sharing this solution with everyone. It is a nice way to reuse your existing infoset queries. Did you explorer the possibility of using POWL as well? Reporting POWL has standard functionality to call existing Infoset Queries as its data source - also a good way to reuse inforset queries.
  • Thanks for sharing
    2010-09-07 08:02:30 Koen Van Loocke Business Card [Reply]
    
    Hi Thomas,

    
    thanks for your comment. I did not explore POWL yet, but this prototype could be easily enhanced to display any kind of data which is in a flat internal table.

    • Thanks for sharing
      2010-09-07 08:04:47 Thomas Jung  Business Card [Reply]
      
      I'm not sure I was clear. I wasn't suggesting that your prototype should also consume POWL, but instead that POWL already has very similiar functionality in standard to what your application does.
      • Thanks for sharing
        2010-09-07 08:07:22 Koen Van Loocke Business Card [Reply]
        
        Now I got it. No I did not explore that route. It will be one of my next endeavours. Thanks for the hint.