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.
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.
Would you like to see this full item?