Important list of SAP HR Tables including all the concepts of HR/HCM module such as employee master data, infotype, Personal Administration(PA), payroll, and other important HR DB tables.
SAP HR or SAP HCM Module is one the important modules that deals with Personal Administration, Organizational Management, Payroll, Travel Management & Time Management. As a SAP HR consultant, business user or development, knowing all the list of HR tables enables you to execute the report and increases working productivity.
SAP HR/HCM Tables
Refer below for the complete SAP HCM tables list by topic wise:
Personnel Administration Tables
The SAP HR personnel administration tables start with PA and it stores the employee master data and HR-related process.
| Table Name | Description |
| PA0000 | HR Master Record: Infotype 0000 (Actions) |
| PA0001 | HR Master Record: Infotype 0001 (Org. Assignment) |
| PA0002 | HR Master Record: Infotype 0002 (Personal Data) |
| PA0003 | HR Master Record: Infotype 0003 (Payroll Status) |
| PA0006 | HR Master Record: Infotype 0006 (Addresses) |
| PA0007 | HR Master Record: Infotype 0007 (Planned Working Time) |
| PA0008 | HR Master Record: Infotype 0008 (Basic Pay) |
| PA0014 | HR Master Record: Infotype 0014 (Recur. Payments/Deds.) |
| PA0015 | HR Master Record: Infotype 0015 (Additional Payments) |
| PA0027 | HR Master Record: Infotype 0027 (Cost Distribution) |
| PA0105 | HR Master Record: Infotype 0105 (Communications) |
Organizational Management (OM) tables
The SAP HCM organizational management (OM) tables start with the HRP and it deals with the structure, positions, and organizational units.
| Table Name | Description |
| HRP1000 | Infotype 1000 DB Table – Objects |
| HRP1001 | Infotype 1001 DB Table – Relationships |
| HRP1002 | Infotype 1002 DB Table – Description |
| HRP1003 | Infotype 1003 DB Table (Department/ Staff) |
| HRP1004 | Infotype 1004 DB table (Object Texts) |
| HRP1007 | Infotype 1007 DB Table (Vacancy) |
| HRP1013 | Infotype 1013 DB Table Employee Group/ Subgroup) |
Payroll Tables
The Payroll table stores the data related to the employee salary calculations and payments. The important tables of Payroll in HR as follows:
| Table Name | Description |
| T512W | Wage Type Valuation |
| PCL2 | HR Cluster 2 |
| T510 | Pay Scale Groups |
| T508A | Work Schedule Rules |
| T509H | Type of work permit |
| T510H | Payroll Parameters for time unit |
| T511K | Payroll Parameters |
| T515U | Hierarchy of Tables in Payroll Results |
Time Management (Time Record) Tables
Time Management in HR deals with employees’ working hours, attendance, leaves, and complete time recording information.
| Table Name | Description |
| TEVEN | Time Events |
| T555A | Time Types |
| PA2002 | HR Time Record: Infotype 2002 (Attendances) |
| PA2003 | HR Time Record: Infotype 2003 (Substitutions) |
| PA2006 | HR Time Record: Infotype 2006 (Absence Quotas) |
| PA2011 |
Recruitment(RC) Tables
| Table Name | Description |
| PB0002 | HR Master Record: Infotype 0002 (Personal Data) |
| PB0016 | Applicant Master Record Infotype 0016 (Contract Elements) |
Travel Management (TM) Tables
| Table Name | Description |
| PTRV_HEAD | General Trip Data |
| PTRV_PERIO | Period Data of a Trip |
| PTRV_ADMIN | Travel Management – Administration Data for personnel number |
| PTRV_SHDR | Trip Statistics – Trip Amounts |