Part 2: Build a Reporting Hierarchy for Your Org Structure Using Custom Objects

  • by Heather Clubb, HRIS Strategic Business Analyst
  • April 15, 2007
Follow these simple instructions to report on your custom hierarchical matrix.
Key Concept

An InfoSet is the backbone to all queries you run through SAP Query and InfoSet Query. It is a collection of field groups with combined data fields that make up the reportable data set. Think of it as an Access database that you would use to query tables. Any time you add a custom object in your SAP system, you have to add those objects to your InfoSets as an additional field so they are reportable for your users.

To report off your organizational structure, you might choose to use Organizational Management (OM). However, custom objects that you set up in OM will not be available in your predefined logical databases. You can establish relationships using custom objects (object types that don’t come standard within SAP) for functional areas to build a company-wide hierarchical matrix. Once you’ve built this matrix (which I explained in “Build a Reporting Hierarchy for Your Org Structure Using Custom Objects” in HR Expert, November 2006), you must add those objects to your InfoSets so they are reportable in InfoSet Query and SAP Query.

To add these objects, you need to have the proper authorization to add basic code to your InfoSets. Some companies only let their IT groups make this type of change and others allow their functional analysts to do this.

Heather Clubb

Heather Clubb is a senior business analyst for HRIS. She has more than seven years of experience in designing, maintaining, and implementing HR modules. She has been involved with several data conversions and a reimplementation of HR modules. Heather’s expertise lies within Personnel Administration, Organizational Management, Recruitment, Training & Event Management, and SAP Query. She spoke at the HR 2006 and the Reporting & Analytics 2006 conferences. Heather also earned a BS degree in information systems.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.