SAP Canada Tables
Are you looking for the right table related to SAP Canada 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 Canada (PY-CA) module.
Top 10 tables in Canada
| Table | Description |
|---|---|
| T5KG2 | Description of special rule |
| T5KWC | Classification groups for WCB |
| T5KG1 | Special rule |
| P2RK_WTDT | Payroll Results - Wage type processing information |
| T5KV3 | Vacation pay: Accrual Years |
| T5KG5 | Relationship to other debts model characteristics |
| T5KR1 | ROE serial number reference table |
| T5KB2 | Canadian tax reporting units |
| T5KB3 | Registration Number Organizational assignment, Canada |
| P2RK_GRDBT | Payroll results Canada: Garnishment debt |
List of tables in Canada
| Table | Description |
|---|---|
| T5KG2 | Description of special rule |
| T5KWC | Classification groups for WCB |
| T5KG1 | Special rule |
| P2RK_WTDT | Payroll Results - Wage type processing information |
| T5KV3 | Vacation pay: Accrual Years |
| T5KG5 | Relationship to other debts model characteristics |
| T5KR1 | ROE serial number reference table |
| T5KB2 | Canadian tax reporting units |
| T5KB3 | Registration Number Organizational assignment, Canada |
| P2RK_GRDBT | Payroll results Canada: Garnishment debt |
| T5KG9 | Garnishee fee |
| T5KWB | Classification groups assignment for WCB |
| PCERE | Activities per Payroll Result |
| T5KV2 | Vacation pay: Wage Types for Special Events |
| T5UNC | North American Industry Classification System(NAICS) Codes |
| T5KB5 | Definition of Registration/Account Grouping, Canada |
| T5KWR | Employee Grouping for workers compensation |
| T5KTS | Tax types description |
| T5K0S | Sickness grouping for absence types |
| P2RK_DOWP | Payroll Results: Additional WPBP Data (PSG) |
| P2RK_TCRT | Payroll Results - Fed. and Prov. Tax Cumulations |
| T5KV5 | Vacation pay: Automatic Payouts |
| P2RK_GRORD | Payroll results Canada: Garnishment order |
| PCERT | Payroll Posting Runs |
| PCERH | History of Payroll Posting Runs |
| T5KVE | Include/exclude indicator for wage type processing |
| P2RK_ADR | Address |
| T5UNT | North American Industry Classification System(NAICS) Texts |
| T5KQT | Tax claim codes QC - texts |
| T5K0C | Absence Breakdown |
| P2RK_GRCUM | Cumulation for garnishment results |
| T5KYS | No longer used |
| T5KSP | Short/long term disability plan |
| T5K6I | Year-end amendment wage-type selection |
| T5UBX_GTL_AWART | Processing group for absence types |
| T5KB0 | Definition of Registration Number, Canada |
| T5KB4 | Account Number Organizational assignment, Canada |
| T5KTT | Tax types Canada |
| PA0066 | HR Master data infotype 0066 - Canadian garnishment: order |
| P2RK_CUST | Payroll Results - Customer specific |
| P2RK_WCB1 | Payroll results - Workers' compensation information |
| T5KRC | Link HR tax payees to wage types via tax attributes |
| T5KWT | Classification groups for WCB - Text table |
| P2RK_DOC0 | Payroll Results: Additional C0 Data (PSG) |
| PA0221 | HR Master Record: Infotype 0221 (Manual Checks) |
| T5KV4 | Vacation pay: Absence types without corresp. entitlements |
| T5URB | HR payee derived from wage types via org. assignment |
| T5KTC | Wage Type Tax Classifications (Canada) |
| PA0067 | HR master data infotype 0067 - Canadian garnishment: debt |
| T5K8D | Tax key data for transfer of old payroll results |
| T5KR2 | ROE other money codes |
| P2RK_PERM | Personal Characteristics |
| T5KT3 | Fields of a tax form |
| T5KYA | Year end reporting history table |
| T5KTE | Tax types for employee |
| P2RK_NAME | Name of Employee |
| T5KTR | Tax types Employer |
| P2RK_VC1 | Vacation Pay Accrual and Balancing |
| T5KB6 | Registration/Account Grouping texts, Canada |
| T5KB1 | Definition of Business Number, Canada |
| T5KG4 | Non-exempt amount model characteristics |
| P2RK_ROE | Payroll Results - ROE |
| T5KG0 | Gross/net model characteristics |
| T5KG3 | Special rule calculation scheme |
| T5KR3 | ROE other money texts |
| T5KV1 | Vacation pay: Accrual and Payout |
| PCERV | Attributes for Posting Runs |
| P2RK_TAXO | Payroll results - master data from infotypes 0461-0463 |
| T5KLUP | Fields for tax information on magnetic media |
| P2RK_TAXI | Payroll Results - Canada - Influx Principle |
| T5U8C | Transfer external payroll results (USA) |
| T5KYH | Year end reporting History table |
| T5KWA | Workers' Compensation accounts table |
| P2RK_GRREC | Payroll results Canada: Garnishment record |
| P2RK_TAX1 | Payroll results - master data from infotypes 0461-0463 |
| T5K8C | Transfer ext. payroll results into Canadian specific tables |
| T5KBN | Business mapping for CPP & EI computation |
| T5K8E | HR-CA: Transfer additional external payroll results |
| T5KG6 | Default values |
| T5URA | HR payee derived from wage types via ZIP code |
| T5KR0 | Record of Employment (ROE) History |
| PA0068 | HR master data infotype 0068 - Canadian garnishment: adjust |
| P2RK_TCRTI | Payroll Results - Look up table for Tax Cumulations |
| P2RK_VC2 | Vacation pay entitlement per reference year |
| T5UBX_GTL_SUBTY | Processing group definition for Beneficiaries |
| P2RK_TAX2 | Payroll results - Exemption Reasons from IT0224 |