SAP ABAP Table P11_P35L_C (HR-IE: Complete EOY work structure)
Hierarchy
☛
SAP_HRCIE (Software Component) Sub component SAP_HRCIE of SAP_HR
⤷ PY-IE (Application Component) Ireland
⤷ PC11 (Package) HR payroll: Ireland
⤷ PY-IE (Application Component) Ireland
⤷ PC11 (Package) HR payroll: Ireland
Basic Data
Table Category | INTTAB | Structure |
Structure | P11_P35L_C | Table Relationship Diagram |
Short Description | HR-IE: Complete EOY work structure |
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 | HR-IE: General List output header | |||||
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
3 | BUTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
4 | WERKS | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | T500P | |
5 | NAME1 | PBTXT | TEXT30 | CHAR | 30 | 0 | Personnel Area Text | ||
6 | BTRTL | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | T001P | |
7 | BTEXT | BTRTX | TEXT15 | CHAR | 15 | 0 | Personnel Subarea Text | ||
8 | PERSG | PERSG | PERSG | CHAR | 1 | 0 | Employee Group | T501 | |
9 | PGTXT | PGTXT | TEXT20 | CHAR | 20 | 0 | Name of Employee Group | ||
10 | PERSK | PERSK | PERSK | CHAR | 2 | 0 | Employee Subgroup | T503K | |
11 | PKTXT | PKTXT | TEXT20 | CHAR | 20 | 0 | Name of Employee Subgroup | ||
12 | ORGEH | ORGEH | ORGEH | NUMC | 8 | 0 | Organizational Unit | T527X | |
13 | ORGTX | ORGTX | TEXT25 | CHAR | 25 | 0 | Short Text of Organizational Unit | ||
14 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
15 | KOSTT | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
16 | ABKRS | ABKRS | ABKRS | CHAR | 2 | 0 | Payroll Area | T549A | |
17 | ABKTX | ABKTX | TEXT20 | CHAR | 20 | 0 | Payroll Area Text | ||
18 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
19 | .INCLUDE | 0 | 0 | HR-IE: Reporting structure EOY Certificates of Pay/Tax/PRSI | |||||
20 | ER_NAME | PIE_ENAME | PIE_ENAME | CHAR | 30 | 0 | Employer Name | ||
21 | ER_ADR1 | PIE_EADDR | PIE_EADDR | CHAR | 30 | 0 | Employer address line | ||
22 | ER_ADR2 | PIE_EADDR | PIE_EADDR | CHAR | 30 | 0 | Employer address line | ||
23 | ER_ADR3 | PIE_EADDR | PIE_EADDR | CHAR | 30 | 0 | Employer address line | ||
24 | ERNIE | PIE_ERNIE | PIE_ERNIE | CHAR | 9 | 0 | Employer's Registered Number | ||
25 | ERNDT | PIE_ERNDAT | DATUM | DATS | 8 | 0 | Date of ERN change | ||
26 | EUNIE | PIE_EUNIE | PIE_EUNIE | NUMC | 3 | 0 | Employer´s Unit Number | ||
27 | WTEXT | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
28 | PERID | PRDNI | CHAR20 | CHAR | 20 | 0 | Personnel ID Number | ||
29 | ACTVE | STAT2 | STATA | CHAR | 1 | 0 | Employment Status | ||
30 | ENAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
31 | NACHN | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
32 | VORNA | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
33 | NAME2 | PAD_NAME2 | PAD_NACHN | CHAR | 40 | 0 | Name at Birth | ||
34 | GBDAT | GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
35 | GESCH | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
36 | LINE0 | P11_ADRS1_IE | CHAR80 | CHAR | 80 | 0 | HR-IE: Legal reporting Address line 1 | ||
37 | LINE1 | P11_ADRS2_IE | CHAR80 | CHAR | 80 | 0 | HR-IE: Legal reporting Address line 2 | ||
38 | LINE2 | P11_ADRS3_IE | CHAR80 | CHAR | 80 | 0 | HR-IE: Legal reporting Address line 3 | ||
39 | LINE3 | P11_ADRS4 | CHAR80 | CHAR | 80 | 0 | HR-IE: Legal reporting Address line 4 | ||
40 | PSTLZ | PSTLZ_HR | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
41 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
42 | TXTBL | PIE_TXTBL | PIE_TXTBL | CHAR | 1 | 0 | Tax Table | ||
43 | STARTD | P11_STARTD | DATUM | DATS | 8 | 0 | P60-IE: Start date of work | ||
44 | LEAVED | P11_LEAVED | DATUM | DATS | 8 | 0 | P60-IE: Leaving date | ||
45 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
46 | ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
47 | TREFI | P11_TXREF | CHAR01 | CHAR | 1 | 0 | HR-IE: MM2 Tax refund symbol | ||
48 | W53FL | P11_WKID | CHAR01 | CHAR | 1 | 0 | HR-IE: MM2 Week 53, 54, or 56 indicator | ||
49 | DIRFL | P11_DIRFL | XFELD | CHAR | 1 | 0 | HR-IE: EOY Director Flag | ||
50 | TAXYR | P11_TAXYR | GJAHR | NUMC | 4 | 0 | HR-IE: Tax year (for reports) | ||
51 | RETTP | PIE_RETTP | PIE_RETTP | CHAR | 1 | 0 | PY-IE : Type of Submission to ROS | ||
52 | CNAME | P11_CNNAME | CHAR20 | CHAR | 20 | 0 | HR-IE: Contact name | ||
53 | CPHON | P11_CNPHON | CHAR12 | CHAR | 12 | 0 | HR-IE: Contact Phone number | ||
54 | CEMAIL | P11_EMAIL | TEXT40 | CHAR | 40 | 0 | HR-IE: Contact Email | ||
55 | M1W1I | P11_M1W1I | CHAR1 | CHAR | 1 | 0 | P60-IE: Week 1/Month 1Indicator | ||
56 | .INCLUDE | 0 | 0 | HR-IE: Reporting structure EOY Certificate of PRSI | |||||
57 | TWEEK | P11_TWEEK | NUMC2 | NUMC | 2 | 0 | HR-IE: P35L Total PRSI Weeks | ||
58 | INITC | P11_INITC | PIE_PRSIC | CHAR | 2 | 0 | HR-IE: P35L Initial PRSI Class | ||
59 | CLASO | P11_CLASO | PIE_PRSIC | CHAR | 2 | 0 | HR-IE: P35L Other PRSI Class | ||
60 | WEEKO | P11_WEEKO | NUMC2 | NUMC | 2 | 0 | HR-IE: P35L Number of PRSI Weeks in other Class | ||
61 | CLAS2 | P11_CLAS2 | PIE_PRSIC | CHAR | 2 | 0 | HR-IE: P35L Second PRSI Class | ||
62 | WEEK2 | P11_WEEK2 | NUMC2 | NUMC | 2 | 0 | HR-IE: P35L Number of PRSI Weeks in Second Class | ||
63 | CLAS3 | P11_CLAS3 | PIE_PRSIC | CHAR | 2 | 0 | HR-IE: P35L Third PRSI Class | ||
64 | WEEK3 | P11_WEEK3 | NUMC2 | NUMC | 2 | 0 | HR-IE: P35L Number of PRSI Weeks in Third Class | ||
65 | CLAS4 | P11_CLAS4 | PIE_PRSIC | CHAR | 2 | 0 | HR-IE: P35L Fourth PRSI Class | ||
66 | WEEK4 | P11_WEEK4 | NUMC2 | NUMC | 2 | 0 | HR-IE: P35L Number of PRSI Weeks in Fourth Class | ||
67 | .INCLUDE | 0 | 0 | HR-IE: Reporting structure EOY Certificate of Pay/Tax/PRSI | |||||
68 | P_EARN | P11_PEARN | PRBETRG | CURR | 15 | 2 | P60-IE: Previous Earnings | ||
69 | C_EARN | P11_CEARN | PRBETRG | CURR | 15 | 2 | P60-IE: Current Earnings | ||
70 | T_EARN | P11_TEARN_IE | PRBETRG | CURR | 15 | 2 | P60-IE: Total Earnings | ||
71 | TREARN | P11_TREAR | PRBETRG | CURR | 15 | 2 | HR-IE: P35L Current earning Rounded | ||
72 | P_TAX | P11_PTAX | PRBETRG | CURR | 15 | 2 | P60-IE: Previous Tax | ||
73 | C_TAX | P11_CTAX | PRBETRG | CURR | 15 | 2 | P60-IE: Current Tax | ||
74 | T_TAX | P11_TTAX | PRBETRG | CURR | 15 | 2 | P60-IE: Total Tax | ||
75 | TFATO | P11_TFATO | PRBETRG | CURR | 15 | 2 | HR-IE: P35L Tax Credit | ||
76 | CUTOF | P11_CTOFF | PRBETRG | CURR | 15 | 2 | HR-IE: P35L Tax Cut-off as YTD | ||
77 | EEPRS | P11_EEPRS | PRBETRG | CURR | 15 | 2 | HR-IE: Employee PRSI | ||
78 | ERPRS | P11_ERPRS | PRBETRG | CURR | 15 | 2 | HR-IE: Employer PRSI | ||
79 | TOPRS | P11_TOPRS | PRBETRG | CURR | 15 | 2 | HR-IE: Total PRSI (EE+ER) | ||
80 | TXBNF | P11_TXBNF | PRBETRG | CURR | 15 | 2 | HR-IE: Taxable Benefits | ||
81 | TBKMI | P11_TBKMI | PRBETRG | CURR | 15 | 2 | HR-IE: Benefit in Kind for Medical Insurance | ||
82 | ILBEN | P11_ILBEN | PRBETRG | CURR | 15 | 2 | HR-IE: Illness Benefit | ||
83 | .INCLUDE | 0 | 0 | HR-IE: Pension Schemes for EOY/P35L | |||||
84 | RBEEC | P11_RBEEC_XML | PRBETRG | CURR | 15 | 2 | Tot. amt. contd. by Employees to Retirement Benefit Scheme | ||
85 | RBERC | P11_RBERC_XML | PRBETRG | CURR | 15 | 2 | Total amount contributed by Employer to Ret. Benefit Scheme | ||
86 | PPEEC | P11_PPEEC_XML | PRBETRG | CURR | 15 | 2 | Total amount contributed by Employees to PRSA Products | ||
87 | PPERC | P11_PPERC_XML | PRBETRG | CURR | 15 | 2 | Total amount contributed by Employer to PRSA Products | ||
88 | RAEEC | P11_RAEEC_XML | PRBETRG | CURR | 15 | 2 | Total amount contributed by Employees to Retirement Annuity | ||
89 | .INCLUDE | 0 | 0 | HR IE: Reporting structure ILVY Certificate | |||||
90 | LY_PY | P11_LY_PY | PRBETRG | CURR | 15 | 2 | HR IE: Total Levy Payable | ||
91 | LEVYP | P11_LEVYP | PRBETRG | CURR | 15 | 2 | HR IE: Total Levy Paid | ||
92 | F_LY_PY | P11_F_LY_PY | PRBETRG | CURR | 15 | 2 | HR IE: Levy Payable Jan 1st to 30th April '09 | ||
93 | F_LEVYP | P11_F_LEVYP | PRBETRG | CURR | 15 | 2 | HR IE: Levy Paid Jan 1st to 30th April '09 | ||
94 | S_LY_PY | P11_S_LY_PY | PRBETRG | CURR | 15 | 2 | HR IE: Levy Payable May 1st to 31st Dec '09 | ||
95 | S_LEVYP | P11_S_LEVYP | PRBETRG | CURR | 15 | 2 | HR IE: Levy Paid May 1st to 31st Dec '09 | ||
96 | C_LY_P | P11_C_LY_P | PRBETRG | CURR | 15 | 2 | HR IE: Car Parking Levy | ||
97 | LY_EXCLU | P11_XFIELD | XFELD | CHAR | 1 | 0 | HR IE: Excluded from Income Levy | ||
98 | USC_PY | P11_USC_PY | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Payable | ||
99 | USC_PD | P11_USC_PD | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Paid | ||
100 | USC_EXCL | P11_USC_EX | XFELD | CHAR | 1 | 0 | HR IE: Excluded from USC | ||
101 | USC_PY_PR | P11_USC_PY_PR | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Payable Prev Emp | ||
102 | USC_PD_PR | P11_USC_PD_PR | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Paid Prev Emp | ||
103 | USC_PY_CU | P11_USC_PY_CU | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Payable Current | ||
104 | USC_PD_CU | P11_USC_PD_CU | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Paid Current | ||
105 | UREFI | P11_USREF | CHAR01 | CHAR | 1 | 0 | HR-IE: MM2 USC refund symbol | ||
106 | USC_RATE1 | PIE_USC_TR_YR1 | PIE_CRNCY | CURR | 11 | 2 | USC Rate1 Cut Off Point ( Yearly ) | ||
107 | USC_RATE2 | PIE_USC_TR_YR2 | PIE_CRNCY | CURR | 11 | 2 | USC Rate2 Cut Off Point ( Yearly ) | ||
108 | .INCLUDE | 0 | 0 | HR-IE: Reporting structure EOY Certificate of PRD | |||||
109 | PRDTY | P11_PRDTY | P11_PRDTY | CHAR | 1 | 0 | HR IE : PRD Form Type | ||
110 | PRDST | P11_PRDST | DATUM | DATS | 8 | 0 | HR IE : PRD Date | ||
111 | PRDEN | P11_PRDEN | DATUM | DATS | 8 | 0 | HR IE : PRD End Date | ||
112 | PRDPG | P11_PRDPG | PRBETRG | CURR | 15 | 2 | HR IE : PRD Previous Employment Gross Income | ||
113 | PRDPD | P11_PRDPD | PRBETRG | CURR | 15 | 2 | HR IE : PRD Previous Employment Deduction | ||
114 | PRDCG | P11_PRDCG | PRBETRG | CURR | 15 | 2 | HR IE : PRD This Employment Gross Income | ||
115 | PRDCD | P11_PRDCD | PRBETRG | CURR | 15 | 2 | HR IE : PRD This Employment Deduction | ||
116 | PRDADJ | P11_PRDADJ | PRBETRG | CURR | 15 | 2 | HR IE : PRD Previous Year Adjustment | ||
117 | LSTARTD | P11_STARTD | DATUM | DATS | 8 | 0 | P60-IE: Start date of work | ||
118 | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | |||
119 | EMAIL_ID | COMM_ID_LONG | COMM_ID_LONG | CHAR | 241 | 0 | Communication: Long Identification/Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | P11_P35L_C | ABKRS | T549A | ABKRS | |||
2 | P11_P35L_C | BTRTL | T001P | BTRTL | |||
3 | P11_P35L_C | ORGEH | T527X | ORGEH | |||
4 | P11_P35L_C | PERSG | T501 | PERSG | |||
5 | P11_P35L_C | PERSK | T503K | PERSK | |||
6 | P11_P35L_C | WERKS | T500P | PERSA |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 46C |