biuan SAP® BUSINESS ONE SDK
SQL Human Resources / Employees / Absence Information
DTW Human Resources / Employee Master Data / Absence Information
API Employees Info / Employee Absence Info
HEM1 - Absence Information Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee IDInt
11OHEM
Employees		PRIMARYYes
lineAbsence Information RowInt
6
fromDateAbsence fromDate
8
toDateAbsence toDate
8
reasonReasonnVarChar
20
approvedByApproved BynVarChar
20
cnfrmrNumConfirmer NumberInt
11OHEM
Employees
LogInstancLog InstanceInt
11
0

SELECT statement

SELECT HEM1.empID AS 'Employee ID', HEM1.line AS 'Absence Information Row', HEM1.fromDate AS 'Absence from', HEM1.toDate AS 'Absence to', HEM1.reason AS 'Reason', HEM1.approvedBy AS 'Approved By', HEM1.cnfrmrNum AS 'Confirmer Number', HEM1.LogInstanc AS 'Log Instance' FROM HEM1 AS HEM1

Related information


Employee Absence Info EmployeeAbsenceInfo Object· Table: HEM1
EmployeeAbsenceInfo is a child object of the EmployeesInfo object and represents the employee absence information. Source table: HEM1.
   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