|
|
API HEM5
HEM5 - Employee Data Ownership Authorization Table
Employees OHEM 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 |
|---|---|---|---|---|---|---|---|---|
| Object | The Object Number | nVarChar | 20 | |||||
| Peer | Peer Authorization | VarChar | F) Full R) Read Only N) None U) Undefined Type | 1 | N | |||
| Manager | Manager Authorization | VarChar | F) Full R) Read Only N) None U) Undefined Type | 1 | N | |||
| Subord | Subordinate Authorization | VarChar | F) Full R) Read Only N) None U) Undefined Type | 1 | N | |||
| Dept | Department Authorization | VarChar | F) Full R) Read Only N) None U) Undefined Type | 1 | N | |||
| Branch | Branch Authorization | VarChar | F) Full R) Read Only N) None U) Undefined Type | 1 | N | |||
| Team | Team Authorization | VarChar | F) Full R) Read Only N) None U) Undefined Type | 1 | N | |||
| AC | Cache Access Counter | Int | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates