AHE2 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Human Resources /

Education

API AHE2

AHE2 - Education Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
empID ^KEY ^UNIQUE	Employee No.	Int	11	OHEM Employees		PRIMARY	Yes
line	Education: Information Row	Int	6
fromDate	Education from	Date	8
toDate	Education to	Date	8
type	Education Type	Int	11	OHED Education Types
institute	Institute	nVarChar	100
major	Major	nVarChar	50
diploma	Diploma	nVarChar	50
LogInstanc	Log Instance	Int	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

OHEM SQL Table

OHED SQL Table

biuan SAP® BUSINESS ONE

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