biuan SAP® BUSINESS ONE SDK
API AHE6
AHE6 - 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 AHE6.empID AS 'Employee No.', AHE6.line AS 'Employee Role Row', AHE6.roleID AS 'Role ID', AHE6.LogInstanc AS 'Log Instance' FROM AHE6 AS AHE6

Related information


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