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

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CUS-TOL-HMT (Application Component) Hierarchy Storage
     ⤷ SHI2 (Package) Hierarchy maintenance tool - structure for IMG etc.

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TNODE01	Table Relationship Diagram
Short Description	Node Table for General Structure Storage

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Include Key for Structure Item Table
2	TREE_ID	☑	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
3	EXTENSION	☑	HIER_NAMES	HIER_NAMES	CHAR	15	0	Structure enhancement ID	*
4	NODE_ID	☑	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
5	EXT_KEY	☑	HIER_TREE	HIER_TREE	CHAR	12	0	External key
6	.INCLUDE	☐				0	0	Node table data part Include
7	PARENT_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
8	BROTHER_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
9	REFNODE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
10	REFTREE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
11	NODE_TYPE	☐	HIER_NODET	HIER_NODET	CHAR	4	0	Valid Node Types in Structure Repository	TNODEH
12	LOCAL_FLAG	☐	HIER_LOCAL	HIER_YESNO	CHAR	1	0	Local use: Must not be referenced
13	VALID_F_R	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
14	VALID_T_R	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
15	VALID_F_D	☐	SYDATUM	SYDATS	DATS	8	0	System Date
16	VALID_T_D	☐	SYDATUM	SYDATS	DATS	8	0	System Date
17	W_SUBNODES	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
18	APPL_FLAG1	☐	HIER_AFLAG	CHAR1	CHAR	1	0	Flag: Use by application only
19	APPL_FLAG2	☐	HIER_AFLAG	CHAR1	CHAR	1	0	Flag: Use by application only
20	APPL_FLAG3	☐	HIER_AFLAG	CHAR1	CHAR	1	0	Flag: Use by application only
21	COPY_NODE	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
22	COPY_TREE	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
23	COPNODFRST	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
24	COPTREFRST	☐	HIER_TREEG	SYCHAR32	CHAR	32	0	GUID for Structure
25	COMPONENT	☐	SYSDLVUNIT	SYSDLVUNIT	CHAR	30	0	Technical Description of Logical Components	*
26	SYSTEMINST	☐	SYSTEMINST	SYSTEMINST	CHAR	20	0	Code for an Assigned System Landscape in Project	*
27	COMPRELFR	☐	SAPRELEASE	CHAR10	CHAR	10	0	SAP Release
28	COMPRELTO	☐	SAPRELEASE	CHAR10	CHAR	10	0	SAP Release
29	DEFAULTFLG	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
30	PRDVERSFR	☐	SBORPV_FRM	SBORPVNR	CHAR	20	0	Component Release
31	PRDVERSTO	☐	SBORPV_TO	SBORPVNR	CHAR	20	0	Component Release
32	.INCLUDE	☐				0	0	Creation data and change data for gen. hierarchy storage
33	FUSER	☐	HIER_FUSER	HIER_USER	CHAR	12	0	Created by
34	FDATE	☐	HIER_FDATE	SYDATS	DATS	8	0	Created on
35	FTIME	☐	HIER_FTIME	SYTIME	TIMS	6	0	Created at
36	FRELEASE	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
37	LUSER	☐	HIER_LUSER	HIER_USER	CHAR	12	0	Last changed by
38	LDATE	☐	HIER_LDATE	SYDATS	DATS	8	0	Last Changed On
39	LTIME	☐	HIER_LTIME	SYTIME	TIMS	6	0	Time of Last Change
40	LRELEASE	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TNODE01	NODE_TYPE	TNODEH	NODE_TYPE		1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in