biuan SAP® BUSINESS ONE SDK
DTW Administration / System Initialization / Authorization / User Permission Tree
API OUPT / / User Permission Tree
OUPT - User Autorization Tree Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEAuthorization IDnVarChar
20
PRIMARYYes
NameNamenVarChar
64
OptionsOptionsInt
0
1) Full/None
6
0
FathIdParent IDnVarChar
20OUPT
User Autorization Tree
VisOrderDisplay OrderInt
6
LevelsLevelsInt
6
1
IsItemIS ItemVarChar
Y) Yes
N) No
1
N
ActionActionInt
6
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OUPT.AbsId AS 'Authorization ID', OUPT.Name AS 'Name', OUPT.Options AS 'Options', OUPT.FathId AS 'Parent ID', OUPT.VisOrder AS 'Display Order', OUPT.Levels AS 'Levels', OUPT.IsItem AS 'IS Item', OUPT.Action AS 'Action', OUPT.UserSign AS 'User Signature' FROM OUPT AS OUPT

Related information


User Permission Tree UserPermissionTree Object· Table: OUPT
UserPermissionTree is a business object that represents the User Authorization Form. This object enables to manage user authorization for new forms (which their FormType property is defined in UserPermissionForms object). After adding a user...

User Autorization Tree OUPT 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates