biuan SAP® BUSINESS ONE SDK
SQL Human Resources / Employee Data Ownership Authorization
API HEM5
HEM5 - Employee Data Ownership Authorization Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee No.Int
11OHEM
Employees		PRIMARYYes
ObjectThe Object NumbernVarChar
20
PeerPeer AuthorizationVarChar
F) Full
R) Read Only
N) None
U) Undefined Type
1
N
ManagerManager AuthorizationVarChar
F) Full
R) Read Only
N) None
U) Undefined Type
1
N
SubordSubordinate AuthorizationVarChar
F) Full
R) Read Only
N) None
U) Undefined Type
1
N
DeptDepartment AuthorizationVarChar
F) Full
R) Read Only
N) None
U) Undefined Type
1
N
BranchBranch AuthorizationVarChar
F) Full
R) Read Only
N) None
U) Undefined Type
1
N
TeamTeam AuthorizationVarChar
F) Full
R) Read Only
N) None
U) Undefined Type
1
N
ACCache Access CounterInt
11
0

SELECT statement

SELECT HEM5.empID AS 'Employee No.', HEM5.Object AS 'The Object Number', HEM5.Peer AS 'Peer Authorization', HEM5.Manager AS 'Manager Authorization', HEM5.Subord AS 'Subordinate Authorization', HEM5.Dept AS 'Department Authorization', HEM5.Branch AS 'Branch Authorization', HEM5.Team AS 'Team Authorization', HEM5.AC AS 'Cache Access Counter' FROM HEM5 AS HEM5

Related information


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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates