|
|
DTW Inventory / Inventory Transactions / Inventory Counting
API UGR1
UGR1 - Group Authorization Table
Authorization Group OUGR SQL Table
User Autorization Tree OUPT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | GroupLink KEY UNIQUE | Group Link | Int | 6 | OUGR Authorization Group | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PermId | Authorization ID | nVarChar | 20 | OUPT User Autorization Tree | ||||
| Permission | Authorization | VarChar | V) Various F) Full R) Read Only N) None U) Undefined Type | 1 | N |
Table relationship map
SELECT statement
SELECT
UGR1.GroupLink AS 'Group Link',
UGR1.PermId AS 'Authorization ID',
UGR1.Permission AS 'Authorization'
FROM UGR1 AS UGR1
Related information
Authorization Group OUGR SQL Table
User Autorization Tree OUPT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
