SAP ABAP Table P0224 (Tax information - 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	P0224	Table Relationship Diagram
Short Description	Tax information - 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	.INCLUDE	☐				0	0	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	Tax information of Infotype 0224 - Canada
28	WRKAR	☐	PCA_WRKAR	PCA_WRKAR	CHAR	4	0	Province of employment	T5KAW
29	RESAR	☐	PCA_RESAR	PCA_WRKAR	CHAR	4	0	Employment standard jurisdiction	*
30	RCITY	☐	PCA_RECTY	PCA_RECTY	CHAR	4	0	Designated CMA	*
31	CBUSN	☐	PCA_CBUSN	PCA_CBUSN	CHAR	15	0	Business number
32	CGSTN	☐	PCA_CGSTN	PCA_CGSTN	CHAR	15	0	GST number
33	OPTIO	☐	PCA_OPTIO	PCA_OPTIO	CHAR	1	0	Option for tax calculation
34	TOTCR	☐	PCA_TOTCR	PCA_AMT	CURR	9	2	Total personal tax credit amount
35	CLAIM	☐	PCA_CLAIM	PCA_CLAIM	CHAR	2	0	Claim Code	T5KCF
36	TNIND	☐	PCA_TNIND	PCA_AMT	CURR	9	2	Total non-indexed personal tax credit amount
37	ADDTX	☐	PCA_ADDTX	PCA_AMT	CURR	9	2	Additional tax
38	ADDTP	☐	PCA_ADDTP	PROZPB	DEC	3	0	Additional Tax (%) - Canada
39	TEXHD	☐	PCA_TEXHD	PCA_AMT	CURR	9	2	Designated area deduction
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	MNTDE	☐	PCA_MNTDE	PCA_AMT	CURR	9	2	Annual authorized federal deductions
43	OTXCR	☐	PCA_OTXCR	PCA_AMT	CURR	9	2	Annual authorized federal tax credits
44	LBTCR	☐	PCA_LBTCR	PCA_AMT	CURR	9	2	Amount paid for purchase of labour-sponsored funds
45	CRTDE	☐	PCA_CRTDE	PCA_AMT	CURR	9	2	Court Order Deduction - Alimony Maintenance Payments
46	LBTCP	☐	PCA_LBTCP	PCA_AMT	CURR	9	2	Provincial Labour-Sponsored Tax Credit
47	COMRE	☐	PCA_COMRE	PCA_AMT	CURR	9	2	Estimated total remuneration
48	COMEX	☐	PCA_COMEX	PCA_AMT	CURR	9	2	Estimated expenses
49	QCTXI	☐	PCA_QCTXI	PCA_QCTXI	CHAR	16	0	Taxation identification number - QC
50	QGSTN	☐	PCA_QGSTN	PCA_QGSTN	CHAR	16	0	QST number - QC
51	TOTCQ	☐	PCA_TOTCQ	PCA_AMT	CURR	9	2	Total personal tax credit amount - QC
52	CLAQC	☐	PCA_CLAQC	PCA_CLAQC	CHAR	2	0	Claim code Québec	T5KCQ
53	ADDTQ	☐	PCA_ADDTQ	PCA_AMT	CURR	9	2	Additional tax deduction - Provincial
54	OTHDE	☐	PCA_OTHDE	PCA_AMT	CURR	9	2	Other annual deductions and credits - QC
55	OTXCQ	☐	PCA_OTXCQ	PCA_AMT	CURR	9	2	Other annual authorized tax credits - QC
56	OTADE	☐	PCA_OTADE	PCA_AMT	CURR	9	2	Other annual authorized deductions - QC
57	INDYR	☐	PCA_INDYR	PCA_INDYR	CHAR	1	0	Base Year QC
58	COMRQ	☐	PCA_COMRQ	PCA_AMT	CURR	9	2	Gross Commission Income - Québec
59	COMEQ	☐	PCA_COMEQ	PCA_AMT	CURR	9	2	Estimated annual net commission income - QC
60	COMPQ	☐	PCA_COMPQ	PROZPB	DEC	3	0	Percentage of Commission - Québec
61	TAX01	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
62	EXI01	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
63	TAX02	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
64	EXI02	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
65	TAX03	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
66	EXI03	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
67	TAX04	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
68	EXI04	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
69	TAX05	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
70	EXI05	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
71	TAX06	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
72	EXI06	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
73	TAX07	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
74	EXI07	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
75	TAX08	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
76	EXI08	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
77	TAX09	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
78	EXI09	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
79	TAX10	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
80	EXI10	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
81	TAX11	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
82	EXI11	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
83	TAX12	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
84	EXI12	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
85	TAX13	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
86	EXI13	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
87	TAX14	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
88	EXI14	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
89	TAX15	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
90	EXI15	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
91	MARRD	☐	PCA_MARRD	PCA_MARRD	CHAR	1	0	Married or equivalent-to-spouse
92	PROVR	☐	PCA_PROVR	PCA_WRKAR	CHAR	4	0	Province of residence	T5KAW
93	WNSBN	☐	PCA_WNSBN	PCA_CBUSN	CHAR	15	0	Business Number for WCB purposes
94	TOTCP	☐	PCA_TOTCP	PCA_AMT	CURR	9	2	Provincial total tax credits
95	OTXCP	☐	PCA_OTXCP	PCA_AMT	CURR	9	2	Other provincial authorized tax credits
96	TNINP	☐	PCA_TNIND	PCA_AMT	CURR	9	2	Total non-indexed personal tax credit amount
97	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20080626
SAP Release Created in