SAP ABAP Table SAPMPTKC (ESS - Tax calculation tools for Canada HR)

Hierarchy

☛ SAP_HRCCA (Software Component) Sub component SAP_HRCCA of SAP_HR
   ⤷ PY-CA (Application Component) Canada
     ⤷ PC07 (Package) HR accounting: Canada

Basic Data

Table Category	INTTAB	Structure
Structure	SAPMPTKC	Table Relationship Diagram
Short Description	ESS - Tax calculation tools for Canada HR

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
2	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
3	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
4	WRKAR	☐	PCA_WRKAR	PCA_WRKAR	CHAR	4	0	Province of employment	*
5	NUPER	☐	PCA_NUPER	PCA_NUPER	NUMC	2	0	Number of pay periods in the year
6	ACPER	☐	PCA_ACPER	PCA_ACPER	NUMC	2	0	Number of current pay period
7	CHKDT	☐	CHKDT	DATUM	DATS	8	0	Check Date
8	GRORE	☐	PCA_GRORE	PCA_AMT	CURR	9	2	Gross remuneration
9	GRORE_YTD	☐	PCA_GRORE	PCA_AMT	CURR	9	2	Gross remuneration
10	GROBO	☐	PCA_GROBO	PCA_AMT	CURR	9	2	Gross remuneration - bonus
11	GROBO_YTD	☐	PCA_GROBO	PCA_AMT	CURR	9	2	Gross remuneration - bonus
12	GRORE_QC	☐	PCA_GRORE	PCA_AMT	CURR	9	2	Gross remuneration
13	GRORE_YTD_QC	☐	PCA_GRORE	PCA_AMT	CURR	9	2	Gross remuneration
14	GROBO_QC	☐	PCA_GROBO	PCA_AMT	CURR	9	2	Gross remuneration - bonus
15	GROBO_YTD_QC	☐	PCA_GROBO	PCA_AMT	CURR	9	2	Gross remuneration - bonus
16	INSUR	☐	PCA_INSUR	PCA_AMT	CURR	9	2	Insurable earnings
17	INSBO	☐	PCA_INSUR	PCA_AMT	CURR	9	2	Insurable earnings
18	INSUR_CON_YTD	☐	PCA_INSUR_CON	PCA_AMT	CURR	9	2	Employment Insurance contributions
19	PENSN	☐	PCA_PENSN	PCA_AMT	CURR	9	2	Pensionable earnings
20	PENBO	☐	PCA_PENSN	PCA_AMT	CURR	9	2	Pensionable earnings
21	PENSN_CON_YTD	☐	PCA_PENSN_CON	PCA_AMT	CURR	9	2	Canada/Quebec Pension Plan contributions
22	PENSN_QC	☐	PCA_PENSN	PCA_AMT	CURR	9	2	Pensionable earnings
23	PENBO_QC	☐	PCA_PENSN	PCA_AMT	CURR	9	2	Pensionable earnings
24	PENMO	☐	PCA_PENMO	PCA_PENMO	NUMC	2	0	Number of pensionable months
25	RRSP	☐	PCA_RRSP	PCA_AMT	CURR	9	2	RRSP, RPP and RCA deductions
26	RRSP_YTD	☐	PCA_RRSP	PCA_AMT	CURR	9	2	RRSP, RPP and RCA deductions
27	RRSP_QC	☐	PCA_RRSP_QC	PCA_AMT	CURR	9	2	RRSP, RPP and RCA deductions
28	RRSP_YTD_QC	☐	PCA_RRSP_QC	PCA_AMT	CURR	9	2	RRSP, RPP and RCA deductions
29	UNIDU	☐	PCA_UNIDU	PCA_AMT	CURR	9	2	Union dues
30	UNIDU_YTD	☐	PCA_UNIDU	PCA_AMT	CURR	9	2	Union dues
31	MNTDE	☐	PCA_MNTDE	PCA_AMT	CURR	9	2	Annual authorized federal deductions
32	OTADE	☐	PCA_OTADE	PCA_AMT	CURR	9	2	Other annual authorized deductions - QC
33	CRTDE	☐	PCA_CRTDE	PCA_AMT	CURR	9	2	Court Order Deduction - Alimony Maintenance Payments
34	CRTDE_YTD	☐	PCA_CRTDE	PCA_AMT	CURR	9	2	Court Order Deduction - Alimony Maintenance Payments
35	TEXHD	☐	PCA_TEXHD	PCA_AMT	CURR	9	2	Designated area deduction
36	TOTCR	☐	PCA_TOTCR	PCA_AMT	CURR	9	2	Total personal tax credit amount
37	TOTCQ	☐	PCA_TOTCQ	PCA_AMT	CURR	9	2	Total personal tax credit amount - QC
38	LBTCR	☐	PCA_LBTCR	PCA_AMT	CURR	9	2	Amount paid for purchase of labour-sponsored funds
39	LBTCR_QC	☐	PCA_LBTCR	PCA_AMT	CURR	9	2	Amount paid for purchase of labour-sponsored funds
40	NODEP	☐	PCA_NODEP	PCA_NODEP	NUMC	2	0	No. of dependants under 18 yrs.
41	NODIS	☐	PCA_NODIS	PCA_NODEP	NUMC	2	0	No. of dependants 18 yrs. or older and disabled
42	MARRD	☐	PCA_MARRD	PCA_MARRD	CHAR	1	0	Married or equivalent-to-spouse
43	INSUR_CON	☐	PCA_INSUR_CON	PCA_AMT	CURR	9	2	Employment Insurance contributions
44	PENSN_CON	☐	PCA_PENSN_CON	PCA_AMT	CURR	9	2	Canada/Quebec Pension Plan contributions
45	FETAX	☐	PCA_FETAX	PCA_AMT	CURR	9	2	Federal and provincal tax
46	FETBO	☐	PCA_FETBO	PCA_AMT	CURR	9	2	Federal and provincal tax on bonus
47	FETAX_QC	☐	PCA_FETAX_QC	PCA_AMT	CURR	9	2	Quebec provincial tax
48	FETBO_QC	☐	PCA_FETBO_QC	PCA_AMT	CURR	9	2	Quebec tax on bonus
49	OTXCR	☐	PCA_OTXCR	PCA_AMT	CURR	9	2	Annual authorized federal tax credits
50	OTXCQ	☐	PCA_OTXCQ	PCA_AMT	CURR	9	2	Other annual authorized tax credits - QC
51	HITNU	☐	INT4	INT4	INT4	10	0	Natural number
52	ADDTX	☐	PCA_ADDTX	PCA_AMT	CURR	9	2	Additional tax
53	ADDTQ	☐	PCA_ADDTQ	PCA_AMT	CURR	9	2	Additional tax deduction - Provincial
54	NETPAY	☐	PCA_NETPAY	PCA_AMT	CURR	9	2	Net pay amount
55	TOTCP	☐	PCA_TOTCP	PCA_AMT	CURR	9	2	Provincial total tax credits
56	OTXCP	☐	PCA_OTXCP	PCA_AMT	CURR	9	2	Other provincial authorized tax credits
57	LBTCP	☐	PCA_LBTCP	PCA_AMT	CURR	9	2	Provincial Labour-Sponsored Tax Credit
58	PPIP	☐	PCA_PPIP	PCA_AMT	CURR	9	2	PPIP Insurable earnings
59	PPIPBO	☐	PCA_PPIP	PCA_AMT	CURR	9	2	PPIP Insurable earnings
60	PPIP_CON_YTD	☐	PCA_PPIP_CON	PCA_AMT	CURR	9	2	PPIP contributions
61	PPIP_CON	☐	PCA_PPIP_CON	PCA_AMT	CURR	9	2	PPIP contributions

History

Last changed by/on	SAP	20081217
SAP Release Created in