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