biuan SAP® BUSINESS ONE SDK
API USR7
USR7 - Group User Association Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
UserId KEY UNIQUEUser IDInt
6OUSR
Users
PRIMARYYes
GroupIdGroup IDInt
6OUGR
Authorization Group

Table relationship map

SELECT statement

SELECT USR7.UserId AS 'User ID', USR7.GroupId AS 'Group ID' FROM USR7 AS USR7

Related information


Authorization Group OUGR SQL Table

Users OUSR 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