SAP Table TNODEIMG

Node table for the new IMG

TNODEIMG (Node table for the new IMG) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TNODEIMG to other SAP tables.

TNODEIMG table fields

Field Data element Checktable Datatype Length Decimals
TREE_ID Unique ID - 32 characters HIER_GUID CHAR 32 0
EXTENSION Structure enhancement ID HIER_NAMES CHAR 15 0
NODE_ID Unique ID - 32 characters HIER_GUID CHAR 32 0
EXT_KEY External key HIER_TREE CHAR 12 0
PARENT_ID Unique ID - 32 characters HIER_GUID CHAR 32 0
BROTHER_ID Unique ID - 32 characters HIER_GUID CHAR 32 0
REFNODE_ID Unique ID - 32 characters HIER_GUID CHAR 32 0
REFTREE_ID Unique ID - 32 characters HIER_GUID CHAR 32 0
NODE_TYPE Valid Node Types in Structure Repository HIER_NODET TNODEH CHAR 4 0
LOCAL_FLAG Local use: Must not be referenced HIER_LOCAL CHAR 1 0
X Valid; selected
NULL Not valid; not selected
VALID_F_R Release of SAP System SYSAPRL CHAR 4 0
VALID_T_R Release of SAP System SYSAPRL CHAR 4 0
VALID_F_D System Date SYDATUM DATS 8 0
VALID_T_D System Date SYDATUM DATS 8 0
W_SUBNODES Flag with values ' ' and 'X' HIER_YESNO CHAR 1 0
X Valid; selected
NULL Not valid; not selected
APPL_FLAG1 Flag: Use by application only HIER_AFLAG CHAR 1 0
APPL_FLAG2 Flag: Use by application only HIER_AFLAG CHAR 1 0
APPL_FLAG3 Flag: Use by application only HIER_AFLAG CHAR 1 0
COPY_NODE Unique ID - 32 characters HIER_GUID CHAR 32 0
COPY_TREE Unique ID - 32 characters HIER_GUID CHAR 32 0
COPNODFRST Unique ID - 32 characters HIER_GUID CHAR 32 0
COPTREFRST GUID for Structure HIER_TREEG CHAR 32 0
COMPONENT Technical Description of Logical Components SYSDLVUNIT CHAR 30 0
SYSTEMINST Code for an Assigned System Landscape in Project SYSTEMINST CHAR 20 0
COMPRELFR SAP Release SAPRELEASE CHAR 10 0
COMPRELTO SAP Release SAPRELEASE CHAR 10 0
DEFAULTFLG Flag with values ' ' and 'X' HIER_YESNO CHAR 1 0
X Valid; selected
NULL Not valid; not selected
PRDVERSFR Component Release SBORPV_FRM CHAR 20 0
PRDVERSTO Component Release SBORPV_TO CHAR 20 0
FUSER Created by HIER_FUSER CHAR 12 0
FDATE Created on HIER_FDATE DATS 8 0
FTIME Created at HIER_FTIME TIMS 6 0
FRELEASE Release of SAP System SYSAPRL CHAR 4 0
LUSER Last changed by HIER_LUSER CHAR 12 0
LDATE Last Changed On HIER_LDATE DATS 8 0
LTIME Time of Last Change HIER_LTIME TIMS 6 0
LRELEASE Release of SAP System SYSAPRL CHAR 4 0

TNODEIMG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TNODEIMG NODE_TYPE TNODEIMG NODE_TYPE TNODEH List of valid node types NODE_TYPE