1. Home
  2. Resources
  3. SAP Tables
  4. P08_P60_CL - HR-GB: Complete EOY work structure

SAP Table P08_P60_CL

HR-GB: Complete EOY work structure

P08_P60_CL (HR-GB: Complete EOY work structure) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link P08_P60_CL to other SAP tables.

P08_P60_CL table fields

Field Data element Checktable Datatype Length Decimals
BUKRS Company Code BUKRS CHAR 4 0
BUTXT Name of Company Code or Company BUTXT CHAR 25 0
WERKS Personnel Area PERSA T500P CHAR 4 0
NAME1 Personnel Area Text PBTXT CHAR 30 0
BTRTL Personnel Subarea BTRTL T001P CHAR 4 0
BTEXT Personnel Subarea Text BTRTX CHAR 15 0
PERSG Employee Group PERSG T501 CHAR 1 0
PGTXT Name of Employee Group PGTXT CHAR 20 0
PERSK Employee Subgroup PERSK T503K CHAR 2 0
PKTXT Name of Employee Subgroup PKTXT CHAR 20 0
ORGEH Organizational Unit ORGEH T527X NUMC 8 0
ORGTX Short Text of Organizational Unit ORGTX CHAR 25 0
KOSTL Cost Center KOSTL CHAR 10 0
KOSTT General Name KTEXT CHAR 20 0
ABKRS Payroll Area ABKRS T549A CHAR 2 0
ABKTX Payroll Area Text ABKTX CHAR 20 0
PERNR Personnel number PERSNO NUMC 8 0
ER_NAME Company name AD_NAME1_C CHAR 40 0
ER_STRT Street AD_STREET CHAR 60 0
ER_PLZ City postal code AD_PSTCD1 CHAR 10 0
ER_CITY City AD_CITY1 CHAR 40 0
TDREF Tax district indicator TDRCE CHAR 10 0
TDNUM Tax district number TDNUM CHAR 3 0
TDNME Name of tax district TDNME CHAR 30 0
PRMNO Permit number PRMNO CHAR 12 0
ECONR Employer contracted out number (ECON) ECONR CHAR 9 0
WTEXT Personnel number PERSNO NUMC 8 0
PERID Personnel ID Number PRDNI CHAR 20 0
ACTVE Employment Status STAT2 CHAR 1 0
ENAME Formatted Name of Employee or Applicant EMNAM CHAR 40 0
NACHN Last Name PAD_NACHN CHAR 40 0
VORNA First Name PAD_VORNA CHAR 40 0
MIDNM Middle Name PAD_MIDNM CHAR 40 0
GBDAT Date of Birth GBDAT DATS 8 0
GESCH Gender Key GESCH CHAR 1 0
NULL unknown
1 Male
2 Female
LINE0 HR-GB: Legal reporting Address line 1 P08_ADRS1 CHAR 80 0
LINE1 HR-GB: Legal reporting Address line 2 P08_ADRS2 CHAR 80 0
LINE2 HR-GB: Legal reporting Address line 3 P08_ADRS3 CHAR 80 0
LINE3 HR-GB: Legal reporting Address line 4 P08_ADRS4 CHAR 80 0
PSTLZ Postal Code PSTLZ_HR CHAR 10 0
LAND1 Country Key LAND1 CHAR 3 0
TXCOD Tax Code P08_TXCODE CHAR 8 0
M1W1I P60-GB: Week 1/Month 1Indicator P08_M1W1I CHAR 1 0
WEEK53 HR-GB: MM2 Week 53, 54, or 56 indicator P08_WKID CHAR 1 0
STARTD P60-GB: Start date of work P08_STARTD DATS 8 0
LEAVED P60-GB: Leaving date P08_LEAVED DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
ENDDA End Date ENDDA DATS 8 0
PENID HR-GB: MM2 Pension indicator P08_PENID CHAR 1 0
DIRID HR-GB: MM2 Director indicator P08_DIRID CHAR 1 0
TREFI HR-GB: MM2 Tax refund symbol P08_TXREF CHAR 1 0
SUREF HR-GB: MM2 Superannuation refund symbol P08_SUREF CHAR 1 0
TAXYR HR-GB: Tax year (for reports) P08_TAXYR NUMC 4 0
ERADD HR-GB: MM1 Employer's address P08_ERADD CHAR 60 0
LINE0_2 HR-GB: Legal reporting Address line 1 P08_ADRS1 CHAR 80 0
LINE1_2 HR-GB: Legal reporting Address line 2 P08_ADRS2 CHAR 80 0
LINE2_2 HR-GB: Legal reporting Address line 3 P08_ADRS3 CHAR 80 0
LINE3_2 HR-GB: Legal reporting Address line 4 P08_ADRS4 CHAR 80 0
PSTLZ_2 Postal Code PSTLZ_HR CHAR 10 0
EMAIL Checkbox XFELD CHAR 1 0
X Yes
NULL No
EMAIL_ID Communication: Long Identification/Number COMM_ID_LONG CHAR 241 0
NICAT NI category (GB) NICAT CHAR 2 0
CTOUT Contracted Out Flag P08_CTOUT CHAR 1 0
X Yes
NULL No
AMTTOLEL Niable pay up to LEL P08_TOLEL CURR 15 2
AMTLELEET Niable pay between LEL and ST P08_TOEET CURR 15 2
AMTEETERT Niable pay between ST and PT P08_TOERT CURR 15 2
AMTERTUEL Niable pay between UAP and UEL P08_TOUEL CURR 15 2
AMTFROMUEL Niable pay above UEL P08_FMUEL CURR 15 2
EENIC Employee NICs P08_NIC_EE CURR 15 2
ERNIC Employer NICs P08_NIC_ER CURR 15 2
EENIR Employee (primary) NI rebate P08_NIREE CURR 15 2
ERNIR Employer (secondary) NI rebate P08_NIRER CURR 15 2
EEERS HR-GB: Sum Employer's and employee's NIC (for P60) P08_EEERN CURR 15 2
NIREF HR-GB: MM2 NI refund symbol P08_NIREF CHAR 1 0
PSCON Pension scheme contracted out number P08_SCON CHAR 9 0
AMTERTUAP Niable pay between PT and UAP P08_TOUAP CURR 15 2
AMTLELPT Niable pay from LEL to PT P08_LTOPT CURR 15 2
WIDOR P60-GB: Widows and Orphan's fund P08_WIDOW CURR 15 2
P_EARN P60-GB: Previous Earnings P08_PEARN CURR 15 2
C_EARN P60-GB: Current Earnings P08_CEARN CURR 15 2
T_EARN P60-GB: Total Earnings P08_TEARN CURR 15 2
P_TAX P60-GB: Previous Tax P08_PTAX CURR 15 2
C_TAX P60-GB: Current Tax P08_CTAX CURR 15 2
T_TAX P60-GB: Total Tax P08_TTAX CURR 15 2
SLOAN P60-GB: Student loan P08_SLOAN CURR 15 2
TCRED P60-GB: Tax Credit P08_TCRED CURR 15 2
SSPBT P60-GB: Amount Statutory Sick Pay P08_SSPBT CURR 15 2
SMPBT P60-GB: Amount Statutory Maternity Pay P08_SMPBT CURR 15 2
SMPRC P35-GB: Recovered Statutory Maternity Pay P08_RCSMP CURR 15 2
NICRB P60-GB: Employee's NI Rebate P08_EENIR CURR 15 2
NIRTO P60-GB: Sum Employee and Employer NI Rebate P08_NIRTO CURR 15 2
SUPER P60-GB: Super annuation P08_SANNU CURR 15 2
TOGRP P60-GB: Total Gross Pay P08_TOGRP CURR 15 2
SPPBT P60-GB: Amount Statutory Paternity Pay P08_SPPBT CURR 15 2
RCSPP P35-GB: Recovered Statutory Paternity Pay P08_RCSPP CURR 15 2
SAPBT P60-GB: Amount Statutory Adoption Pay P08_SAPBT CURR 15 2
RCSAP P35-GB: Recovered Statutory Adoption Pay P08_RCSAP CURR 15 2
ASPBT P60-GB: Amount Additional Statutory Paternity Pay P08_ASPBT CURR 15 2
RCASP P35-GB: Recovered Additional Statutory Paternity Pay P08_RCASP CURR 15 2

