biuan SAP® BUSINESS ONE SDK
DTW Others / MultiLanguageTranslations / My Menu Items
API User Menu Items / User Menu Item
CUMI - My Menu Items Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Id_Folder KeyInt
11
0
Name_Menu Item NamenVarChar
100
UserSign KEYUser SignatureInt
6OUSR
Users
DETAILNo
FatherIdParent KeyInt
11
-1
SortNumSort NumberInt
11
Type_Menu Item TypeVarChar
F) Form
Q) Query
R) Report
L) Link
-) Folder
1
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
Key_Internal IDnVarChar
50
FormMenuIdForm Menu IDInt
11
FormNumForm No.Int
11
RepPathReport PathText
16
LevelsItem LevelInt
6
1

Table relationship map

SELECT statement

SELECT CUMI.Id_ AS 'Folder Key', CUMI.Name_ AS 'Menu Item Name', CUMI.UserSign AS 'User Signature', CUMI.FatherId AS 'Parent Key', CUMI.SortNum AS 'Sort Number', CUMI.Type_ AS 'Menu Item Type', CUMI.ObjType AS 'Object Type', CUMI.Key_ AS 'Internal ID', CUMI.FormMenuId AS 'Form Menu ID', CUMI.FormNum AS 'Form No.', CUMI.RepPath AS 'Report Path', CUMI.Levels AS 'Item Level' FROM CUMI AS CUMI

Related information


User Menu Item UserMenuItem Object· Table: CUMI
UserMenuItem is a Data structure related to the UserMenuService. Source table: CUMI.
   Parent: User Menu Items UserMenuItems Collection· Table: CUMI

User Menu Items UserMenuItems Collection· Table: CUMI
UserMenuItems is a Data Collection of UserMenuItem data structures. Source table: CUMI.
   Parent: User Menu Item UserMenuItem Object· Table: CUMI

User Menu Params UserMenuParams Object· Table: CUMI
The UserMenuParams specifies the identification key (UserID) for which the UserMenuService is related. Source table: CUMI.
   Parent: User Menu Service UserMenuService Service· Table: CUMI

User Menu Service UserMenuService Service· Table: CUMI
UserMenuService manages the user menu. Source table: CUMI. The service maintains a collection of user menus, each identified by a specific value of UserMenuParams. It enables the user to: Get current user menu definition. Get any user menu...

Object Settings - History ADP1 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates