biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Payment Terms Types
API CDPM
CDPM - Dynamic Permission Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PermId KEY UNIQUEPermission IDInt
11
PRIMARYYes
NameNamenVarChar
64
ObjectTypeObject TypeInt
11
ObjectKeyObject IDnVarChar
127
FatherParentInt
11
PermOptionPermission OptionInt
0
1) Full/None
2) Full/None/Saved Queries
6
0
SystemSystem FlagVarChar
Y) Yes
N) No
1
N
HiddenHiddenVarChar
Y) Yes
N) No
1
N
SortOrderSort OrderInt
11

SELECT statement

SELECT CDPM.PermId AS 'Permission ID', CDPM.Name AS 'Name', CDPM.ObjectType AS 'Object Type', CDPM.ObjectKey AS 'Object ID', CDPM.Father AS 'Parent', CDPM.PermOption AS 'Permission Option', CDPM.System AS 'System Flag', CDPM.Hidden AS 'Hidden', CDPM.SortOrder AS 'Sort Order' FROM CDPM AS CDPM

Related information


CDPM SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates