biuan SAP® BUSINESS ONE SDK
DTW Administration / System Initialization / Authorization / User Permission Tree / User Authorization Tree - Extended Permission
API User Permission Tree / User Permission Forms
UPT1 - User Authorization Tree - Extended Permission Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PermId KEY UNIQUEAuthorization IDnVarChar
20OUPT
User Autorization Tree
PRIMARYYes
FormId KEYForm IDnVarChar
20
FORM_IDNo
VisOrderDisplay OrderInt
6

SELECT statement

SELECT UPT1.PermId AS 'Authorization ID', UPT1.FormId AS 'Form ID', UPT1.VisOrder AS 'Display Order' FROM UPT1 AS UPT1

Related information


User Permission Forms UserPermissionForms Object· Table: UPT1
UserPermissionForms is a child object of UserPermissionTree object and enables to add a user permission to a collection of forms. Source table: UPT1.
   Parent: User Permission Tree UserPermissionTree Object· Table: OUPT
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