List of Tables in SAP HR - palermo-consulting/sap-training-guides GitHub Wiki

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

  • 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

SAP Cross-Application Tables for HCM

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

  • 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

SAP Infotype Tables for HCM

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

  • 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