SAP ABAP Table P08_P60_VER3 (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_VER3	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	SCHTY	☐	P08_SCHTY	P08_SCHTY	CHAR	1	0	Employer's scheme type
30	WTEXT	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
31	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
32	ACTVE	☐	STAT2	STATA	CHAR	1	0	Employment Status
33	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
34	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
35	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
36	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
37	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
38	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
39	LINE0	☐	P08_ADRS1	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 1
40	LINE1	☐	P08_ADRS2	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 2
41	LINE2	☐	P08_ADRS3	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 3
42	LINE3	☐	P08_ADRS4	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 4
43	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
44	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
45	TXCOD	☐	P08_TXCODE	CHAR8	CHAR	8	0	Tax Code
46	M1W1I	☐	P08_M1W1I	CHAR1	CHAR	1	0	P60-GB: Week 1/Month 1Indicator
47	WEEK53	☐	P08_WKID	CHAR01	CHAR	1	0	HR-GB: MM2 Week 53, 54, or 56 indicator
48	STARTD	☐	P08_STARTD	DATUM	DATS	8	0	P60-GB: Start date of work
49	LEAVED	☐	P08_LEAVED	DATUM	DATS	8	0	P60-GB: Leaving date
50	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
51	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
52	PENID	☐	P08_PENID	CHAR01	CHAR	1	0	HR-GB: MM2 Pension indicator
53	DIRID	☐	P08_DIRID	CHAR01	CHAR	1	0	HR-GB: MM2 Director indicator
54	TREFI	☐	P08_TXREF	CHAR01	CHAR	1	0	HR-GB: MM2 Tax refund symbol
55	SUREF	☐	P08_SUREF	CHAR01	CHAR	1	0	HR-GB: MM2 Superannuation refund symbol
56	TAXYR	☐	P08_TAXYR	GJAHR	NUMC	4	0	HR-GB: Tax year (for reports)
57	ERADD	☐	P08_ERADD	CHAR60	CHAR	60	0	HR-GB: MM1 Employer's address
58	.INCLUDE	☐				0	0	HR-GB: Reporting structure EOY Certificate of Pay/Tax/NI
59	NICAT	☐	NICAT	NICAT	CHAR	2	0	NI category (GB)	*
60	CTOUT	☐	P08_CTOUT	XFELD	CHAR	1	0	Contracted Out Flag
61	AMTTOLEL	☐	P08_TOLEL	PRBETRG	CURR	15	2	Niable pay up to LEL
62	AMTLELEET	☐	P08_TOEET	PRBETRG	CURR	15	2	Niable pay between LEL and ST
63	AMTEETERT	☐	P08_TOERT	PRBETRG	CURR	15	2	Niable pay between ST and PT
64	AMTERTUEL	☐	P08_TOUEL	PRBETRG	CURR	15	2	Niable pay between UAP and UEL
65	AMTFROMUEL	☐	P08_FMUEL	PRBETRG	CURR	15	2	Niable pay above UEL
66	EENIC	☐	P08_NIC_EE	PRBETRG	CURR	15	2	Employee NICs
67	ERNIC	☐	P08_NIC_ER	PRBETRG	CURR	15	2	Employer NICs
68	EENIR	☐	P08_NIREE	PRBETRG	CURR	15	2	Employee (primary) NI rebate
69	ERNIR	☐	P08_NIRER	PRBETRG	CURR	15	2	Employer (secondary) NI rebate
70	EEERS	☐	P08_EEERN	PRBETRG	CURR	15	2	HR-GB: Sum Employer's and employee's NIC (for P60)
71	NIREF	☐	P08_NIREF	CHAR01	CHAR	1	0	HR-GB: MM2 NI refund symbol
72	PSCON	☐	P08_SCON	CHAR9	CHAR	9	0	Pension scheme contracted out number
73	AMTERTUAP	☐	P08_TOUAP	PRBETRG	CURR	15	2	Niable pay between PT and UAP
74	AMTLELPT	☐	P08_LTOPT	PRBETRG	CURR	15	2	Niable pay from LEL to PT
75	.INCLUDE	☐				0	0	HR-GB: Reporting structure EOY Certificate of Pay/Tax/NI
76	WIDOR	☐	P08_WIDOW	PRBETRG	CURR	15	2	P60-GB: Widows and Orphan's fund
77	P_EARN	☐	P08_PEARN	PRBETRG	CURR	15	2	P60-GB: Previous Earnings
78	C_EARN	☐	P08_CEARN	PRBETRG	CURR	15	2	P60-GB: Current Earnings
79	T_EARN	☐	P08_TEARN	PRBETRG	CURR	15	2	P60-GB: Total Earnings
80	P_TAX	☐	P08_PTAX	PRBETRG	CURR	15	2	P60-GB: Previous Tax
81	C_TAX	☐	P08_CTAX	PRBETRG	CURR	15	2	P60-GB: Current Tax
82	T_TAX	☐	P08_TTAX	PRBETRG	CURR	15	2	P60-GB: Total Tax
83	SLOAN	☐	P08_SLOAN	PRBETRG	CURR	15	2	P60-GB: Student loan
84	TCRED	☐	P08_TCRED	PRBETRG	CURR	15	2	P60-GB: Tax Credit
85	SSPBT	☐	P08_SSPBT	PRBETRG	CURR	15	2	P60-GB: Amount Statutory Sick Pay
86	SMPBT	☐	P08_SMPBT	PRBETRG	CURR	15	2	P60-GB: Amount Statutory Maternity Pay
87	SMPRC	☐	P08_RCSMP	PRBETRG	CURR	15	2	P35-GB: Recovered Statutory Maternity Pay
88	NICRB	☐	P08_EENIR	PRBETRG	CURR	15	2	P60-GB: Employee's NI Rebate
89	NIRTO	☐	P08_NIRTO	PRBETRG	CURR	15	2	P60-GB: Sum Employee and Employer NI Rebate
90	SUPER	☐	P08_SANNU	PRBETRG	CURR	15	2	P60-GB: Super annuation
91	TOGRP	☐	P08_TOGRP	PRBETRG	CURR	15	2	P60-GB: Total Gross Pay
92	SPPBT	☐	P08_SPPBT	PRBETRG	CURR	15	2	P60-GB: Amount Statutory Paternity Pay
93	RCSPP	☐	P08_RCSPP	PRBETRG	CURR	15	2	P35-GB: Recovered Statutory Paternity Pay
94	SAPBT	☐	P08_SAPBT	PRBETRG	CURR	15	2	P60-GB: Amount Statutory Adoption Pay
95	RCSAP	☐	P08_RCSAP	PRBETRG	CURR	15	2	P35-GB: Recovered Statutory Adoption Pay
96	ASPBT	☐	P08_ASPBT	PRBETRG	CURR	15	2	P60-GB: Amount Additional Statutory Paternity Pay
97	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_VER3	ABKRS	T549A	ABKRS
2	P08_P60_VER3	BTRTL	T001P	BTRTL
3	P08_P60_VER3	ORGEH	T527X	ORGEH
4	P08_P60_VER3	PERSG	T501	PERSG
5	P08_P60_VER3	PERSK	T503K	PERSK
6	P08_P60_VER3	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C