biuan SAP® BUSINESS ONE SDK
SQL Human Resources / Employees / Employee Position
DTW Human Resources / Employee Master Data / Employee Position
API Employees Info / Position
OHPS - Employee Position Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
posID KEY UNIQUEItem IDInt
11
PRIMARYYes
name KEY UNIQUEPosition NamenVarChar
20
NAMEYes
descriptioDescriptionText
16
LocFieldsActivate Localization FieldsVarChar
Y)
N)
1
N

SELECT statement

SELECT OHPS.posID AS 'Item ID', OHPS.name AS 'Position Name', OHPS.descriptio AS 'Description', OHPS.LocFields AS 'Activate Localization Fields' FROM OHPS AS OHPS

Related information


Position Position Property· Table: OHPS
Sets or returns a value that specifies the employee position. This property This is a foreign key to OHPS table, which is not exposed through the DI API. Field name: Position.
· Table: OHEM    Parent: Employees Info EmployeesInfo Object· Table: OHEM
OHPS SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates