Two Methods to Access OM Data Quickly and Easily

  • by Rehan Zaidi, Senior SAP Technical Consultant
  • June 15, 2006
Learn about the two most popular ways to access Organizational Management data and discover when to use each method.
Key Concept
Two approaches are common with the retrieval process of most SAP information. The first is to access the data via a standard logical database. The other approach is based on using function modules along with more ABAP coding. The Organizational Management module uses the PCH logical database.

With SAP R/3, you can store the entire organizational hierarchy of your company along with relevant positions and job descriptions within the Organizational Management (OM) submodule. You may need to access data stored in OM to display in your reports and queries.

For example, a user may ask for a report that generates a list of all positions within a certain company department. Retrieving such field information may be confusing because OM data storage differs from that of the Personnel Administration (PA) module. SAP documentation does not fully explain how to access OM data.

Although SAP provides standard OM reports and Ad Hoc Query, you may need to develop custom reports to access your data when:

  • You have a fixed report format (layout) that is too specific and you cannot use a standard SAP report or the Ad Hoc Query output
  • Users demand a form-like or tabular output
  • You face unique requirements (that Ad Hoc Query cannot fulfill) that call for more fields than what an SAP standard report contains
  • Users want to view OM information along with other submodules or application information in one report

You could use two different approaches for accessing the information stored in OM. The first approach uses SAP-provided logical database PCH and involves coding within the GET OBJEC event.

You can use the second one in programs and queries with or without this logical database. For more information about GET OBJEC, refer to the sidebar “The GET OBJEC Event.”

I will start by explaining the storage architecture of OM data and the transaction that you can use to view them. Then, I’ll compare and discuss the two approaches and their advantages and limitations. I will also provide debugging tips for each of the two approaches. Functional analysts with the appropriate security and authorizations can use a custom ABAP program or query to access the relevant data by following these steps.

Rehan Zaidi

Rehan Zaidi is a consultant for several international SAP clients (both on-site and remotely) on a wide range of SAP technical and functional requirements, and also provides writing and documentation services for their SAP- and ABAP-related products. He started working with SAP in 1999 and writing about his experiences in 2001. Rehan has written several articles for both SAP Professional Journal and HR Expert, and also has a number of popular SAP- and ABAP-related books to his credit.

See more by this author


Comments

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.