SAP ABAP Table PS0224 (Tax information of Infotype 0224 - Canada)

Hierarchy

☛ SAP_HRCCA (Software Component) Sub component SAP_HRCCA of SAP_HR
   ⤷ PA-PA-CA (Application Component) Canada
     ⤷ PB07 (Package) HR master data: Canada

Basic Data

Table Category	INTTAB	Structure
Structure	PS0224	Table Relationship Diagram
Short Description	Tax information of Infotype 0224 - Canada

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	WRKAR	☐	PCA_WRKAR	PCA_WRKAR	CHAR	4	0	Province of employment	T5KAW
2	RESAR	☐	PCA_RESAR	PCA_WRKAR	CHAR	4	0	Employment standard jurisdiction	*
3	RCITY	☐	PCA_RECTY	PCA_RECTY	CHAR	4	0	Designated CMA	*
4	CBUSN	☐	PCA_CBUSN	PCA_CBUSN	CHAR	15	0	Business number
5	CGSTN	☐	PCA_CGSTN	PCA_CGSTN	CHAR	15	0	GST number
6	OPTIO	☐	PCA_OPTIO	PCA_OPTIO	CHAR	1	0	Option for tax calculation
7	TOTCR	☐	PCA_TOTCR	PCA_AMT	CURR	9	2	Total personal tax credit amount
8	CLAIM	☐	PCA_CLAIM	PCA_CLAIM	CHAR	2	0	Claim Code	T5KCF
9	TNIND	☐	PCA_TNIND	PCA_AMT	CURR	9	2	Total non-indexed personal tax credit amount
10	ADDTX	☐	PCA_ADDTX	PCA_AMT	CURR	9	2	Additional tax
11	ADDTP	☐	PCA_ADDTP	PROZPB	DEC	3	0	Additional Tax (%) - Canada
12	TEXHD	☐	PCA_TEXHD	PCA_AMT	CURR	9	2	Designated area deduction
13	NODEP	☐	PCA_NODEP	PCA_NODEP	NUMC	2	0	No. of dependants under 18 yrs.
14	NODIS	☐	PCA_NODIS	PCA_NODEP	NUMC	2	0	No. of dependants 18 yrs. or older and disabled
15	MNTDE	☐	PCA_MNTDE	PCA_AMT	CURR	9	2	Annual authorized federal deductions
16	OTXCR	☐	PCA_OTXCR	PCA_AMT	CURR	9	2	Annual authorized federal tax credits
17	LBTCR	☐	PCA_LBTCR	PCA_AMT	CURR	9	2	Amount paid for purchase of labour-sponsored funds
18	CRTDE	☐	PCA_CRTDE	PCA_AMT	CURR	9	2	Court Order Deduction - Alimony Maintenance Payments
19	LBTCP	☐	PCA_LBTCP	PCA_AMT	CURR	9	2	Provincial Labour-Sponsored Tax Credit
20	COMRE	☐	PCA_COMRE	PCA_AMT	CURR	9	2	Estimated total remuneration
21	COMEX	☐	PCA_COMEX	PCA_AMT	CURR	9	2	Estimated expenses
22	QCTXI	☐	PCA_QCTXI	PCA_QCTXI	CHAR	16	0	Taxation identification number - QC
23	QGSTN	☐	PCA_QGSTN	PCA_QGSTN	CHAR	16	0	QST number - QC
24	TOTCQ	☐	PCA_TOTCQ	PCA_AMT	CURR	9	2	Total personal tax credit amount - QC
25	CLAQC	☐	PCA_CLAQC	PCA_CLAQC	CHAR	2	0	Claim code Québec	T5KCQ
26	ADDTQ	☐	PCA_ADDTQ	PCA_AMT	CURR	9	2	Additional tax deduction - Provincial
27	OTHDE	☐	PCA_OTHDE	PCA_AMT	CURR	9	2	Other annual deductions and credits - QC
28	OTXCQ	☐	PCA_OTXCQ	PCA_AMT	CURR	9	2	Other annual authorized tax credits - QC
29	OTADE	☐	PCA_OTADE	PCA_AMT	CURR	9	2	Other annual authorized deductions - QC
30	INDYR	☐	PCA_INDYR	PCA_INDYR	CHAR	1	0	Base Year QC
31	COMRQ	☐	PCA_COMRQ	PCA_AMT	CURR	9	2	Gross Commission Income - Québec
32	COMEQ	☐	PCA_COMEQ	PCA_AMT	CURR	9	2	Estimated annual net commission income - QC
33	COMPQ	☐	PCA_COMPQ	PROZPB	DEC	3	0	Percentage of Commission - Québec
34	TAX01	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
35	EXI01	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
36	TAX02	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
37	EXI02	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
38	TAX03	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
39	EXI03	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
40	TAX04	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
41	EXI04	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
42	TAX05	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
43	EXI05	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
44	TAX06	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
45	EXI06	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
46	TAX07	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
47	EXI07	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
48	TAX08	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
49	EXI08	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
50	TAX09	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
51	EXI09	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
52	TAX10	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
53	EXI10	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
54	TAX11	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
55	EXI11	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
56	TAX12	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
57	EXI12	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
58	TAX13	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
59	EXI13	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
60	TAX14	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
61	EXI14	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
62	TAX15	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
63	EXI15	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
64	MARRD	☐	PCA_MARRD	PCA_MARRD	CHAR	1	0	Married or equivalent-to-spouse
65	PROVR	☐	PCA_PROVR	PCA_WRKAR	CHAR	4	0	Province of residence	T5KAW
66	WNSBN	☐	PCA_WNSBN	PCA_CBUSN	CHAR	15	0	Business Number for WCB purposes
67	TOTCP	☐	PCA_TOTCP	PCA_AMT	CURR	9	2	Provincial total tax credits
68	OTXCP	☐	PCA_OTXCP	PCA_AMT	CURR	9	2	Other provincial authorized tax credits
69	TNINP	☐	PCA_TNIND	PCA_AMT	CURR	9	2	Total non-indexed personal tax credit amount
70	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PS0224	CLAIM	T5KCF	CLAIM	KEY	1	CN
2	PS0224	CLAQC	T5KCQ	CLAQC	KEY	1	CN
3	PS0224	EXI01	T5KIN	EXIND	KEY	1	CN
4	PS0224	EXI02	T5KIN	EXIND	KEY	1	CN
5	PS0224	EXI03	T5KIN	EXIND	KEY	1	CN
6	PS0224	EXI04	T5KIN	EXIND	KEY	1	CN
7	PS0224	EXI05	T5KIN	EXIND	KEY	1	CN
8	PS0224	EXI06	T5KIN	EXIND	KEY	1	CN
9	PS0224	EXI07	T5KIN	EXIND	KEY	1	CN
10	PS0224	EXI08	T5KIN	EXIND	KEY	1	CN
11	PS0224	EXI09	T5KIN	EXIND	KEY	1	CN
12	PS0224	EXI10	T5KIN	EXIND	KEY	1	CN
13	PS0224	EXI11	T5KIN	EXIND	KEY	1	CN
14	PS0224	EXI12	T5KIN	EXIND	KEY	1	CN
15	PS0224	EXI13	T5KIN	EXIND	KEY	1	CN
16	PS0224	EXI14	T5KIN	EXIND	KEY	1	CN
17	PS0224	EXI15	T5KIN	EXIND	KEY	1	CN
18	PS0224	PROVR	T5KAW	WRKAR
19	PS0224	TAX01	T5KTO	TAXAU	KEY	1	CN
20	PS0224	TAX02	T5KTO	TAXAU	KEY	1	CN
21	PS0224	TAX03	T5KTO	TAXAU	KEY	1	CN
22	PS0224	TAX04	T5KTO	TAXAU	KEY	1	CN
23	PS0224	TAX05	T5KTO	TAXAU	KEY	1	CN
24	PS0224	TAX06	T5KTO	TAXAU	KEY	1	CN
25	PS0224	TAX07	T5KTO	TAXAU	KEY	1	CN
26	PS0224	TAX08	T5KTO	TAXAU	KEY	1	CN
27	PS0224	TAX09	T5KTO	TAXAU	KEY	1	CN
28	PS0224	TAX10	T5KTO	TAXAU	KEY	1	CN
29	PS0224	TAX11	T5KTO	TAXAU	KEY	1	CN
30	PS0224	TAX12	T5KTO	TAXAU	KEY	1	CN
31	PS0224	TAX13	T5KTO	TAXAU	KEY	1	CN
32	PS0224	TAX14	T5KTO	TAXAU	KEY	1	CN
33	PS0224	TAX15	T5KTO	TAXAU	KEY	1	CN
34	PS0224	WRKAR	T5KAW	WRKAR	KEY	1	CN

History

Last changed by/on	SAP	20020219
SAP Release Created in