SAP ABAP Table P11_P60_CL (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

Basic Data

Table Category	INTTAB	Structure
Structure	P11_P60_CL	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 Certificate of Pay/Tax/NI
20	ER_NAME	☐	AD_NAME1_C	TEXT40	CHAR	40	0	Company name
21	ER_STRT	☐	AD_STREET	TEXT60	CHAR	60	0	Street
22	ER_PLZ	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
23	ER_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
24	TDREF	☐	P11_TDRCE	P11_TDRCE	CHAR	7	0	Tax district indicator	*
25	TDNUM	☐	P11_TDNUM	P11_TDNUM	CHAR	3	0	Tax district number	*
26	TDNME	☐	P11_TDNME	CHAR30	CHAR	30	0	Name of tax district
27	PRMNO	☐	P11_PRMNO	P11_PRMNO	CHAR	12	0	Permit number	*
28	ECONR	☐	P11_ECONR	CHAR9	CHAR	9	0	Employer contracted out number (ECON)
29	WTEXT	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
30	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
31	ACTVE	☐	STAT2	STATA	CHAR	1	0	Employment Status
32	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
33	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
34	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
35	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
36	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
37	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
38	LINE0	☐	P11_ADRS1_IE	CHAR80	CHAR	80	0	HR-IE: Legal reporting Address line 1
39	LINE1	☐	P11_ADRS2_IE	CHAR80	CHAR	80	0	HR-IE: Legal reporting Address line 2
40	LINE2	☐	P11_ADRS3_IE	CHAR80	CHAR	80	0	HR-IE: Legal reporting Address line 3
41	LINE3	☐	P11_ADRS4	CHAR80	CHAR	80	0	HR-IE: Legal reporting Address line 4
42	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
43	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
44	TXCOD	☐	P11_TXCODE	CHAR8	CHAR	8	0	Tax Code
45	M1W1I	☐	P11_M1W1I	CHAR1	CHAR	1	0	P60-IE: Week 1/Month 1Indicator
46	WEEK53	☐	P11_WKID	CHAR01	CHAR	1	0	HR-IE: MM2 Week 53, 54, or 56 indicator
47	STARTD	☐	P11_STARTD	DATUM	DATS	8	0	P60-IE: Start date of work
48	LEAVED	☐	P11_LEAVED	DATUM	DATS	8	0	P60-IE: Leaving date
49	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
50	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
51	PENID	☐	P11_PENID	CHAR01	CHAR	1	0	HR-IE: MM2 Pension indicator
52	DIRID	☐	P11_DIRID	CHAR01	CHAR	1	0	HR-IE: MM2 Director indicator
53	TREFI	☐	P11_TXREF	CHAR01	CHAR	1	0	HR-IE: MM2 Tax refund symbol
54	SUREF	☐	P11_SUREF	CHAR01	CHAR	1	0	HR-IE: MM2 Superannuation refund symbol
55	TAXYR	☐	P11_TAXYR	GJAHR	NUMC	4	0	HR-IE: Tax year (for reports)
56	ERADD	☐	P11_ERADD	CHAR60	CHAR	60	0	HR-IE: MM1 Employer's address
57	.INCLUDE	☐				0	0	HR-IE: Reporting structure EOY Certificate of Pay/Tax/NI
58	NICAT	☐	P11_NICAT	P11_NICAT	CHAR	2	0	NI category (IE)	*
59	CTOUT	☐	P11_CTOUT	XFELD	CHAR	1	0	Contracted Out Flag
60	AMTTOLEL	☐	P11_TOLEL	PRBETRG	CURR	15	2	Niable pay up to LEL
61	AMTLELEET	☐	P11_TOEET	PRBETRG	CURR	15	2	Niable pay between LEL and EET
62	AMTEETERT	☐	P11_TOERT	PRBETRG	CURR	15	2	Niable pay between EET and ERT
63	AMTERTUEL	☐	P11_TOUEL	PRBETRG	CURR	15	2	Niable pay between ERT and UEL
64	AMTFROMUEL	☐	P11_FMUEL	PRBETRG	CURR	15	2	Niable pay above UEL
65	EENIC	☐	P11_NIC_EE	PRBETRG	CURR	15	2	Employee NICs
66	ERNIC	☐	P11_NIC_ER	PRBETRG	CURR	15	2	Employer NICs
67	EENIR	☐	P11_NIREE	PRBETRG	CURR	15	2	Employee (primary) NI rebate
68	ERNIR	☐	P11_NIRER	PRBETRG	CURR	15	2	Employer (secondary) NI rebate
69	EEERS	☐	P11_EEERN	PRBETRG	CURR	15	2	HR-IE: Sum Employer's and employee's NIC (for P60)
70	NIREF	☐	P11_NIREF	CHAR01	CHAR	1	0	HR-IE: MM2 NI refund symbol
71	PSCON	☐	P11_SCON	CHAR9	CHAR	9	0	Pension scheme contracted out number
72	.INCLUDE	☐				0	0	HR-IE: Reporting structure EOY Certificate of Pay/Tax/NI
73	WIDOR	☐	P11_WIDOW	PRBETRG	CURR	15	2	P60-IE: Widows and Orphan's fund
74	P_EARN	☐	P11_PEARN	PRBETRG	CURR	15	2	P60-IE: Previous Earnings
75	C_EARN	☐	P11_CEARN	PRBETRG	CURR	15	2	P60-IE: Current Earnings
76	T_EARN	☐	P11_TEARN_IE	PRBETRG	CURR	15	2	P60-IE: Total Earnings
77	P_TAX	☐	P11_PTAX	PRBETRG	CURR	15	2	P60-IE: Previous Tax
78	C_TAX	☐	P11_CTAX	PRBETRG	CURR	15	2	P60-IE: Current Tax
79	T_TAX	☐	P11_TTAX	PRBETRG	CURR	15	2	P60-IE: Total Tax
80	SLOAN	☐	P11_SLOAN	PRBETRG	CURR	15	2	P60-IE: Student loan
81	TCRED	☐	P11_TCRED	PRBETRG	CURR	15	2	P60-IE: Tax Credit
82	SSPBT	☐	P11_SSPBT	PRBETRG	CURR	15	2	P60-IE: Amount Statutory Sick Pay
83	SMPBT	☐	P11_SMPBT	PRBETRG	CURR	15	2	P60-IE: Amount Statutory Maternity Pay
84	SMPRC	☐	P11_RCSMP	PRBETRG	CURR	15	2	P35-IE: Recovered Statutory Maternity Pay
85	NICRB	☐	P11_EENIR	PRBETRG	CURR	15	2	P60-IE: Employee's NI Rebate
86	NIRTO	☐	P11_NIRTO	PRBETRG	CURR	15	2	P60-IE: Sum Employee and Employer NI Rebate
87	SUPER	☐	P11_SANNU	PRBETRG	CURR	15	2	P60-IE: Super annuation
88	TOGRP	☐	P11_TOGRP	PRBETRG	CURR	15	2	P60-IE: Total Gross Pay
89	SPPBT	☐	P11_SPPBT	PRBETRG	CURR	15	2	P60-IE: Amount Statutory Paternity Pay
90	RCSPP	☐	P11_RCSPP	PRBETRG	CURR	15	2	P35-IE: Recovered Statutory Paternity Pay
91	SAPBT	☐	P11_SAPBT	PRBETRG	CURR	15	2	P60-IE: Amount Statutory Adoption Pay
92	RCSAP	☐	P11_RCSAP	PRBETRG	CURR	15	2	P35-IE: Recovered Statutory Adoption Pay

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P11_P60_CL	ABKRS	T549A	ABKRS
2	P11_P60_CL	BTRTL	T001P	BTRTL
3	P11_P60_CL	ORGEH	T527X	ORGEH
4	P11_P60_CL	PERSG	T501	PERSG
5	P11_P60_CL	PERSK	T503K	PERSK
6	P11_P60_CL	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20130529
SAP Release Created in