biuan SAP® BUSINESS ONE SDK
SQL Administration / Customized Menu
DTW Administration / System Initialization / Authorization
API OCMN
OCMN - Customized Menu Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
GUID KEY UNIQUEGUIDnVarChar
32
PRIMARYYes
NameMenu Item NamenVarChar
100
FatherMenu Parent GUIDnVarChar
32
TypeMenu TypeVarChar
S)
A)
C)
1
C
SubMenuSubmenu FlagVarChar
Y)
N)
1
N
MenuUID KEYMenu UIDnVarChar
50
UID_KEYNo
ObjectTypeTarget Object TypeInt
11
ObjectKeyTarget Object IDnVarChar
127
PermFolderPermission Folder IDInt
11
SortOrderSort OrderInt
11

SELECT statement

SELECT OCMN.GUID AS 'GUID', OCMN.Name AS 'Menu Item Name', OCMN.Father AS 'Menu Parent GUID', OCMN.Type AS 'Menu Type', OCMN.SubMenu AS 'Submenu Flag', OCMN.MenuUID AS 'Menu UID', OCMN.ObjectType AS 'Target Object Type', OCMN.ObjectKey AS 'Target Object ID', OCMN.PermFolder AS 'Permission Folder ID', OCMN.SortOrder AS 'Sort Order' FROM OCMN AS OCMN

Related information
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