biuan SAP® BUSINESS ONE SDK
DTW Human Resources / Employee Master Data / Education
API Employees Info / Employee Education Info
HEM2 - Education Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee No.Int
11OHEM
Employees
PRIMARYYes
lineEducation Information RowInt
6
fromDateEducation fromDate
8
toDateEducation toDate
8
typeEducation TypeInt
11OHED
Education Types
instituteInstitutenVarChar
100
majorMajornVarChar
50
diplomaDiplomanVarChar
50
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT HEM2.empID AS 'Employee No.', HEM2.line AS 'Education Information Row', HEM2.fromDate AS 'Education from', HEM2.toDate AS 'Education to', HEM2.type AS 'Education Type', HEM2.institute AS 'Institute', HEM2.major AS 'Major', HEM2.diploma AS 'Diploma', HEM2.LogInstanc AS 'Log Instance' FROM HEM2 AS HEM2

Related information


Employee Education Info EmployeeEducationInfo Object· Table: HEM2
EmployeeEducationInfo is a child object of the EmployeesInfo object and represents the employee education information. Source table: HEM2.
   Parent: Employees Info EmployeesInfo Object· Table: OHEM
Employees OHEM SQL Table

Education Types OHED SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates