SAP Payroll Process Tables
Are you looking for the right table related to SAP Payroll Process Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Payroll Process (PY-XX-PYP) module.
Top 10 tables in Payroll Process
| Table | Description |
|---|---|
| PYC_D_PTCT | Payroll Process Template Category Text |
| PYD_D_UICT | Payroll Data Source UI Category Text |
| PCTR_T_AUTH_ORG | PCTR auth. structural org management Auth level config |
| P2RX_ALP | Alternative Payment Table ALP |
| PYC_D_BO_PMROCR | PYC: PMR Off-Cycle Reason BO |
| P2RX_DFT | Payroll Results: Differences for Gross/Net Payroll |
| P2RX_VERSC | Payroll Status Information |
| P2RX_WPBP_INDEX | HRDCD HELPER TABLES FOR WPBP |
| P2RX_ABC | Cumulation of Absence Classes |
| P2RX_V0 | Variable Assignment |
List of tables in Payroll Process
| Table | Description |
|---|---|
| PYC_D_PTCT | Payroll Process Template Category Text |
| PYD_D_UICT | Payroll Data Source UI Category Text |
| PCTR_T_AUTH_ORG | PCTR auth. structural org management Auth level config |
| P2RX_ALP | Alternative Payment Table ALP |
| PYC_D_BO_PMROCR | PYC: PMR Off-Cycle Reason BO |
| P2RX_DFT | Payroll Results: Differences for Gross/Net Payroll |
| P2RX_VERSC | Payroll Status Information |
| P2RX_WPBP_INDEX | HRDCD HELPER TABLES FOR WPBP |
| P2RX_ABC | Cumulation of Absence Classes |
| P2RX_V0 | Variable Assignment |
| P2RX_BENTAB | Benefits payroll results international |
| P2RX_EVAL_PERIOD | Index for Payroll Results Periods |
| P2RX_GRT | Payroll Results: Results Table |
| P2RX_VCP | Payroll Results: Leave Deduction |
| HRDCT_D_FIELDS | Fields Renamed in Declustered Tables for Reserved Words |
| P2RX_RT_GP | Payroll Result: Payroll for Global Employees |
| PYD_D_UIC | Payroll Data Source UI Category |
| PYD_D_SHL | Payroll Data Source Shadow Log |
| PYD_D_SHI | Payroll Data Source Shadow Item |
| P2RX_VERSION | Information on Creation |
| PYD_D_TYT | Payroll Data Source Type Text |
| PYD_D_SOLT | PCC: Validation Rule Solution Descriptions |
| PYD_D_WT_VAR | Payroll Data Source Framework : Wrap-up Reports Variants |
| PYD_D_RES | Payroll Data Source Result |
| PYD_D_US | Payroll Data Source Framework: User Session |
| PYD_D_NSCT | PYDS: Namespace for Simplified Configuration Category Text |
| P2RX_ACCR | Payroll Result: Month End Accruals |
| PYD_D_UV | Payroll Data Source Framework: User Variant |
| PYD_D_NSEXC | PYDS: Whitelist for Simplified Configuration |
| PCTR_T_AUTH_LEVT | PCTR auth level text |
| PYD_D_SOLVAR | PCC: Validation Rule Solution Variables |
| PYD_D_TYPTRRDT | Payroll Data Source Type Par. Ty. Result Details Type Asgmt. |
| PYD_D_TYPTIV | Payroll Data Source Type Input Parameter with Value |
| PYD_D_DAE_REG | PYDS: Scheduling Use Case Registry |
| PYD_D_DAE_ET | PYDS: Scheduling Use Case Event Type |
| PYD_D_DLMGPT | Payroll Data Source Framework: DLM Group Paramter Type Asgmt |
| PCTR_T_AUTH_ASID | PCTR authority objects values set ID for checks |
| P2RX_RT_PERSON | Results Table (Person) |
| PYD_D_TYADJ | PYD: Adjustment types |
| P2RX_FUND | Accounting Structure for Funds Management |
| HRDCT_D_TABLES | Index Table for Declustering Transparent Tables |
| P2RX_WPBP | Payroll Results: Work Center/Basic Pay |
| PYD_D_SFO | PYDS: Persistence of structure Simple Form |
| PYC_D_BO_PMRRECU | PMR Recurrence - #GENERATED# |
| P2RX_RT | Payroll Results: Results Table |
| PCTR_T_AUTH_ADM | Auth index admin data |
| PYD_D_DAE_ETP | PYDS: Scheduling Use Case Event Type Parameter Type |
| PYC_D_TMDI_DE | Allowed Team Dimensions |
| PYC_D_BO_PMRISP | PYC: PMR Instance Selection Parameter BO |
| PYC_D_BO_POLMR | Policy Maintenance Request - #GENERATED# |
| P2RX_ARRRS | Payroll Results: Arrears Table |
| P2RX_AB | Cluster RD/B2: Table AB |
| PYD_D_NSC | PYDS: Namespace for Simplified Configuration Category |
| PYD_PC_D_WL | Worklist Process Instance and Step Assignment |
| PYC_D_TXT_CONFIG | PCC: Step template text configuration switch |
| PYC_D_CWB_TYPET | PCC Configuration Workbench Object Type Text Table |
| PCTR_T_AUTH_ASET | PCTR authority objects values set for checks |
| PYD_D_ATVC | Payroll Data Source Framework: Admin. Value Custimizing |
| PYD_D_ALI | Payroll Data Source Framework: Action Log Item |
| PYD_D_UVD | Payroll Data Source Framework: User Variant Details |
| PYD_D_SCT | Payroll Data Source Framework: Semantical Category Text |
| PYC_D_PYPC | Payroll Process Category |
| PCTR_T_AUTH_PARM | PCTR: Parammeters configuration for auhtorization type |
| PYD_D_CLS | Payroll Data Source Class |
| PCTR_T_AUTH_IFTY | PC authority type - infotype settings |
| P2RX_CODIST | Distribution opf Liabilities |
| PYD_D_GOV | PYDS: Persistence of structure Generic Overview |
| PYD_D_DAE_UCD | PYDS: Scheduling Use Case Definition |
| PYD_D_INSTP | Payroll Data Source Instance Input Parameter |
| PYC_D_PYPTM_CL | Payroll Control Center Process Team Setup Draft Cluster |
| PYD_D_WT | Payroll Data Source Framework Wrap-up Type |
| PYC_D_EE_MDCK | Employee Master Data Change Key Information |
| PCTR_T_AUTH_TYPT | Auth type text |
| P2RX_CRT | Payroll Results: Cumulated Results Table |
| P2RX_MODIF | HR-PAY: Modifiers |
| PYC_D_PY_MSG_JOB | PYC: payroll message |
| PYD_D_RDTT | Payroll Data Source Result Details Type Text |
| PYD_D_TYSOL_PT | Solution parameter value |
| PYC_D_TXT_MESSAG | PYC: TEXT FROM MESSAGE CLASS |
| PYC_D_STA | Payroll Process Step Template Attributes |
| PYC_D_TEAM_INAC | PCC Inactive Team Members |
| PYC_D_PYPTY | Process Type |
| P2RX_LIDI | Cost-Distributed Liabilities |
| P2RX_LS | Payroll Results: Subsequent Time Tickets |
| P2RX_TPY_EVAL_P | Test payroll run for eval period |
| PYC_D_POL_TYPET | Policy Type Text |
| PYD_D_CLSCT | Payroll Data Source Class Category Text |
| PYC_D_PYP_TEAM | Process Team (to be deleted) |
| PYC_D_PI_OC_SPI | PYC: Payroll Process Instance Selection Result |
| PYD_D_TYPTI | Payroll Data Source Type Input Parameter Type Assignment |
| PYC_D_PYPTYPOLTY | Assign Policy Type to Process Type |
| PYD_D_PT | Payroll Data Source Parameter Type |
| PYC_D_PYPTYT | Payroll Process Type Text |
| PYD_D_ACTIONT | Payroll Data Source Framework: Action Log Action Code Text |
| P2RX_LIFL | Outflow/Inflow to or from a Payroll Period |
| PYC_D_TXT_OTR | PYC: TEXT FROM OTR |
| PYC_D_PYP_WTGD | Adhoc Offcycle : Wage Type Group Details |
| PYD_D_ALCT | Payroll Data Source Framework Action Log Category Text |
| PYD_D_PTFLT | Payroll Data Source Par. Type - Allowed Pa.Types as filter |
| PYD_D_DLMG | Payroll Data Source Framework: Data Lifecycle Mgmt Group |
| PYC_D_DTAREG | DTA Stamp Registry |
| PYD_D_SC | Payroll Data Source Framework: Semantical Category |
| PYC_D_EHI | PCC : Event Handler Item Table for Master Data Change |
| PYD_D_SHTT | Payroll Data Source Shadow Type Text |
| PYD_D_INSTCSR | Payroll Data Source Inst. Curr. Settings Remote Execution |
| PYC_D_PYP_WTG | Adhoc Offcycle : Wage Type Group |
| PYC_D_PI_OC_SP | Off-Cycle Process instance selection package |
| PYC_D_BPC_RPT | Batch Processing Component Reports |
| P2RX_GROUPING | Payroll Result: Grouping Table |
| PYD_D_FOL | Payroll Data Source Folder |
| P2RX_AVERAGE | Frozen Average Values in Payroll Result |
| PYC_D_OC_ST | Off-Cycle : store payroll form for simulated results |
| PYD_D_AL | Payroll Data Source Framework: Action Log |
| PYC_D_LC | Payroll Control Center: Lock Category |
| PYD_D_CLSSC | Payroll Data Source Class Semantical Category Assignment |
| PYD_D_RESOS | Payroll Data Source Result Object Shadow |
| PYD_D_DAE_UCDP | PYDS: Scheduling Use Case Definition Parameter Types |
| PYC_D_PYPTM_LD | Payroll Control Center TM: Team Leads |
| PYD_D_TYL | Payroll Data Source Type Link |
| PYD_D_NS | PYDS: Namespace for Simplified Configuration |
| PYC_D_PYP_REL | Payroll Process Relationship |
| PYC_D_BO_POLMRCK | Policy Checks - #GENERATED# |
| PYC_D_BPC | Batch Processing Component Run Time Information |
| PYD_D_DAE_EREG | PYDS: Scheduling Event Registry |
| PYD_D_DLMGT | Payroll Data Source Framework: DLM Group Text |
| PCTR_T_AUTH_TYPE | Authority type |
| PYD_D_UICAT | Payroll Data Source UI Category Attribute Text |
| PYD_D_DAE_UCDT | PYDS: Scheduling Use Case Definition Text |
| PYC_D_BO_PMRA | PYC: PMR Administrator BO |
| P2RX_STATUS | Status Indicator |
| PYC_D_PYPPOL | Payroll policies to Process assignment |
| PYD_D_TYSC | Payroll Data Source Type: Semantical Category Assignment |
| PYC_D_BO_POLICYT | Policy Text - #GENERATED# |
| PYC_D_PYP_WTGT | Adhoc Offcycle : Wage Type Group Text |
| PYD_D_PTRDT | Payroll Data Source Par. Type Result Detail Type Asgmt. |
| PYD_D_SOLVART | PCC: Validation Rule Solution Variable Name |
| PYC_D_DTAREGP | DTA Stamp Registry Processing |
| PYC_D_BO_PROCT | PYC: Process Text BO |
| PYD_D_UICA | Payroll Data Source UI Category Attribute |
| PYD_D_FOLTY | Payroll Data Source Folder Type Assignment |
| PYD_D_RDT | Payroll Data Source Result Details Type |
| PYD_D_RESO | Payroll Data Source Result Object |
| PYD_D_RDTUICA | Payroll Data Source Result Details Type UI Cat. Attr. Asgmt. |
| PYC_D_TMDI_DEEXT | Allowed Team Dimensions - custom extended |
| PYC_D_PYPTYSTL | Payroll Process Type Step Link |
| PYC_D_BPC_UC | Batch Processing Component Use Case |
| PYD_D_SWT | PYDS: Persistence of structure Simple Wage Type |
| PYC_D_PYPTM | Payroll Control Center TM: Team |
| P2RX_C0 | Cost Distribution |
| PYD_D_AT | Payroll Data Source Framework: Administration Type |
| PYD_D_ATT | Payroll Data Source Framework: Administration Type Text |
| PYD_D_TYPTR | Payroll Data Source Type Result Parameter Type Assignment |
| PYD_D_EDM_CT | Payroll Data Source Framework: EDM Core Type |
| PYD_D_RESOH | Payroll Data Source Result Object History |
| PYD_D_ATV | Payroll Data Source Framework: Administration Value |
| P2RX_C1 | Cost Distribution Table C1 |
| PYD_D_ATTACH | Payroll COntrol Center - Attachments |
| P2RX_DDNTK | Payroll Results: Deductions Not Effected |
| P2RX_BT | Payroll Results: Bank Transfers |
| PYD_D_DAE_EREGP | PYDS: Scheduling Event Registry Parameter |
| PYD_D_INSTLOG | Payroll Data Source Instance Log |
| PYD_D_CHK_KV | PYDS: Persistence of Check Key Value |
| PYC_D_POL_TYPE | PYC: Policy type |
| HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results |
| PYD_D_TY | Payroll Data Source Type |
| PYC_D_BPC_JOB | Batch Processing Component Jobs |
| T77DCT_OPTION | HR Declustering Tools General Settings |
| PYD_D_RESP | Payroll Data Source Result Input Parameter |
| PYD_D_DAE_REGP | PYDS: Scheduling Use Case Registry Parameter |
| PYD_D_CLST | Payroll Data Source Class Text |
| PYD_D_PTUICA | Payroll Data Source Parameter Type UI Cat. Attr. Asgmt. |
| PYD_D_ALC | Payroll Data Source Framework Action Log Category |
| PYD_D_FOLTYSC | Payroll Data Source Folder Type Semantical Relationship |
| PYC_D_BO_PMRMONI | Process related monitoring process - #GENERATED# |
| PYC_D_PYP | Payroll Process |
| PYD_D_TYCT | Payroll Data Source Type Category Text |
| PYC_D_PYPTYCTX | Payroll Process Type Context |
| P2RX_BT_PERSON | Payment-Related Information (Person) |
| PYD_D_TYSOL | PCC: Assignment Solutions to Payroll Data Source Type |
| PYD_D_FOLT | Payroll Data Source Folder Text |
| PYC_D_PYPSGI | Payroll Process Step Group Instance |
| PYD_D_CLSPASH | Payroll Data Source Class Parameter Act. Status History |
| PYC_D_BPC_REJO | Batch Processing Component Reject Object |
| PYC_D_PYPTE_TMDI | Process template Team Dimension |
| PYD_D_CLSC | Payroll Data Source Class Category |
| PYC_D_PYP_OCRSN | Off-Cycle Reasons to Process Assignment |
| P2RX_CRT_PERSON | Cumulated Results Table (Person) |
| PYC_D_PYP_WTG_OR | Adhoc Offcycle : Wage Type Group |
| PYC_D_PYPT | Payroll Process Text |
| PYD_D_WTD | PYDS: Persistence of structure Wage Type Difference |
| PYC_D_LOCK | Payroll Control Center: Lock Table |
| PYC_D_PTC | Payroll Process Template Category |
| PYD_D_CHK_SOL | PYDS: Persistence of Check Solution information |
| PYC_D_PYPI | Payroll Process Instance |
| PYC_D_PYPTM_MB | Payroll Control Center TM: Team Members |
| PYC_D_STCT | Payroll Process Step Template Category Text |
| PYD_D_ATTACH_M | PCC: Allowed mime types for attachments |
| PYD_D_CLSPAS | Payroll Data Source Class Parameter Activation Status |
| PYD_D_ATVL | Payroll Data Source Framework: Administration Value List |
| PYC_D_BO_PMR | PYC: Process Maintenance Request BO |
| PYC_D_PROV | Context Type Provided by Process Step |
| PYC_D_BO_PMRPOL | PYC: PMR Policy BO |
| PYC_D_PYPTM_SELC | Payroll Control Center TM: Team Selection Criteria |
| PYD_D_SH | Payroll Data Source Shadow |
| PYD_D_TYPTRSCRT | Payroll Data Source Result Object Status Change Reason Text |
| PYC_D_PROVT | Text for Context type provided by process step |
| PYC_D_STC | Payroll Process Step Template Category |
| PYD_D_INSTT | Payroll Data Source Instance Text |
| PYC_D_PYPCT | Payroll Process Category Text |
| PYC_D_LCT | Payroll Control Center: Lock Category Text |
| PYC_D_EE_MDCA | Employee Master Data Change Assignment |
| PYD_D_TYSOLT | Text table of solution assignment |
| PYD_D_SHT | Payroll Data Source Shadow Type |
| PYD_D_SOL | PYDS: Validation Rule Solution |
| PYD_D_TYC | Payroll Data Source Type Category |
| PYD_D_TYPTRSCR | Payroll Data Source Result Object Error Status Change Reason |
| PYC_D_MSI | Payroll Control Center Monitoring Step Instance |
| PCTR_T_AUTH_INDX | authority index |
| PYD_D_ACTION | Payroll Data Source Framework: Action Log Action Code |
| PYC_D_PYPTE | Payroll Process Template Assignment |
| PYC_D_TXT_FREE | PYC: TEXT FROM FREE INPUT |
| PCTR_T_AUTH_ASTX | Authority set text |
| PYD_D_ATVU | Payroll Data Source Framework: Administration Value per User |
| PYC_D_PYPTM_ALT | Process team alert assignment |
| PYD_D_INSTL | Payroll Data Source Instance Link |
| PYC_D_CWB_TYPE | PCC Configuration Workbench Object Type |
| PYD_D_INST | Payroll Data Source Instance |
| PYD_D_PTT | Payroll Data Source Parameter Type Text |
| PYC_D_BPC_REJOM | Batch Processing Component Reject Object Messages |
| PYC_D_EHL | PCC : Event Handler Log Table |
| T77DCT_REG | Declustering Registry: Tables To Be Declustered |
| PCTR_T_AUTH_PRFL | PCTR auth profiles for extraction |
| PYC_D_PY_MSG | PYC: payroll message |
| PCTR_T_AUTH_LEVL | PCTR auth level |
| PYD_D_TYUICA | Payroll Data Source Type UI Category Attribute Assignment |
| PYD_D_DAE_ETT | PYDS: Scheduling Use Case Event Type Text |
| PYD_D_DAE_TRACE | PYDS: Scheduling Use Case Processing Trace |
| PYC_D_PYPISP | Payroll Process Instance Selection Parameter Value |