biuan SAP® BUSINESS ONE SDK
DTW Human Resources / Teams / Team Members
API Teams / Team Members
HTM1 - Team Members Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
teamID KEY UNIQUETeam IDInt
11OHTM
Employee Teams
PRIMARYYes
lineRowInt
6
empIDEmployee IDInt
11OHEM
Employees
roleRole in TeamVarChar
L) Leader
M) Member
1
M

Table relationship map

SELECT statement

SELECT HTM1.teamID AS 'Team ID', HTM1.line AS 'Row', HTM1.empID AS 'Employee ID', HTM1.role AS 'Role in Team' FROM HTM1 AS HTM1

Related information


Team Members TeamMembers Object· Table: HTM1
TeamMembers is a child object of the Teams object that represents the membership role in a team of an employee. An employee can be a Member or a Leader of more than one team. Source table: HTM1.
   Parent: Teams Teams Object· Table: OHTM
Employees OHEM SQL Table

Employee Teams OHTM 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