SAP ABAP Table BAPIP0224L (Tax information - Inf. 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	BAPIP0224L	Table Relationship Diagram
Short Description	Tax information - Inf. 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	Key for HR Master Data
2	EMPLOYEENO	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number	*
3	SUBTYPE	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJECTID	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	LOCKINDIC	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	VALIDEND	☐	ENDDA	DATUM	DATS	8	0	End Date
7	VALIDBEGIN	☐	BEGDA	DATUM	DATS	8	0	Start Date
8	RECORDNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	.INCLUDE	☐				0	0	Administrative data for HR Master Data
10	LAST_CHANGED_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
11	LAST_CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
12	ADD_TEXT_EXISTS	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
13	REASON_FOR_CHNG	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
14	TAX_AREA	☐	PCA_WRKAR	PCA_WRKAR	CHAR	4	0	Province of employment	T5KAW
15	NAMEOFTAXAREA	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
16	STD_JURISDICT	☐	PCA_RESAR	PCA_WRKAR	CHAR	4	0	Employment standard jurisdiction	T5KAW
17	METROPOL_AREA	☐	PCA_RECTY	PCA_RECTY	CHAR	4	0	Designated CMA	T5KAR
18	BUSINESS_NUMBER	☐	PCA_CBUSN	PCA_CBUSN	CHAR	15	0	Business number
19	GST_NUMBER	☐	PCA_CGSTN	PCA_CGSTN	CHAR	15	0	GST number
20	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
21	OPTION_TAX_CALC	☐	PCA_OPTIO	PCA_OPTIO	CHAR	1	0	Option for tax calculation
22	TAXCREDITAMOUNT	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
23	CLAIM_CODE	☐	PCA_CLAIM	PCA_CLAIM	CHAR	2	0	Claim Code	T5KCF
24	NON_INDEX_AMNT	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
25	ADDITIONAL_TAX	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
26	ADD_TAX_PERCENT	☐	PCA_ADDTP	PROZPB	DEC	3	0	Additional Tax (%) - Canada
27	DESIGNATED_AREA	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
28	DEPEND_UNDER_18	☐	PCA_NODEP	PCA_NODEP	NUMC	2	0	No. of dependants under 18 yrs.
29	DEPEND_18ORMORE	☐	PCA_NODIS	PCA_NODEP	NUMC	2	0	No. of dependants 18 yrs. or older and disabled
30	FED_DEDUCTION	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
31	FED_TAX_CREDIT	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
32	LAB_SPONS_FUNDS	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
33	ALIM_MAINT_PAYM	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
34	LAB_CRED_PROV	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
35	EST_REMUNERATLC	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
36	EST_EXPENSES	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
37	TAXATION_ID_QC	☐	PCA_QCTXI	PCA_QCTXI	CHAR	16	0	Taxation identification number - QC
38	QST_NUMBER_QC	☐	PCA_QGSTN	PCA_QGSTN	CHAR	16	0	QST number - QC
39	TOT_CREDITS_QC	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
40	DEDUCT_CODE_QC	☐	PCA_CLAQC	PCA_CLAQC	CHAR	2	0	Claim code Québec	T5KCQ
41	ADD_DEDUCT_QCEA	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
42	OTH_DED_CRT_QC8	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
43	OTH_CREDITS_QCE	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
44	OTH_DEDUCT_QC	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
45	BASE_YEAR_QCIT	☐	PCA_INDYR	PCA_INDYR	CHAR	1	0	Base Year QC
46	GROSSCOM_INC_QC	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
47	EST_NET_COMM_QC	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
48	PERC_COMM_QC	☐	PCA_COMPQ	PROZPB	DEC	3	0	Percentage of Commission - Québec
49	TAXAUTHORITY01	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
50	TAXINDICATOR01	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
51	NAMEOFTAXAUTH01	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
52	TAXAUTHORITY02	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
53	TAXINDICATOR02	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
54	NAMEOFTAXAUTH02	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
55	TAXAUTHORITY03	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
56	TAXINDICATOR03	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
57	NAMEOFTAXAUTH03	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
58	TAXAUTHORITY04	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
59	TAXINDICATOR04	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
60	NAMEOFTAXAUTH04	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
61	TAXAUTHORITY05	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
62	TAXINDICATOR05	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
63	NAMEOFTAXAUTH05	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
64	TAXAUTHORITY06	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
65	TAXINDICATOR06	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
66	NAMEOFTAXAUTH06	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
67	TAXAUTHORITY07	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
68	TAXINDICATOR07	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
69	NAMEOFTAXAUTH07	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
70	TAXAUTHORITY08	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
71	TAXINDICATOR08	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
72	NAMEOFTAXAUTH08	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
73	TAXAUTHORITY09	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
74	TAXINDICATOR09	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
75	NAMEOFTAXAUTH09	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
76	TAXAUTHORITY10	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
77	TAXINDICATOR10	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
78	NAMEOFTAXAUTH10	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
79	TAXAUTHORITY11	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
80	TAXINDICATOR11	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
81	NAMEOFTAXAUTH11	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
82	TAXAUTHORITY12	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
83	TAXINDICATOR12	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
84	NAMEOFTAXAUTH12	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
85	TAXAUTHORITY13	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
86	TAXINDICATOR13	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
87	NAMEOFTAXAUTH13	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
88	TAXAUTHORITY14	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
89	TAXINDICATOR14	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
90	NAMEOFTAXAUTH14	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
91	TAXAUTHORITY15	☐	PCA_TAXAU	PCA_TAXAU	CHAR	4	0	Tax authority	T5KTO
92	TAXINDICATOR15	☐	PCA_EXIND	PCA_EXIND	CHAR	1	0	Tax indicator / exemption code	T5KIN
93	NAMEOFTAXAUTH15	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
94	MARRIED	☐	PCA_MARRD	PCA_MARRD	CHAR	1	0	Married or equivalent-to-spouse
95	TOT_CREDITS_PROV	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
96	OTH_CREDITS_PROV	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIP0224L	CLAIM_CODE	T5KCF	CLAIM	REF
2	BAPIP0224L	CURRENCY	TCURC	WAERS
3	BAPIP0224L	DEDUCT_CODE_QC	T5KCQ	CLAQC	REF
4	BAPIP0224L	METROPOL_AREA	T5KAR	RCITY	REF
5	BAPIP0224L	REASON_FOR_CHNG	T530E	PREAS	KEY	1	CN
6	BAPIP0224L	STD_JURISDICT	T5KAW	WRKAR	REF
7	BAPIP0224L	TAXAUTHORITY01	T5KTO	TAXAU	REF
8	BAPIP0224L	TAXAUTHORITY02	T5KTO	TAXAU	REF
9	BAPIP0224L	TAXAUTHORITY03	T5KTO	TAXAU	REF
10	BAPIP0224L	TAXAUTHORITY04	T5KTO	TAXAU	REF
11	BAPIP0224L	TAXAUTHORITY05	T5KTO	TAXAU	REF
12	BAPIP0224L	TAXAUTHORITY06	T5KTO	TAXAU	REF
13	BAPIP0224L	TAXAUTHORITY07	T5KTO	TAXAU	REF
14	BAPIP0224L	TAXAUTHORITY08	T5KTO	TAXAU	REF
15	BAPIP0224L	TAXAUTHORITY09	T5KTO	TAXAU	REF
16	BAPIP0224L	TAXAUTHORITY10	T5KTO	TAXAU	REF
17	BAPIP0224L	TAXAUTHORITY11	T5KTO	TAXAU	REF
18	BAPIP0224L	TAXAUTHORITY12	T5KTO	TAXAU	REF
19	BAPIP0224L	TAXAUTHORITY13	T5KTO	TAXAU	REF
20	BAPIP0224L	TAXAUTHORITY14	T5KTO	TAXAU	REF
21	BAPIP0224L	TAXAUTHORITY15	T5KTO	TAXAU	REF
22	BAPIP0224L	TAXINDICATOR01	T5KIN	EXIND	REF
23	BAPIP0224L	TAXINDICATOR02	T5KIN	EXIND
24	BAPIP0224L	TAXINDICATOR03	T5KIN	EXIND
25	BAPIP0224L	TAXINDICATOR04	T5KIN	EXIND
26	BAPIP0224L	TAXINDICATOR05	T5KIN	EXIND
27	BAPIP0224L	TAXINDICATOR06	T5KIN	EXIND
28	BAPIP0224L	TAXINDICATOR07	T5KIN	EXIND
29	BAPIP0224L	TAXINDICATOR08	T5KIN	EXIND
30	BAPIP0224L	TAXINDICATOR09	T5KIN	EXIND
31	BAPIP0224L	TAXINDICATOR10	T5KIN	EXIND
32	BAPIP0224L	TAXINDICATOR11	T5KIN	EXIND
33	BAPIP0224L	TAXINDICATOR12	T5KIN	EXIND
34	BAPIP0224L	TAXINDICATOR13	T5KIN	EXIND
35	BAPIP0224L	TAXINDICATOR14	T5KIN	EXIND
36	BAPIP0224L	TAXINDICATOR15	T5KIN	EXIND
37	BAPIP0224L	TAX_AREA	T5KAW	WRKAR	REF

History

Last changed by/on	SAP	20050411
SAP Release Created in