biuan SAP® BUSINESS ONE SDK
DTW Human Resources / Employee Master Data / Previous Employment
API Employees Info / Employee Prev Empoyment Info
HEM4 - Previous Employment Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee No.Int
11OHEM
Employees
PRIMARYYes
linePrevious Employment RowInt
6
fromDateEmployment fromDate
8
toDateEmployment toDate
8
employerEmployernVarChar
50
positionPositionnVarChar
50
remarksPrevious EmploymentText
16
LogInstancLog InstanceInt
11
0

SELECT statement

SELECT HEM4.empID AS 'Employee No.', HEM4.line AS 'Previous Employment Row', HEM4.fromDate AS 'Employment from', HEM4.toDate AS 'Employment to', HEM4.employer AS 'Employer', HEM4.position AS 'Position', HEM4.remarks AS 'Previous Employment', HEM4.LogInstanc AS 'Log Instance' FROM HEM4 AS HEM4

Related information


Employee Prev Empoyment Info EmployeePrevEmpoymentInfo Object· Table: HEM4
EmployeePrevEmploymentInfo is a child object of the EmployeesInfo object and represents the employee previous employment information. Source table: HEM4.
   Parent: Employees Info EmployeesInfo Object· Table: OHEM
Employees OHEM 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