SMENUSER SAP (File for the User Menu) Table details
Dictionary Type: Table
Description: File for the User Menu
Description: File for the User Menu
Table field list including key, data, relationships and ABAP select examples
SMENUSER is a standard SAP Table which is used to store File for the User Menu data and is available within R/3 SAP systems depending on the version and release level.
The SMENUSER table consists of various fields, each holding specific information or linking keys about File for the User Menu data available in SAP. These include ID (Name of the user, position, etc.), PARENT_ID (Counter for menu ID), OBJECT_ID (Counter for menu ID), MENU_LEVEL (Level in the menu).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP SMENUSER table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
TYP | User type (user, position,...) | MENU_TYPE | CHAR | 2 | CHAR2 | ||||
ID | Name of the user, position, etc. | MENU_ID | CHAR | 12 | CHAR12 | ||||
PARENT_ID | Counter for menu ID | MENU_NUM_5 | NUMC | 5 | NUM05 | ||||
OBJECT_ID | Counter for menu ID | MENU_NUM_5 | NUMC | 5 | NUM05 | ||||
MENU_LEVEL | Level in the menu | MENU_NUM_2 | NUMC | 2 | NUM02 | ||||
REPORTTYPE | Report type | REPORTTYPE | CHAR | 2 | Assigned to domain | CHAR2REP | REPORT_TYPE | ||
REPORT | ABAP Program Name | PROGNAME | CHAR | 40 | PROGNAME | ||||
VARIANT | Variant Name | RALDB_VARI | CHAR | 14 | RALDB_VARI | ||||
ATTRIBUTES | Attributes of the menu | MENU_ATTR | CHAR | 10 | CHAR10 |
Key field | Non-key field |
How do I retrieve data from SAP table SMENUSER using ABAP code
The following ABAP code Example will allow you to do a basic selection on SMENUSER to SELECT all data from the tableDATA: WA_SMENUSER TYPE SMENUSER.
SELECT SINGLE *
FROM SMENUSER
INTO CORRESPONDING FIELDS OF WA_SMENUSER
WHERE...
How to access SAP table SMENUSER
Within an ECC or HANA version of SAP you can also view further information about SMENUSER and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects