TNODE01 SAP (Node Table for General Structure Storage) Table details

Dictionary Type: Table
Description: Node Table for General Structure Storage




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




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

TNODE01 is a standard SAP Table which is used to store Node Table for General Structure Storage data and is available within R/3 SAP systems depending on the version and release level.

The TNODE01 table consists of various fields, each holding specific information or linking keys about Node Table for General Structure Storage data available in SAP. These include TREE_ID (Unique ID - 32 characters), EXTENSION (Structure enhancement ID), NODE_ID (Unique ID - 32 characters), EXT_KEY (External key).. 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: S - System table, maint. only by SAP, change = modification
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

Text table = TNODE01T

Text table = TNODE01T

Text table = TNODE01T

Text table = TNODE01T


SAP TNODE01 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
TREE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
EXTENSIONStructure enhancement ID HIER_NAMESCHAR15Assigned to domainHIER_NAMES
NODE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
EXT_KEYExternal key HIER_TREECHAR12HIER_TREE
PARENT_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
BROTHER_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
REFNODE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
REFTREE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
NODE_TYPEValid Node Types in Structure Repository HIER_NODETCHAR4TNODEHHIER_NODET
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
W_SUBNODESFlag 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
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
DEFAULTFLGFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
PRDVERSFRComponent Release SBORPV_FRMCHAR20SBORPVNR
PRDVERSTOComponent Release SBORPV_TOCHAR20SBORPVNR
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

Key field Non-key field



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

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

SELECT SINGLE *
FROM TNODE01
INTO CORRESPONDING FIELDS OF WA_TNODE01
WHERE...

How to access SAP table TNODE01

Within an ECC or HANA version of SAP you can also view further information about TNODE01 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!