This post will detail the list of important SAP HCR Tables (Humain Resource) or SAP HCM Tables.
SAP HCM Tables Tips
Note that for SAP HCM tables, with the suffix you may identify the HCM tables functionnality
- PA* – PA infotype tables
- PCL* – HR clusters
- PB* – recruitment tables
List of SAP HCM Tables
SAP PA Tables ( Personal Administration)
The first list of SAP HCM tables contains the PA ( Personal Administration Tables).
You can find the while list?Important SAP PA Tables.
SAP HR Master Data Tables
[table tablesorter=”o” class=”table table-border”]
SAP HR Master Data Tables, Description
PCL1,HR Cluster 1
PCL2,HR Cluster 2
T001P,Personnel Area/Subarea
T001T,Company code-dependenttexts
T500L,Personnel Country Grouping
T500P,Personnel Areas
T502T,Marital Status Designators
T503,Employee Group/Subgroup
T503T,Employee Subgroup Names
T508A,Work Schedule Rules
T510,Pay Scale Groups
T510A,Pay Scale Types
T510F,Assign Pay Scale — Currency
T510W,Pay Scale – Period Parameter Assignment
T511,Wage Types
T512T,Wage Type Texts
T512W,Wage Type Valuation
T512Z,Permissibility of Wage Types per Infotype
T527X,Organizational Units
T528T,Position Texts
T7XSSPERSUBTYP,Specify Use Case and Active Subtypes (timeconstraints)
T582A,Infotype attributes
T529T,Personnel Action Texts
T529U,Status Values
T530,Reasons for Actions
T530T,Reason for Action Texts
T549A,Payroll Accounting Areas
T549Q,Payroll Periods
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
T77PR,Creating authorization profile
T558B,Payroll Account Transfer- Payroll Periods
T569V,Control Records
T77UA,Setting user in a authorization profile
T77S0,System table
T5K8C,Transfer ext. payroll results into Canadian specific tables
T74FA,Benefit insurance plan
T74FC,Benefits Insurance Coverage Rule
[/table]
SAP Cross-Application Tables for HCM
Cross-Application HCM Tables regroups list of important SAP Tables to consider when dealing with SAP HR:
[table tablesorter=”o” class=”table table-border”]
Cross-Application Tables, Description
CATSCO,Cross-Application 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
CSKS,Cost Center Master Data
CSKT,Cost Center Texts
[/table]
SAP Infotype Tables for HCM
The list of SAP InfoType Tables for HCM ( Humain Capital Management) are:
[table tablesorter=”o” class=”table table-border”]
SAP InfoType HCM Tables, Description
HRP1000,Infotype 1000 DB Table (Objects)
HRP1001,Infotype 1001 DB Table (Relationships)
HRP1002,Infotype 1002 DB Table
HRP1003,Infotype 1003 DB Table
HRP1004,Infotype 1004 DB table
HRP1005,DB Table for Infotype 1005 (Planned Compensation)
HRP1006,Infotype 1006 DB table
HRP1007,Infotype 1007 DB Table
HRP1008,Infotype 1008 DB Table
HRP1009,Infotype 1009 DB table
HRP1010,Infotype 1010 DB table
HRP1011,Infotype 1011 DB Table
HRP1013,Infotype 1013 DB Table
HRP1014,Infotype 1014 DB Table
HRP1015,Infotype 1015 DB table
HRP1016,Infotype 1016 DB Table
HRP1017,Infotype 1016 DB Table
HRP1018,DB Table for Infotype 1018 Cost Distribution
HRP1019,DB Table for Infotype 1019 Required Positions
HRP1020,Infotype 1020 DB table
HRP1021,INFOTYPE 1021 DB TABLE
HRP1023,Infotype 1023 DB table
HRP1024,INFOTYPE 1024 DB TABLE
HRP1025,INFOTYPE 1025 DB TABLE
HRP1026,Infotype 1026 DB table
HRP1027,Infotype 1027 DB table
HRP1028,Infotype 1028 DB Table
HRP1029,Infotype 1029 DB table
HRP1030,Infotype 1030 DB table
HRP1031,Infotype 1031 DB table
HRP1032,Infotype 1032 DB Table
HRP1033,DB table for infotype 1033
HRP1034,Infotype 1034 DB table
HRP1035,Infotype 1035 DB Table
HRP1036,Infotype 1036 DB table
HRP1037,Infotype 1037 DB Table
HRP1038,Infotype 1038 DB table
HRP1039,Database Table for Infotype 1039
HRP1040,Database Table for Infotype 1040
HRP1041,DB Table for Infotype 1041
HRP1042,Infotype 1042 DB Table
HRP1043,DB Table for Infotype 1043
HRP1044,DB Table for Infotype 1044
HRP1045,DB Table for Infotype 1045
HRP1046,Database Table for Infotype 1046
HRP1047,DB Table for Infotype 1047
HRP1048,DB Table for Infotype 1048
HRP1049,Database Tables for Infotype 1049
HRP1050,DB Table for Infotype 1050 (Job Evaluation Results)
HRP1051,DB Table for Infotype 1051 (Survey Results)
HRP1060,DB Table for Infotype 1060
HRP1061,DB Table for Infotype 1061
HRP1062,DB Table for Infotype 1062
HRP1063,DB Table for Infotype 1063
HRP1201,Infotype 1201 DB Table
HRP1205,Infotype 1205 DB Table
HRP1206,Infotype 1206 DB Table
HRP1208,Infotype 1208 DB Table
HRP1209,Infotype 1209 DB Table
HRP1210,Infotype 1210 DB Table
HRP1211,Infotype 1211 DB Table
HRP1212,Infotype 1212 DB Table
HRP1213,Infotype 1213 DB Table
HRP1214,Infotype 1214 DB Table
HRP1215,Infotype 1215 DB Table
HRP1216,Infotype 1216 DB Table
HRP1217,Infotype 1217 DB Table
HRP1218,DB Table for Infotype 1218
HRP1220,DB Table for Infotype 1220 Activity Profile
HRP1221,DB Table for Infotype 1221 Excluded Activities
HRP1222,Infotype 1222- General attribute maintenance
HRP1230,DB Table for Infotype 1230
HRP1240,DB Table for Infotype 1240
HRP1250,DB table for infotype 1250
HRP1251,DB table for infotype 1251
HRP1252,DB table for infotype 1252
HRP1253,DB table for infotype 1253
HRP1254,DB Table for Infotype 1254
HRP1260,DB Table for Infotype 1260
HRP1270,DB Table for Info Type 1270
HRP1403,DB table for infotype 1403
HRP1404,DB table for infotype 1404
HRP1500,DB Table for Infotype 1500
HRP1501,DB Table for Infotype 1501
HRP1502,DB Table for Infotype 1502
HRP1503,DB Table for Infotype 1503
HRP1504,DB Table for Infotype 1504
HRP1505,DB Table for Infotype 1505
HRP1506,DB Table for Infotype 1506
HRP1507,DB Table for Infotype 1507
HRP1518,DB Table for Infotype 1518
HRP1519,DB Table for Infotype 1519
HRP1520,DB Table for Infotype 1520
HRP1600,Database Table for Infotype 1600
HRP1601,Database Table for Infotype 1601
HRPAD21,Additional data PAD21
HRPAD22,Additional data PAD22
HRPAD23,Additional data PAD23
HRPAD25,Additional data PAD25
HRPAD27,Additional data PAD27
HRPAD31,Additional data PAD31
HRPAD34,Additional Data for Relationship ‘has attended’
HRPAD44,PAD44 Additional Data
HRPAD47,PAD47 Additional Data
HRPAD48,Additional Data PAD48
HRPAD50,Additional Data PAD50
HRPAD51,Additional data PAD51
HRPAD53,Additional Data PAD53
HRPAD63,PAD63 Additional Data
HRPAD77,Additional data for PAD77
HRPADBLIST,Additional Data Databases
HRPADD2,Additional Data PADD2
HRPADD3,Additional Data PADD3
HRPADIC,Additional Data PADD2
HRPADNLIST,Additional Data Number List
HRPADNN,General Additional Data Table
HRPADP1,Additional Data PADP1
HRPADP2,Additional Data PADP2
HRPADPM,Additional Data PADPM
HRPADTI,PADTI Additional Data
HRPADUZ,PADUZ Additional Data- Requirements Assignment of Persons
HRPADXN,Additional Data PADXN
HRPS_T012K,For Decoupled Access to T012K (House Bank and Account)
HRPVAC,List of vacant positions
HRPXXXX,DB Table for Infotype XXXX
HRPYYYY,DB Table for Infotype YYYY
[/table]