biuan SAP® BUSINESS ONE SDK
DTW Human Resources / Employee Master Data / Employee Reviews
API Employees Info / Employee Reviews Info
HEM3 - Employee Reviews Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee No.Int
11OHEM
Employees
PRIMARYYes
lineEmployee Review RowInt
6
dateEmployee Review DateDate
8
reviewDescReview DescriptionnVarChar
100
managerManagerInt
11OHEM
Employees
gradeGradenVarChar
50
remarksReviewsText
16
LogInstancLog InstanceInt
11
0

SELECT statement

SELECT HEM3.empID AS 'Employee No.', HEM3.line AS 'Employee Review Row', HEM3.date AS 'Employee Review Date', HEM3.reviewDesc AS 'Review Description', HEM3.manager AS 'Manager', HEM3.grade AS 'Grade', HEM3.remarks AS 'Reviews', HEM3.LogInstanc AS 'Log Instance' FROM HEM3 AS HEM3

Related information


Employee Reviews Info EmployeeReviewsInfo Object· Table: HEM3
EmployeeReviewsInfo is a child object of the EmployeesInfo object and represents the employee reviews information. Source table: HEM3.
   Parent: Employees Info EmployeesInfo Object· Table: OHEM
Employees OHEM 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