SAP ABAP Table P11_P45_C (HR-IE: Complete P45 work structure)

Hierarchy

☛ SAP_HRCIE (Software Component) Sub component SAP_HRCIE of SAP_HR
   ⤷ PY-IE (Application Component) Ireland
     ⤷ PC11 (Package) HR payroll: Ireland

Basic Data

Table Category	INTTAB	Structure
Structure	P11_P45_C	Table Relationship Diagram
Short Description	HR-IE: Complete P45 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: Reporting structure P45 Certificates of Pay/Tax/PRSI
2	PERNR	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
3	ER_NAME	☐	PIE_ENAME	PIE_ENAME	CHAR	30	0	Employer Name
4	ER_ADR1	☐	PIE_EADDR	PIE_EADDR	CHAR	30	0	Employer address line
5	ER_ADR2	☐	PIE_EADDR	PIE_EADDR	CHAR	30	0	Employer address line
6	ER_ADR3	☐	PIE_EADDR	PIE_EADDR	CHAR	30	0	Employer address line
7	ERNIE	☐	PIE_ERNIE	PIE_ERNIE	CHAR	9	0	Employer's Registered Number
8	EUNIE	☐	PIE_EUNIE	PIE_EUNIE	NUMC	3	0	Employer´s Unit Number
9	WTEXT	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
10	RSINO	☐	PIE_PPSN	CHAR20	CHAR	20	0	HR IE: PPS Number
11	ACTVE	☐	STAT2	STATA	CHAR	1	0	Employment Status
12	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
13	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
14	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
15	NAME2	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
16	EEDOB	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
17	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
18	ADDR1	☐	P11_ADRS1_IE	CHAR80	CHAR	80	0	HR-IE: Legal reporting Address line 1
19	ADDR2	☐	P11_ADRS2_IE	CHAR80	CHAR	80	0	HR-IE: Legal reporting Address line 2
20	ADDR3	☐	P11_ADRS3_IE	CHAR80	CHAR	80	0	HR-IE: Legal reporting Address line 3
21	PSTLZ	☐	P11_IE_PSTLZ	P11_IE_PSTLZ	CHAR	40	0	Postal Code
22	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
23	PHIRE	☐	P11_STARTD	DATUM	DATS	8	0	P60-IE: Start date of work
24	FIRE	☐	P11_LEAVED	DATUM	DATS	8	0	P60-IE: Leaving date
25	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
26	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
27	W53FL	☐	P11_WKID	CHAR01	CHAR	1	0	HR-IE: MM2 Week 53, 54, or 56 indicator
28	RETTP	☐	PIE_RETTP	PIE_RETTP	CHAR	1	0	PY-IE : Type of Submission to ROS
29	EEDEC	☐	PIE_DECSD	XFELD	CHAR	1	0	HR IE: Deceased Indicator
30	.INCLUDE	☐				0	0	HR-IE: Reporting structure P45 Certificate of PRSI
31	WKSTO	☐	P11_TWEEK	NUMC2	NUMC	2	0	HR-IE: P35L Total PRSI Weeks
32	CLS01	☐	PIE_PRSIC	PIE_PRSIC	CHAR	2	0	Current PRSI Class
33	WKS01	☐	PIE_STAMP	PIE_STAMP	NUMC	2	0	Number of PRSI Contribution Weeks to be Allocated
34	CLS02	☐	P11_CLAS2	PIE_PRSIC	CHAR	2	0	HR-IE: P35L Second PRSI Class
35	WKS02	☐	P11_WEEK2	NUMC2	NUMC	2	0	HR-IE: P35L Number of PRSI Weeks in Second Class
36	CLS03	☐	P11_CLAS3	PIE_PRSIC	CHAR	2	0	HR-IE: P35L Third PRSI Class
37	WKS03	☐	P11_WEEK3	NUMC2	NUMC	2	0	HR-IE: P35L Number of PRSI Weeks in Third Class
38	CLS04	☐	P11_CLAS4	PIE_PRSIC	CHAR	2	0	HR-IE: P35L Fourth PRSI Class
39	WKS04	☐	P11_WEEK4	NUMC2	NUMC	2	0	HR-IE: P35L Number of PRSI Weeks in Fourth Class
40	.INCLUDE	☐				0	0	HR-IE: Reporting structure P45 Certificate of Pay/Tax/PRSI
41	PYTO1	☐	PIE_TEARN	PRBETRG	CURR	15	2	HR IE: Total earnings from 1st Jan of current tax year
42	PYTO2	☐	PIE_CEARN	PRBETRG	CURR	15	2	HR IE: Earnings from Current Employment
43	TXTO1	☐	PIE_TTAX	PRBETRG	CURR	15	2	HR IE: Total Tax from 1st Jan of current tax year
44	TXTO2	☐	PIE_CTAX	PRBETRG	CURR	15	2	HR IE: Tax from Current Employment
45	PRTFA	☐	P11_TFATO	PRBETRG	CURR	15	2	HR-IE: P35L Tax Credit
46	CUTOF	☐	PIE_CUTOF	PIE_CRNCY	CURR	11	2	Cut-Off Point
47	PREMP	☐	P11_EEPRS	PRBETRG	CURR	15	2	HR-IE: Employee PRSI
48	ERPRS	☐	P11_ERPRS	PRBETRG	CURR	15	2	HR-IE: Employer PRSI
49	PRTOT	☐	P11_TOPRS	PRBETRG	CURR	15	2	HR-IE: Total PRSI (EE+ER)
50	TXBNF	☐	P11_TXBNF	PRBETRG	CURR	15	2	HR-IE: Taxable Benefits
51	TFAFQ	☐	PIE_TFAFR	CHAR1	CHAR	1	0	HR IE: TFA frequency W eek, M onth
52	PERNO	☐	PIE_PERNO	CHAR2	CHAR	2	0	HR IE: Number of TFA Periods
53	LUMP	☐	PIE_LSUM	PRBETRG	CURR	15	2	HR IE: Lump Sum Payment
54	WTFAS	☐	PIE_TFAWK	PIE_CRNCY	CURR	11	2	Tax Credit (Weekly)
55	MTFAS	☐	PIE_P45TF	PIE_CRNCY	CURR	11	2	Tax Credit (Monthly)
56	WUTOF	☐	PIE_WUTOF	PRBETRG	CURR	15	2	HR IE: Weekly Cut-Off
57	MUTOF	☐	PIE_MUTOF	PRBETRG	CURR	15	2	HR IE: Monthly Cut-Off
58	TXTBL	☐	PIE_TXTBL	PIE_TXTBL	CHAR	1	0	Tax Table
59	REFUN	☐	P11_TXREF	CHAR01	CHAR	1	0	HR-IE: MM2 Tax refund symbol
60	DISW1	☐	P11_DISW1	PIE_CRNCY	CURR	11	2	HR IE: Disability tax wagetypes in P45 ( Section C )
61	DISW2	☐	P11_DISW2	PIE_CRNCY	CURR	11	2	HR IE: Disability tax wagetypes in P45( Section D )
62	DISW3	☐	P11_DISW3	PIE_CRNCY	CURR	11	2	HR IE: Disability tax wagetypes in P45( Section E )
63	DISW4	☐	P11_DISW4	PIE_CRNCY	CURR	11	2	HR IE: Disability tax wagetypes in P45( Section F )
64	SEQNO	☐	CDSEQ	NUM5	NUMC	5	0	Sequence Number
65	PAYDT	☐	PAYDT	DATUM	DATS	8	0	Pay date for awards
66	LPT	☐	PIE_LPTAX	PIE_CRNCY	CURR	11	2	Local Property Tax
67	.INCLUDE	☐				0	0	HR-IE: Reporting structure P45 Certificates of USC
68	TOT_USC_PY	☐	P11_USC_PY_P45	PRBETRG	CURR	15	2	HR IE: Total USC Payable This Employment
69	TOT_USC_PD	☐	P11_USC_PD_P45	PRBETRG	CURR	15	2	HR IE: Total USC Paid this Employment
70	UTRY1	☐	PIE_USC_TR_YR1	PIE_CRNCY	CURR	11	2	USC Rate1 Cut Off Point ( Yearly )
71	UTRY2	☐	PIE_USC_TR_YR2	PIE_CRNCY	CURR	11	2	USC Rate2 Cut Off Point ( Yearly )
72	UTBAND1	☐	P11_UTBAND1_IE	CHAR10	CHAR	10	0	HR-IE: Legal reporting USC Band 1
73	UTBAND2	☐	P11_UTBAND2_IE	CHAR10	CHAR	10	0	HR-IE: Legal reporting USC Band 2
74	TOT_USC_PY_P45	☐	P11_USC_PY	PRBETRG	CURR	15	2	HR IE: Total USC Payable
75	TOT_USC_PD_P45	☐	P11_USC_PD	PRBETRG	CURR	15	2	HR IE: Total USC Paid
76	USCRFI	☐	PIE_BOLEAN	CHAR5	CHAR	5	0	HR IE: Boolean True or False Value
77	UTRM1	☐	PIE_USC_TR_MR1	PIE_CRNCY	CURR	11	2	USC Rate1 Cut Off Point ( Monthly )
78	UTRM2	☐	PIE_USC_TR_MR2	PIE_CRNCY	CURR	11	2	USC Rate2 Cut Off Point ( Monthly )
79	UTRW1	☐	PIE_USC_TR_WR1	PIE_CRNCY	CURR	11	2	USC Rate1 Cut Off Point ( Weekly )
80	UTRW2	☐	PIE_USC_TR_WR2	PIE_CRNCY	CURR	11	2	USC Rate2 Cut Off Point ( Weekly )

History

Last changed by/on	SAP	20131127
SAP Release Created in