1. Home
  2. Resources
  3. SAP Tables
  4. ESS_EMP - ESS Employee Header Data

SAP Table ESS_EMP

ESS Employee Header Data

ESS_EMP (ESS Employee Header Data) 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 ESS_EMP to other SAP tables.

ESS_EMP table fields

Field Data element Checktable Datatype Length Decimals
EMPLOYEENUMBER Personnel Number PERNR_D NUMC 8 0
COUNTRYGROUPING Country Grouping MOLGA CHAR 2 0
NAME Formatted Name of Employee or Applicant EMNAM CHAR 40 0
BUSINESSAREA Business Area GSBER CHAR 4 0
NAMEOFBUSAREA Business area description GTEXT CHAR 30 0
PERSONNELAREA Personnel Area PERSA CHAR 4 0
NAMEOFPERSAREA Personnel Area Text PBTXT CHAR 30 0
PERSSUBAREA Personnel Subarea BTRTL CHAR 4 0
NAMEOFPERSSUBAREA Personnel Subarea Text BTRTX CHAR 15 0
EMPLOYEEGROUP Employee Group PERSG CHAR 1 0
NAMEOFEMPGROUP Name of Employee Group PGTXT CHAR 20 0
EMPLOYEESUBGROUP Employee Subgroup PERSK CHAR 2 0
NAMEOFEMPSUBGROUP Name of Employee Subgroup PKTXT CHAR 20 0
ORGUNIT Organizational Unit ORGEH NUMC 8 0
NAMEOFORGUNIT Position (Short Text) PLSTX CHAR 25 0
POSITION Position PLANS NUMC 8 0
NAMEOFPOSITION Position (Short Text) PLSTX CHAR 25 0
COSTCENTER Cost Center KOSTL CHAR 10 0
NAMEOFCOSTCENTER Cost Center Text KOSTX CHAR 30 0
ADMINGROUP Administrator Group SBMOD CHAR 4 0
PAYROLLADMIN Payroll Administrator SACHA CHAR 3 0
PERSONNELLADMIN Administrator for HR Master Data SACHP CHAR 3 0
TIMEADMIN Administrator for Time Recording SACHZ CHAR 3 0
CONTROLLINGAREA Controlling Area KOKRS CHAR 4 0
EMPLOYMENTSTATUS Employment Status STAT2 CHAR 1 0
PAYROLLAREA Payroll Area ABKRS CHAR 2 0
NAMEOFPAYROLLAREA Payroll Area Text ABKTX CHAR 20 0
PAYROLLSTATUS Status of Control Record VWSTA NUMC 1 0
0 Created new
1 Released for payroll
2 Payroll correction
3 Exit payroll
4 Check payroll results
9 Deleted
COMPANYCODE Company Code BUKRS CHAR 4 0
NAMEOFCOMPANYCODE Name of Company Code or Company BUTXT CHAR 25 0
USERLOGONLANGUAGE Logon Language XULANGU LANG 1 0
USERDATEFORMAT Date format XUDATFM CHAR 1 0
1 DD.MM.YYYY
2 MM/DD/YYYY
3 MM-DD-YYYY
4 YYYY.MM.DD
5 YYYY/MM/DD
6 YYYY-MM-DD
7 GYY.MM.DD (Japanese Date)
8 GYY/MM/DD (Japanese Date)
9 GYY-MM-DD (Japanese Date)
A YYYY/MM/DD (Islamic Date 1)
B YYYY/MM/DD (Islamic Date 2)
C YYYY/MM/DD (Iranian Date)
USERDECIMALFORMAT Decimal Format XUDCPFM CHAR 1 0
NULL 1.234.567,89
X 1,234,567.89
Y 1 234 567,89
CURRENCY Currency Key WAERS CUKY 5 0
CURRENCYDECIMALS Number of decimal places CURRDEC INT1 3 0
SAPRELEASE Release of SAP System SYSAPRL CHAR 4 0
ACCOUNTEDTO Accounted to LABRD DATS 8 0
FIRSTNAME First Name PAD_VORNA CHAR 40 0
LASTNAME Last Name PAD_NACHN CHAR 40 0
FIRSTNAMEROMAJI First Name (Romaji) P22J_PFNMR CHAR 40 0
LASTNAMEROMAJI Last Name (Romaji) P22J_PLNMR CHAR 40 0
BIRTHDATE Date of Birth GBDAT DATS 8 0