TTREV_ROLE SAP (Version Management: Comparison Results) Table details
Dictionary Type: Table
Description: Version Management: Comparison Results
Description: Version Management: Comparison Results
Table field list including key, data, relationships and ABAP select examples
TTREV_ROLE is a standard SAP Table which is used to store Version Management: Comparison Results data and is available within R/3 SAP systems depending on the version and release level.
The TTREV_ROLE table consists of various fields, each holding specific information or linking keys about Version Management: Comparison Results data available in SAP. These include LEFT_RIGHT (Hierarchy Tool: Flag - Left or Right Structure), OBJECT_ID (Counter for Menu ID), PARENT_ID (Counter for Menu ID), FOLDER (Customized ('C') or standard menu ('S') flag).. 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: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP TTREV_ROLE 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 |
| COMPARE_ID | Comparison ID | HIER_CPID | CHAR | 32 | SYCHAR32 | ||||
| LEFT_RIGHT | Hierarchy Tool: Flag - Left or Right Structure | HIER_LERI | CHAR | 1 | HIER_LERI | ||||
| OBJECT_ID | Counter for Menu ID | MENU_NUM_8 | NUMC | 8 | NUM08 | ||||
| PARENT_ID | Counter for Menu ID | MENU_NUM_8 | NUMC | 8 | NUM08 | ||||
| FOLDER | Customized ('C') or standard menu ('S') flag | MENU_FLAG | CHAR | 1 | CHAR1 | ||||
| MENU_LEVEL | Level in the menu | MENU_NUM_2 | NUMC | 2 | NUM02 | ||||
| SORT_ORDER | Counter for Menu ID | MENU_NUM_8 | NUMC | 8 | NUM08 | ||||
| STRING1 | URL for the SAP Portal | AGR_URL | CHAR | 255 | AGR3_HTML | ||||
| STRING2 | URL for the SAP Portal | AGR_URL | CHAR | 255 | AGR3_HTML | ||||
| SPRAS | Language of menu texts | MENU_SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
| TEXT | Menu entry text | SSM_TITLE | CHAR | 80 | TEXT80 | ||||
| DIFF_FLAG | Hierarchy Tool: Comparisons - Difference Type | HIER_DIFF | CHAR | 1 | HIER_DIFF | ||||
| GUID_ID | Unique ID - 32 characters | HIER_GUID | CHAR | 32 | SYCHAR32 | ||||
| GUID_PARNT | Unique ID - 32 characters | HIER_GUID | CHAR | 32 | SYCHAR32 |
| Key field | Non-key field |
How do I retrieve data from SAP table TTREV_ROLE using ABAP code
The following ABAP code Example will allow you to do a basic selection on TTREV_ROLE to SELECT all data from the tableDATA: WA_TTREV_ROLE TYPE TTREV_ROLE.
SELECT SINGLE *
FROM TTREV_ROLE
INTO CORRESPONDING FIELDS OF WA_TTREV_ROLE
WHERE...
How to access SAP table TTREV_ROLE
Within an ECC or HANA version of SAP you can also view further information about TTREV_ROLE 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