|
|
DTW Human Resources / Employee Master Data / Employee Roles
API Employees Info / Employee Roles Info
HEM6 - Employee Roles Table
Employee Roles Info EmployeeRolesInfo Object· Table: HEM6
Parent: Employees Info EmployeesInfo Object· Table: OHEM
Employees OHEM SQL Table
Employee Types OHTY SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | empID KEY UNIQUE | Employee No. | Int | 11 | OHEM Employees | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| line | Employee Role Row | Int | 6 | |||||
| roleID | Role ID | Int | 11 | OHTY Employee Types | ||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
HEM6.empID AS 'Employee No.',
HEM6.line AS 'Employee Role Row',
HEM6.roleID AS 'Role ID',
HEM6.LogInstanc AS 'Log Instance'
FROM HEM6 AS HEM6
Related information
Employee Roles Info EmployeeRolesInfo Object· Table: HEM6
A child object of the EmployeesInfo object that represents the employee roles, for example, technician, sales employee and purchasing.
Source table: HEM6.
Parent: Employees Info EmployeesInfo Object· Table: OHEM Employees OHEM SQL Table
Employee Types OHTY SQL Table
EmployeesInfo
Object
EmployeeRolesInfo
Method
Property
EmployeeID
DTW DB
LineNum
DTW DB
RoleID
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates