|
|
DTW Human Resources / Employee Master Data / Absence Information
API Employees Info / Employee Absence Info
HEM1 - Absence Information Table
Employee Absence Info EmployeeAbsenceInfo Object· Table: HEM1
Parent: Employees Info EmployeesInfo Object· Table: OHEM
Employees OHEM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | empID KEY UNIQUE | Employee ID | Int | 11 | OHEM Employees | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| line | Absence Information Row | Int | 6 | |||||
| fromDate | Absence from | Date | 8 | |||||
| toDate | Absence to | Date | 8 | |||||
| reason | Reason | nVarChar | 20 | |||||
| approvedBy | Approved By | nVarChar | 20 | |||||
| cnfrmrNum | Confirmer Number | Int | 11 | OHEM Employees | ||||
| LogInstanc | Log Instance | Int | 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
EmployeesInfo
Object
EmployeeAbsenceInfo
Method
Property
ApprovedBy
DTW DB
ConfirmerNumber
DTW DB
EmployeeID
DTW DB
FromDate
DTW DB
LineNum
DTW DB
Reason
DTW DB
ToDate
DTW DB
Collection
Enumeration
Method
Object
Message OALR
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
