|
|
API AHE6
AHE6 - Employee Roles Table
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
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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
