P2RK_TAXO - Payroll results - master data from infotypes 0461-0463
Payroll results - master data from infotypes 0461-0463 information is stored in SAP table P2RK_TAXO.
It is part of development package PC07 in software component PY-CA. This development package consists of objects that can be grouped under "HR accounting: Canada".
It is part of development package PC07 in software component PY-CA. This development package consists of objects that can be grouped under "HR accounting: Canada".
Fields for table P2RK_TAXO
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
.INCLUDE | X | HRDCT_S_PAYKEY | 0 | |||
MANDT | Client | X | MANDT | CLNT | 6 | * |
.INCLUDE | PCLKEY | X | HRDCT_S_PYPCL2KEY | 0 | ||
DCT_PERNR | Personnel Number | X | P_PERNR | NUMC | 16 | |
DCT_SEQNR | Sequence Number | X | CDSEQ | NUMC | 10 | HRPY_RGDIR |
DCT_ROWID | Unique Row Number | X | HRDCT_ROWID | NUMC | 10 | |
.INCLUDE | PC294 | 0 | ||||
CNTR1 | National assignment indicator | CNTRN | RAW | 1 | ||
BEGDA | Start Date | BEGDA | DATS | 16 | ||
ENDDA | End Date | ENDDA | DATS | 16 | ||
STAT2 | Employment Status | STAT2 | CHAR | 2 | ||
WRKAR | Province of employment | PCA_WRKAR | CHAR | 8 | * | |
RESAR | Employment standard jurisdiction | PCA_RESAR | CHAR | 8 | * | |
RCITY | Employment standard jurisdiction | PCA_RESAR | CHAR | 8 | * | |
REGNR | Registration Number | PCA_REGNR | NUMC | 18 | ||
ACNBF | Account number | PCA_ACNBF | NUMC | 8 | * | |
CGSTN | GST number | PCA_CGSTN | CHAR | 30 | ||
OPTIO | Option for tax calculation | PCA_OPTIO | CHAR | 2 | ||
TOTCR | Total personal tax credit amount | PCA_TOTCR | CURR | 5 | ||
CLAIM | Claim Code | PCA_CLAIM | CHAR | 4 | * | |
TNIND | Total non-indexed personal tax credit amount | PCA_TNIND | CURR | 5 | ||
ADDTX | Additional tax | PCA_ADDTX | CURR | 5 | ||
TEXHD | Designated area deduction | PCA_TEXHD | CURR | 5 | ||
NODEP | No. of dependants under 18 yrs. | PCA_NODEP | NUMC | 4 | ||
NODIS | No. of dependants 18 yrs. or older and disabled | PCA_NODIS | NUMC | 4 | ||
MNTDE | Annual authorized federal deductions | PCA_MNTDE | CURR | 5 | ||
OTXCR | Annual authorized federal tax credits | PCA_OTXCR | CURR | 5 | ||
LBTCR | Amount paid for purchase of labour-sponsored funds | PCA_LBTCR | CURR | 5 | ||
CRTDE | Court Order Deduction - Alimony Maintenance Payments | PCA_CRTDE | CURR | 5 | ||
COMRE | Estimated total remuneration | PCA_COMRE | CURR | 5 | ||
COMEX | Estimated expenses | PCA_COMEX | CURR | 5 | ||
QCTXI | Taxation identification number - QC | PCA_QCTXI | CHAR | 32 | ||
QGSTN | QST number - QC | PCA_QGSTN | CHAR | 32 | ||
TOTCQ | Total personal tax credit amount - QC | PCA_TOTCQ | CURR | 5 | ||
CLAQC | Claim code Qu�bec | PCA_CLAQC | CHAR | 4 | * | |
ADDTQ | Additional tax deduction - Provincial | PCA_ADDTQ | CURR | 5 | ||
OTHDE | Other annual deductions and credits - QC | PCA_OTHDE | CURR | 5 | ||
OTXCQ | Other annual authorized tax credits - QC | PCA_OTXCQ | CURR | 5 | ||
OTADE | Other annual authorized deductions - QC | PCA_OTADE | CURR | 5 | ||
COMEQ | Estimated annual net commission income - QC | PCA_COMEQ | CURR | 5 | ||
MARRD | Married or equivalent-to-spouse | PCA_MARRD | CHAR | 2 | ||
LSTPY | Date of last irregular pay (for CPP/QPP exemption) | PCA_LSTPY | DATS | 16 | ||
PROVR | Province of residence | PCA_PROVR | CHAR | 8 | * | |
WNSBN | Business Number for WCB purposes | PCA_WNSBN | CHAR | 30 | ||
TOTCP | Provincial total tax credits | PCA_TOTCP | CURR | 5 | ||
OTXCP | Other provincial authorized tax credits | PCA_OTXCP | CURR | 5 | ||
LBTCP | Provincial Labour-Sponsored Tax Credit | PCA_LBTCP | CURR | 5 | ||
PVTAX | Province of taxation (CE) | PCA_PVTAX | CHAR | 8 | * | |
PHLTH | Province of Health Tax | PCA_PHLTH | CHAR | 8 | * | |
BPA | Basic Personal Amount value | HRPADCA_BPA | CURR | 5 | ||
BPA_FROM_TD1 | Flags if BPA value comes from TD1 form | HRPADCA_BPATD1 | CHAR | 2 | ||
BPAP | Provincial Basic Personal Amount value | HRPADCA_BPAP | CURR | 5 | ||
BPA_FROM_TD1P | Flags if BPA value comes from provincial TD1 form | HRPADCA_BPATD1P | CHAR | 2 |