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
⤷ 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 |