Two Ways to Easily Access Payroll Information

  • by Rehan Zaidi, Senior SAP Technical Consultant
  • July 15, 2005
Accessing past payroll information can be confusing if you do not know about the relevant storage architecture and code. Learn how R/3 uses the concept of clusters to store information. Find out about two approaches to access payroll information that is stored in clusters.
Key Concept
For most data pertinent to SAP applications, two methods are available for accessing information stored in the database. You can use either a logical database or import statements/standard function modules. The same rule is applicable while trying to access payroll results. Logical database PNP is available for the first method. You can also use import statements/function modules, which requires more coding. This is commonly referred to as “without PNP.”

For more information on clusters, refer to my HR Expert article, “Use Clusters to Access Infotype Texts.” For a helpful download about clusters, click here: Learn more about clusters.
I have used the generic name RX to describe the cluster in which payroll results reside. This name varies according to your country grouping; for example, RU for the US, RG for Great Britain, and RX for international. The country groupings and their respective cluster IDs are stored in database table T500L. View the table contents to find out the cluster for your particular country grouping.

You may need to access information stored in payroll results for display in your reports and queries. This technique works for all payrolls that have been executed in R/3 in the update mode, whether they are of the current month or past months. For example, your user may ask for a report that generates the total of basic pay paid to employees within a certain period of time. Retrieving such field information in programs may sometimes be confusing for developers and consultants. Unlike other fields of the infotype, R/3 does not allow you to view these results through the Data Browser.

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


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.