|
|
DTW Others / MultiLanguageTranslations / My Menu Items
API User Menu Items / User Menu Item
CUMI - My Menu Items Table
User Menu Item UserMenuItem Object· Table: CUMI
Parent: User Menu Items UserMenuItems Collection· Table: CUMI
User Menu Items UserMenuItems Collection· Table: CUMI Parent: User Menu Item UserMenuItem Object· Table: CUMI
User Menu Params UserMenuParams Object· Table: CUMI Parent: User Menu Service UserMenuService Service· Table: CUMI
User Menu Service UserMenuService Service· Table: CUMI
Object Settings - History ADP1 SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Id_ | Folder Key | Int | 11 | 0 |
|---|---|---|---|---|---|---|---|---|
| Name_ | Menu Item Name | nVarChar | 100 | |||||
| UserSign KEY | User Signature | Int | 6 | OUSR Users | DETAIL | No | ||
| FatherId | Parent Key | Int | 11 | -1 | ||||
| SortNum | Sort Number | Int | 11 | |||||
| Type_ | Menu Item Type | VarChar | F) Form Q) Query R) Report L) Link -) Folder | 1 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | ||||
| Key_ | Internal ID | nVarChar | 50 | |||||
| FormMenuId | Form Menu ID | Int | 11 | |||||
| FormNum | Form No. | Int | 11 | |||||
| RepPath | Report Path | Text | 16 | |||||
| Levels | Item Level | Int | 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...
Object Settings - History ADP1 SQL Table
Users OUSR SQL Table
UserMenuItems
Object
UserMenuItem
Collection
UserMenuItems CUMI
Enumeration
Method
Property
LinkedObjKey
DB
Name
DB
Position
DB
ReportPath
DB
Type
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
