|
|
API AHE4
AHE4 - Previous Employment 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 |
|---|---|---|---|---|---|---|---|---|
| line | Previous Employment Row | Int | 6 | |||||
| fromDate | Employment from | Date | 8 | |||||
| toDate | Employment to | Date | 8 | |||||
| employer | Employer | nVarChar | 50 | |||||
| position | Position | nVarChar | 50 | |||||
| remarks | Previous Employment | Text | 16 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
SELECT statement
SELECT
AHE4.empID AS 'Employee No.',
AHE4.line AS 'Previous Employment Row',
AHE4.fromDate AS 'Employment from',
AHE4.toDate AS 'Employment to',
AHE4.employer AS 'Employer',
AHE4.position AS 'Position',
AHE4.remarks AS 'Previous Employment',
AHE4.LogInstanc AS 'Log Instance'
FROM AHE4 AS AHE4
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
