SAP ABAP Table PA0224 (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	TRANSP	Transparent table
Transparent table	PA0224	Table Relationship Diagram
Short Description	Tax information - infotype 0224 - Canada

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20080626
SAP Release Created in