P08_P60_CL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P08_P60_CL ABKRS SYST MANDT T549A Payroll areas MANDT
P08_P60_CL ABKRS P08_P60_CL ABKRS T549A Payroll areas ABKRS
P08_P60_CL BTRTL SYST MANDT T001P Personnel Area/Subarea MANDT
P08_P60_CL BTRTL P08_P60_CL WERKS T001P Personnel Area/Subarea WERKS
P08_P60_CL BTRTL P08_P60_CL BTRTL T001P Personnel Area/Subarea BTRTL
P08_P60_CL ORGEH SYST LANGU T527X Organizational Units SPRSL
P08_P60_CL ORGEH P08_P60_CL ORGEH T527X Organizational Units ORGEH
P08_P60_CL ORGEH * T527X Organizational Units ENDDA
P08_P60_CL ORGEH SYST MANDT T527X Organizational Units MANDT
P08_P60_CL PERSG SYST MANDT T501 Employee Group MANDT
P08_P60_CL PERSG P08_P60_CL PERSG T501 Employee Group PERSG
P08_P60_CL PERSK SYST MANDT T503K Employee subgroup MANDT
P08_P60_CL PERSK P08_P60_CL PERSK T503K Employee subgroup PERSK
P08_P60_CL WERKS P08_P60_CL WERKS T500P Personnel Areas PERSA
P08_P60_CL WERKS SYST MANDT T500P Personnel Areas MANDT