| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Human Resources / Employee Master Data / Absence Information API Employees Info / Employee Absence Info | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HEM1 - Absence Information Table SBO SQL database table details
SELECT statementSELECT
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 informationEmployee Absence Info EmployeeAbsenceInfo Object· Table: HEM1 EmployeeAbsenceInfo is a child object of the EmployeesInfo object and represents the employee absence information.
Source table: HEM1. ![]() 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. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |