List of important SAP HCM Tables (Human Capital Management)

sap pa tcodes, SAP CRM Customer RelationShip Management

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

SAP HR Master Data Tables Description
PCL1HR Cluster 1
PCL2HR Cluster 2
T001PPersonnel Area/Subarea
T001TCompany code-dependenttexts
T500LPersonnel Country Grouping
T500PPersonnel Areas
T502TMarital Status Designators
T503Employee Group/Subgroup
T503TEmployee Subgroup Names
T508AWork Schedule Rules
T510Pay Scale Groups
T510APay Scale Types
T510FAssign Pay Scale — Currency
T510WPay Scale – Period Parameter Assignment
T511Wage Types
T512TWage Type Texts
T512WWage Type Valuation
T512ZPermissibility of Wage Types per Infotype
T527XOrganizational Units
T528TPosition Texts
T7XSSPERSUBTYPSpecify Use Case and Active Subtypes (timeconstraints)
T582AInfotype attributes
T529TPersonnel Action Texts
T529UStatus Values
T530Reasons for Actions
T530TReason for Action Texts
T549APayroll Accounting Areas
T549QPayroll Periods
T550ADaily Work Schedule
T550SDaily Work Schedule Texts
T551SPeriod Work Schedule Texts
T552AMonthly Work Schedule
T554CAbsence Valuation
T554SAttendance and Absence Types
T554TAttendance and Absence Texts
T77PRCreating authorization profile
T558BPayroll Account Transfer- Payroll Periods
T569VControl Records
T77UASetting user in a authorization profile
T77S0System table
T5K8CTransfer ext. payroll results into Canadian specific tables
T74FABenefit insurance plan
T74FCBenefits Insurance Coverage Rule

SAP Cross-Application Tables for HCM

Cross-Application HCM Tables regroups list of important SAP Tables to consider when dealing with SAP HR:

Cross-Application Tables Description
CATSCOCross-Application Time Sheet (CATS)- Transfer to CO
CATSDBCATS- Database Table for Time Sheet
CATSHRCross-Application Time Sheet (CATS)- Transfer to HR
CATSMMCross-Application Time Sheet (CATS)- Transfer to MM
CATSPMCross-Application Time Sheet (CATS)- Transfer to PM/CS
CATSPSCross-Application Time Sheet (CATS)- Transfer to PS
CSKSCost Center Master Data
CSKTCost Center Texts

SAP Infotype Tables for HCM

The list of SAP InfoType Tables for HCM ( Humain Capital Management) are:

