SAP ABAP Table PCAPG (Personnel grouping CA)

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	PCAPG	Table Relationship Diagram
Short Description	Personnel grouping CA

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	Field String for Feature - Screen Control
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
4	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
5	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
6	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
7	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
8	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
9	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
10	DYNNR	☐	DYNNR	DYNNR	CHAR	4	0	Number of the following screen
11	FCODE	☐	FCODE	FCODE	CHAR	20	0	Function code
12	ITYGR	☐	ITYGR	DLGGR	CHAR	2	0	Infotype Group Number	*
13	MASSN	☐	MASSN	MASSN	CHAR	2	0	Action Type	T529A
14	MASSG	☐	MASSG	MASSG	CHAR	2	0	Reason for Action	T530
15	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	T500L
16	MOABW	☐	MOABW	MOABW	NUMC	2	0	Personnel subarea grouping for absence and attendance types
17	TCLAS	☐	TCLAS	TCLAS	CHAR	1	0	Transaction Class for Data Retention
18	USERG	☐	USERG	USERG	CHAR	2	0	User group
19	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
20	ANSVH	☐	ANSVH	ANSVH	CHAR	2	0	Work Contract	*
21	.INCLUDE	☐				0	0	Payroll results - master data from infotypes 0461-0463
22	CNTR1	☐	CNTRN	RAW1	RAW	1	0	National assignment indicator
23	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
24	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
25	STAT2	☐	STAT2	STATA	CHAR	1	0	Employment Status
26	WRKAR	☐	PCA_WRKAR	PCA_WRKAR	CHAR	4	0	Province of employment	*
27	RESAR	☐	PCA_RESAR	PCA_WRKAR	CHAR	4	0	Employment standard jurisdiction	*
28	RCITY	☐	PCA_RESAR	PCA_WRKAR	CHAR	4	0	Employment standard jurisdiction	*
29	REGNR	☐	PCA_REGNR	NUMC09	NUMC	9	0	Registration Number
30	ACNBF	☐	PCA_ACNBF	PCA_ACNBF	NUMC	4	0	Account 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	*
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	TEXHD	☐	PCA_TEXHD	PCA_AMT	CURR	9	2	Designated area deduction
38	NODEP	☐	PCA_NODEP	PCA_NODEP	NUMC	2	0	No. of dependants under 18 yrs.
39	NODIS	☐	PCA_NODIS	PCA_NODEP	NUMC	2	0	No. of dependants 18 yrs. or older and disabled
40	MNTDE	☐	PCA_MNTDE	PCA_AMT	CURR	9	2	Annual authorized federal deductions
41	OTXCR	☐	PCA_OTXCR	PCA_AMT	CURR	9	2	Annual authorized federal tax credits
42	LBTCR	☐	PCA_LBTCR	PCA_AMT	CURR	9	2	Amount paid for purchase of labour-sponsored funds
43	CRTDE	☐	PCA_CRTDE	PCA_AMT	CURR	9	2	Court Order Deduction - Alimony Maintenance Payments
44	COMRE	☐	PCA_COMRE	PCA_AMT	CURR	9	2	Estimated total remuneration
45	COMEX	☐	PCA_COMEX	PCA_AMT	CURR	9	2	Estimated expenses
46	QCTXI	☐	PCA_QCTXI	PCA_QCTXI	CHAR	16	0	Taxation identification number - QC
47	QGSTN	☐	PCA_QGSTN	PCA_QGSTN	CHAR	16	0	QST number - QC
48	TOTCQ	☐	PCA_TOTCQ	PCA_AMT	CURR	9	2	Total personal tax credit amount - QC
49	CLAQC	☐	PCA_CLAQC	PCA_CLAQC	CHAR	2	0	Claim code Québec	*
50	ADDTQ	☐	PCA_ADDTQ	PCA_AMT	CURR	9	2	Additional tax deduction - Provincial
51	OTHDE	☐	PCA_OTHDE	PCA_AMT	CURR	9	2	Other annual deductions and credits - QC
52	OTXCQ	☐	PCA_OTXCQ	PCA_AMT	CURR	9	2	Other annual authorized tax credits - QC
53	OTADE	☐	PCA_OTADE	PCA_AMT	CURR	9	2	Other annual authorized deductions - QC
54	COMEQ	☐	PCA_COMEQ	PCA_AMT	CURR	9	2	Estimated annual net commission income - QC
55	MARRD	☐	PCA_MARRD	PCA_MARRD	CHAR	1	0	Married or equivalent-to-spouse
56	LSTPY	☐	PCA_LSTPY	DATUM	DATS	8	0	Date of last irregular pay (for CPP/QPP exemption)
57	PROVR	☐	PCA_PROVR	PCA_WRKAR	CHAR	4	0	Province of residence	*
58	WNSBN	☐	PCA_WNSBN	PCA_CBUSN	CHAR	15	0	Business Number for WCB purposes
59	TOTCP	☐	PCA_TOTCP	PCA_AMT	CURR	9	2	Provincial total tax credits
60	OTXCP	☐	PCA_OTXCP	PCA_AMT	CURR	9	2	Other provincial authorized tax credits
61	LBTCP	☐	PCA_LBTCP	PCA_AMT	CURR	9	2	Provincial Labour-Sponsored Tax Credit
62	PVTAX	☐	PCA_PVTAX	PCA_PVTAX	CHAR	4	0	Province of taxation (CE)	*
63	PHLTH	☐	PCA_PHLTH	PCA_WRKAR	CHAR	4	0	Province of Health Tax	*
64	LGART	☐	LGART	LGART	CHAR	4	0	Wage Type	T512W

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PCAPG	BTRTL	T001P	BTRTL
2	PCAPG	BUKRS	T001	BUKRS
3	PCAPG	INFTY	T582A	INFTY
4	PCAPG	LGART	T512W	LGART		1	1
5	PCAPG	MASSG	T530	MASSG
6	PCAPG	MASSN	T529A	MASSN
7	PCAPG	MOLGA	T500L	MOLGA
8	PCAPG	PERSG	T501	PERSG
9	PCAPG	PERSK	T503K	PERSK
10	PCAPG	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20130529
SAP Release Created in