biuan SAP® BUSINESS ONE SDK
API AHE2
AHE2 - Education Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee No.Int
11OHEM
Employees
PRIMARYYes
lineEducation: Information RowInt
6
fromDateEducation fromDate
8
toDateEducation toDate
8
typeEducation TypeInt
11OHED
Education Types
instituteInstitutenVarChar
100
majorMajornVarChar
50
diplomaDiplomanVarChar
50
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT AHE2.empID AS 'Employee No.', AHE2.line AS 'Education: Information Row', AHE2.fromDate AS 'Education from', AHE2.toDate AS 'Education to', AHE2.type AS 'Education Type', AHE2.institute AS 'Institute', AHE2.major AS 'Major', AHE2.diploma AS 'Diploma', AHE2.LogInstanc AS 'Log Instance' FROM AHE2 AS AHE2

Related information


Employees OHEM SQL Table

Education Types OHED 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