SAP InfoType HCM Tables Description
HRP1000Infotype 1000 DB Table (Objects)
HRP1001Infotype 1001 DB Table (Relationships)
HRP1002Infotype 1002 DB Table
HRP1003Infotype 1003 DB Table
HRP1004Infotype 1004 DB table
HRP1005DB Table for Infotype 1005 (Planned Compensation)
HRP1006Infotype 1006 DB table
HRP1007Infotype 1007 DB Table
HRP1008Infotype 1008 DB Table
HRP1009Infotype 1009 DB table
HRP1010Infotype 1010 DB table
HRP1011Infotype 1011 DB Table
HRP1013Infotype 1013 DB Table
HRP1014Infotype 1014 DB Table
HRP1015Infotype 1015 DB table
HRP1016Infotype 1016 DB Table
HRP1017Infotype 1016 DB Table
HRP1018DB Table for Infotype 1018 Cost Distribution
HRP1019DB Table for Infotype 1019 Required Positions
HRP1020Infotype 1020 DB table
HRP1023Infotype 1023 DB table
HRP1026Infotype 1026 DB table
HRP1027Infotype 1027 DB table
HRP1028Infotype 1028 DB Table
HRP1029Infotype 1029 DB table
HRP1030Infotype 1030 DB table
HRP1031Infotype 1031 DB table
HRP1032Infotype 1032 DB Table
HRP1033DB table for infotype 1033
HRP1034Infotype 1034 DB table
HRP1035Infotype 1035 DB Table
HRP1036Infotype 1036 DB table
HRP1037Infotype 1037 DB Table
HRP1038Infotype 1038 DB table
HRP1039Database Table for Infotype 1039
HRP1040Database Table for Infotype 1040
HRP1041DB Table for Infotype 1041
HRP1042Infotype 1042 DB Table
HRP1043DB Table for Infotype 1043
HRP1044DB Table for Infotype 1044
HRP1045DB Table for Infotype 1045
HRP1046Database Table for Infotype 1046
HRP1047DB Table for Infotype 1047
HRP1048DB Table for Infotype 1048
HRP1049Database Tables for Infotype 1049
HRP1050DB Table for Infotype 1050 (Job Evaluation Results)
HRP1051DB Table for Infotype 1051 (Survey Results)
HRP1060DB Table for Infotype 1060
HRP1061DB Table for Infotype 1061
HRP1062DB Table for Infotype 1062
HRP1063DB Table for Infotype 1063
HRP1201Infotype 1201 DB Table
HRP1205Infotype 1205 DB Table
HRP1206Infotype 1206 DB Table
HRP1208Infotype 1208 DB Table
HRP1209Infotype 1209 DB Table
HRP1210Infotype 1210 DB Table
HRP1211Infotype 1211 DB Table
HRP1212Infotype 1212 DB Table
HRP1213Infotype 1213 DB Table
HRP1214Infotype 1214 DB Table
HRP1215Infotype 1215 DB Table
HRP1216Infotype 1216 DB Table
HRP1217Infotype 1217 DB Table
HRP1218DB Table for Infotype 1218
HRP1220DB Table for Infotype 1220 Activity Profile
HRP1221DB Table for Infotype 1221 Excluded Activities
HRP1222Infotype 1222- General attribute maintenance
HRP1230DB Table for Infotype 1230
HRP1240DB Table for Infotype 1240
HRP1250DB table for infotype 1250
HRP1251DB table for infotype 1251
HRP1252DB table for infotype 1252
HRP1253DB table for infotype 1253
HRP1254DB Table for Infotype 1254
HRP1260DB Table for Infotype 1260
HRP1270DB Table for Info Type 1270
HRP1403DB table for infotype 1403
HRP1404DB table for infotype 1404
HRP1500DB Table for Infotype 1500
HRP1501DB Table for Infotype 1501
HRP1502DB Table for Infotype 1502
HRP1503DB Table for Infotype 1503
HRP1504DB Table for Infotype 1504
HRP1505DB Table for Infotype 1505
HRP1506DB Table for Infotype 1506
HRP1507DB Table for Infotype 1507
HRP1518DB Table for Infotype 1518
HRP1519DB Table for Infotype 1519
HRP1520DB Table for Infotype 1520
HRP1600Database Table for Infotype 1600
HRP1601Database Table for Infotype 1601
HRPAD21Additional data PAD21
HRPAD22Additional data PAD22
HRPAD23Additional data PAD23
HRPAD25Additional data PAD25
HRPAD27Additional data PAD27
HRPAD31Additional data PAD31
HRPAD34Additional Data for Relationship 'has attended'
HRPAD44PAD44 Additional Data
HRPAD47PAD47 Additional Data
HRPAD48Additional Data PAD48
HRPAD50Additional Data PAD50
HRPAD51Additional data PAD51
HRPAD53Additional Data PAD53
HRPAD63PAD63 Additional Data
HRPAD77Additional data for PAD77
HRPADBLISTAdditional Data Databases
HRPADD2Additional Data PADD2
HRPADD3Additional Data PADD3
HRPADICAdditional Data PADD2
HRPADNLISTAdditional Data Number List
HRPADNNGeneral Additional Data Table
HRPADP1Additional Data PADP1
HRPADP2Additional Data PADP2
HRPADPMAdditional Data PADPM
HRPADTIPADTI Additional Data
HRPADUZPADUZ Additional Data- Requirements Assignment of Persons
HRPADXNAdditional Data PADXN
HRPS_T012KFor Decoupled Access to T012K (House Bank and Account)
HRPVACList of vacant positions
HRPXXXXDB Table for Infotype XXXX
HRPYYYYDB Table for Infotype YYYY

Source:?SAP PA?(Personnel Administration) Tables