biuan SAP® BUSINESS ONE SDK
DTW Inventory / Inventory Transactions / Inventory Counting
API UGR1
UGR1 - Group Authorization Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
GroupLink KEY UNIQUEGroup LinkInt
6OUGR
Authorization Group
PRIMARYYes
PermIdAuthorization IDnVarChar
20OUPT
User Autorization Tree
PermissionAuthorizationVarChar
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



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