|
|
SQL Others / Group User Association
API USR7
USR7 - Group User Association Table
Authorization Group OUGR SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | UserId KEY UNIQUE | User ID | Int | 6 | OUSR Users | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| GroupId | Group ID | Int | 6 | OUGR 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
