SAP HR Tables

Posted by Unknown On

LIST OF TABLES IN SAP HR


List of useful SAP HR standard tables.
Following are some useful tables using by SAP HR Consultants. Use transaction SE16 or SE16 or se11 to see the data maintained in tables.
All personnel administration tables  are start with PA and the infotype number behind it.  Eg: table of info type 0105 is PA0105.
All personnel development/OM tables start with HRP and infotype behind it.  Eg: table of info type 1005 is HRP1005.
All recruitment tables starts with PB with corresponding info type number.

PA Tables

T001P Personnel Area/Subarea
T001T Company code-dependent texts
T500L Personnel Country Grouping
T500P Personnel Areas
T502T Marital Status Designators
T503 Employee Group/Subgroup
T503T Employee Subgroup Names
T528T Position Texts
T529T Personnel Action Texts
T529U Status Values
T530 Reasons for Actions
T530T Reason for Action Texts
T000    Clients 
T001    Company Codes 
CSKT Cost Center Texts
CSKS Cost Center Master Data
T777T Infotypes
T777Z Infotype Time Constraints
T778T Infotypes
T778U Subtypes
 T527X Organizational Units
 
Time management tables

T550A Daily Work Schedule
T550S Daily Work Schedule Texts
T551S Period Work Schedule Texts
T552A Monthly Work Schedule
T554C Absence Valuation
T554S Attendance and Absence Types
T554T Attendance and Absence Texts
T508A Work Schedule Rules
T511 Wage Types
T512T Wage Type Texts
T512W Wage Type Valuation
T512Z Permissibility of Wage Types per Infotype
CATSCO  CrossApplication Time Sheet (CATS)- Transfer to CO
CATSDB  CATS Database Table for Time Sheet
CATSHR  Cross-Application Time Sheet (CATS)- Transfer to HR
CATSMM Cross-Application Time Sheet (CATS)- Transfer to MM
CATSPM  Cross-Application Time Sheet (CATS)- Transfer to PM/CS
CATSPS Cross-Application Time Sheet (CATS)- Transfer to PS

Payroll tables

T549A Payroll Accounting Areas
T549Q Payroll Periods
T558B Payroll Account Transfer- Payroll Periods
T569V Control Records
T510 Pay Scale Groups
T510A Pay Scale Types
T510F Assign Pay Scale 

 T510W Pay Scale – Period Parameter Assignment
PCL1 HR Cluster 1
PCL2 HR Cluster 2