SAP ABAP Table P08_P60_CL (HR-GB: Complete EOY work structure)

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PY-GB (Application Component) United Kingdom
     ⤷ PC08 (Package) HR accounting: GB

Basic Data

Table Category	INTTAB	Structure
Structure	P08_P60_CL	Table Relationship Diagram
Short Description	HR-GB: 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-GB: 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-GB: 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	☐	TDRCE	TDRCE	CHAR	10	0	Tax district indicator	*
25	TDNUM	☐	TDNUM	TDNUM	CHAR	3	0	Tax district number	*
26	TDNME	☐	TDNME	CHAR30	CHAR	30	0	Name of tax district
27	PRMNO	☐	PRMNO	P08_PRMNO	CHAR	12	0	Permit number	*
28	ECONR	☐	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	☐	P08_ADRS1	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 1
39	LINE1	☐	P08_ADRS2	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 2
40	LINE2	☐	P08_ADRS3	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 3
41	LINE3	☐	P08_ADRS4	CHAR80	CHAR	80	0	HR-GB: 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	☐	P08_TXCODE	CHAR8	CHAR	8	0	Tax Code
45	M1W1I	☐	P08_M1W1I	CHAR1	CHAR	1	0	P60-GB: Week 1/Month 1Indicator
46	WEEK53	☐	P08_WKID	CHAR01	CHAR	1	0	HR-GB: MM2 Week 53, 54, or 56 indicator
47	STARTD	☐	P08_STARTD	DATUM	DATS	8	0	P60-GB: Start date of work
48	LEAVED	☐	P08_LEAVED	DATUM	DATS	8	0	P60-GB: Leaving date
49	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
50	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
51	PENID	☐	P08_PENID	CHAR01	CHAR	1	0	HR-GB: MM2 Pension indicator
52	DIRID	☐	P08_DIRID	CHAR01	CHAR	1	0	HR-GB: MM2 Director indicator
53	TREFI	☐	P08_TXREF	CHAR01	CHAR	1	0	HR-GB: MM2 Tax refund symbol
54	SUREF	☐	P08_SUREF	CHAR01	CHAR	1	0	HR-GB: MM2 Superannuation refund symbol
55	TAXYR	☐	P08_TAXYR	GJAHR	NUMC	4	0	HR-GB: Tax year (for reports)
56	ERADD	☐	P08_ERADD	CHAR60	CHAR	60	0	HR-GB: MM1 Employer's address
57	LINE0_2	☐	P08_ADRS1	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 1
58	LINE1_2	☐	P08_ADRS2	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 2
59	LINE2_2	☐	P08_ADRS3	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 3
60	LINE3_2	☐	P08_ADRS4	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 4
61	PSTLZ_2	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
62	EMAIL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
63	EMAIL_ID	☐	COMM_ID_LONG	COMM_ID_LONG	CHAR	241	0	Communication: Long Identification/Number
64	.INCLUDE	☐				0	0	HR-GB: Reporting structure EOY Certificate of Pay/Tax/NI
65	NICAT	☐	NICAT	NICAT	CHAR	2	0	NI category (GB)	*
66	CTOUT	☐	P08_CTOUT	XFELD	CHAR	1	0	Contracted Out Flag
67	AMTTOLEL	☐	P08_TOLEL	PRBETRG	CURR	15	2	Niable pay up to LEL
68	AMTLELEET	☐	P08_TOEET	PRBETRG	CURR	15	2	Niable pay between LEL and ST
69	AMTEETERT	☐	P08_TOERT	PRBETRG	CURR	15	2	Niable pay between ST and PT
70	AMTERTUEL	☐	P08_TOUEL	PRBETRG	CURR	15	2	Niable pay between UAP and UEL
71	AMTFROMUEL	☐	P08_FMUEL	PRBETRG	CURR	15	2	Niable pay above UEL
72	EENIC	☐	P08_NIC_EE	PRBETRG	CURR	15	2	Employee NICs
73	ERNIC	☐	P08_NIC_ER	PRBETRG	CURR	15	2	Employer NICs
74	EENIR	☐	P08_NIREE	PRBETRG	CURR	15	2	Employee (primary) NI rebate
75	ERNIR	☐	P08_NIRER	PRBETRG	CURR	15	2	Employer (secondary) NI rebate
76	EEERS	☐	P08_EEERN	PRBETRG	CURR	15	2	HR-GB: Sum Employer's and employee's NIC (for P60)
77	NIREF	☐	P08_NIREF	CHAR01	CHAR	1	0	HR-GB: MM2 NI refund symbol
78	PSCON	☐	P08_SCON	CHAR9	CHAR	9	0	Pension scheme contracted out number
79	AMTERTUAP	☐	P08_TOUAP	PRBETRG	CURR	15	2	Niable pay between PT and UAP
80	AMTLELPT	☐	P08_LTOPT	PRBETRG	CURR	15	2	Niable pay from LEL to PT
81	.INCLUDE	☐				0	0	HR-GB: Reporting structure EOY Certificate of Pay/Tax/NI
82	WIDOR	☐	P08_WIDOW	PRBETRG	CURR	15	2	P60-GB: Widows and Orphan's fund
83	P_EARN	☐	P08_PEARN	PRBETRG	CURR	15	2	P60-GB: Previous Earnings
84	C_EARN	☐	P08_CEARN	PRBETRG	CURR	15	2	P60-GB: Current Earnings
85	T_EARN	☐	P08_TEARN	PRBETRG	CURR	15	2	P60-GB: Total Earnings
86	P_TAX	☐	P08_PTAX	PRBETRG	CURR	15	2	P60-GB: Previous Tax
87	C_TAX	☐	P08_CTAX	PRBETRG	CURR	15	2	P60-GB: Current Tax
88	T_TAX	☐	P08_TTAX	PRBETRG	CURR	15	2	P60-GB: Total Tax
89	SLOAN	☐	P08_SLOAN	PRBETRG	CURR	15	2	P60-GB: Student loan
90	TCRED	☐	P08_TCRED	PRBETRG	CURR	15	2	P60-GB: Tax Credit
91	SSPBT	☐	P08_SSPBT	PRBETRG	CURR	15	2	P60-GB: Amount Statutory Sick Pay
92	SMPBT	☐	P08_SMPBT	PRBETRG	CURR	15	2	P60-GB: Amount Statutory Maternity Pay
93	SMPRC	☐	P08_RCSMP	PRBETRG	CURR	15	2	P35-GB: Recovered Statutory Maternity Pay
94	NICRB	☐	P08_EENIR	PRBETRG	CURR	15	2	P60-GB: Employee's NI Rebate
95	NIRTO	☐	P08_NIRTO	PRBETRG	CURR	15	2	P60-GB: Sum Employee and Employer NI Rebate
96	SUPER	☐	P08_SANNU	PRBETRG	CURR	15	2	P60-GB: Super annuation
97	TOGRP	☐	P08_TOGRP	PRBETRG	CURR	15	2	P60-GB: Total Gross Pay
98	SPPBT	☐	P08_SPPBT	PRBETRG	CURR	15	2	P60-GB: Amount Statutory Paternity Pay
99	RCSPP	☐	P08_RCSPP	PRBETRG	CURR	15	2	P35-GB: Recovered Statutory Paternity Pay
100	SAPBT	☐	P08_SAPBT	PRBETRG	CURR	15	2	P60-GB: Amount Statutory Adoption Pay
101	RCSAP	☐	P08_RCSAP	PRBETRG	CURR	15	2	P35-GB: Recovered Statutory Adoption Pay
102	ASPBT	☐	P08_ASPBT	PRBETRG	CURR	15	2	P60-GB: Amount Additional Statutory Paternity Pay
103	RCASP	☐	P08_RCASP	PRBETRG	CURR	15	2	P35-GB: Recovered Additional Statutory Paternity Pay

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in