TTREV_NODE SAP (Hierarchy Tool: Structure Versioning Node Table) Table details

Dictionary Type: Table
Description: Hierarchy Tool: Structure Versioning Node Table




ABAP Code to SELECT data from TTREV_NODE
Related tables to TTREV_NODE
Access table TTREV_NODE




Table field list including key, data, relationships and ABAP select examples

TTREV_NODE is a standard SAP Table which is used to store Hierarchy Tool: Structure Versioning Node Table data and is available within R/3 SAP systems depending on the version and release level.

The TTREV_NODE table consists of various fields, each holding specific information or linking keys about Hierarchy Tool: Structure Versioning Node Table data available in SAP. These include NODE_COUNT (Hierarchy Tool: Counter of a Versioned Node), NODE_ID (Unique ID - 32 characters), NODE_TYPE (Valid Node Types in Structure Repository), NODE_LEVEL (Node level).. 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 areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP TTREV_NODE 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
VERSIONVersion ID HIER_VERSCHAR32SYCHAR32
NODE_COUNTHierarchy Tool: Counter of a Versioned Node HIER_VERCTNUMC8NUMC08
NODE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
NODE_TYPEValid Node Types in Structure Repository HIER_NODETCHAR4TNODEHHIER_NODET
NODE_LEVELNode level SEU_LEVELNUMC2SEU_LEVEL
EXTENSIONStructure enhancement ID HIER_NAMESCHAR15Assigned to domainHIER_NAMES
PARENT_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
BROTHER_IDID of predecessor on same level HIER_BR_IDCHAR40CHAR40
TREE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
REFNODE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
REFTREE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
LOG_REFFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
LOCAL_FLAGLocal use: Must not be referenced HIER_LOCALCHAR1HIER_YESNO
VALID_F_RRelease of SAP System SYSAPRLCHAR4SYCHAR04
VALID_T_RRelease of SAP System SYSAPRLCHAR4SYCHAR04
VALID_F_DSystem Date SYDATUMDATS8SYDATS
VALID_T_DSystem Date SYDATUMDATS8SYDATS
FORCE_PLUSFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
W_SUBNODESFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
FILTER_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
LOST_EXTFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
LOST_NODEFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
APPL_FLAG1Flag: Use by application only HIER_AFLAGCHAR1CHAR1
APPL_FLAG2Flag: Use by application only HIER_AFLAGCHAR1CHAR1
APPL_FLAG3Flag: Use by application only HIER_AFLAGCHAR1CHAR1
FUSERCreated by HIER_FUSERCHAR12HIER_USER
FDATECreated on HIER_FDATEDATS8SYDATS
FTIMECreated at HIER_FTIMETIMS6SYTIME
FRELEASERelease of SAP System SYSAPRLCHAR4SYCHAR04
LUSERLast changed by HIER_LUSERCHAR12HIER_USER
LDATELast Changed On HIER_LDATEDATS8SYDATS
LTIMETime of Last Change HIER_LTIMETIMS6SYTIME
LRELEASERelease of SAP System SYSAPRLCHAR4SYCHAR04
NODE_KEYTree Control: Node Key TV_NODEKEYCHAR12TM_CHAR12
PARENT_KEYTree Control: Node Key TV_NODEKEYCHAR12TM_CHAR12
IS_CUTFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
CHECKBOXSTStatus of a checkbox in a tree structure; values: A, I, P HIER_BOXSTCHAR1HIER_BOXST
MANUAL_SETFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
NOFRONTENDFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
NO_DISPLAYFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
HIDDEN_FLFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
DOUBLE_FLFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
DEFAULTFLGFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
COPY_NODEUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
COPY_TREEUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
COPNODFRSTUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
COPTREFRSTGUID for Structure HIER_TREEGCHAR32SYCHAR32S_TREE_ID
COMPONENTTechnical Description of Logical Components SYSDLVUNITCHAR30Assigned to domainSYSDLVUNIT
SYSTEMINSTCode for an Assigned System Landscape in Project SYSTEMINSTCHAR20Assigned to domainSYSTEMINST
COMPRELFRSAP Release SAPRELEASECHAR10CHAR10
COMPRELTOSAP Release SAPRELEASECHAR10CHAR10
NODRAGDROPFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
PRDVERSFRComponent Release SBORPV_FRMCHAR20SBORPVNR
PRDVERSTOComponent Release SBORPV_TOCHAR20SBORPVNR

Key field Non-key field



How do I retrieve data from SAP table TTREV_NODE using ABAP code

The following ABAP code Example will allow you to do a basic selection on TTREV_NODE to SELECT all data from the table
DATA: WA_TTREV_NODE TYPE TTREV_NODE.

SELECT SINGLE *
FROM TTREV_NODE
INTO CORRESPONDING FIELDS OF WA_TTREV_NODE
WHERE...

How to access SAP table TTREV_NODE

Within an ECC or HANA version of SAP you can also view further information about TTREV_NODE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!