biuan SAP® BUSINESS ONE SDK
DTW Human Resources / Employee Master Data / Employee Roles
API Employees Info / Employee Roles Info
HEM6 - Employee Roles Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee No.Int
11OHEM
Employees
PRIMARYYes
lineEmployee Role RowInt
6
roleIDRole IDInt
11OHTY
Employee Types
LogInstancLog InstanceInt
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



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