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

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CUS-TOL-HMT (Application Component) Hierarchy Storage
     ⤷ SHI_VERS (Package) Hierarchy tool - Versioning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TTREV_NODE	Table Relationship Diagram
Short Description	Hierarchy Tool: Structure Versioning Node Table

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
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	VERSION	☑	HIER_VERS	SYCHAR32	CHAR	32	0	Version ID
2	NODE_COUNT	☑	HIER_VERCT	NUMC08	NUMC	8	0	Hierarchy Tool: Counter of a Versioned Node
3	.INCLUDE	☐				0	0	Hierarchy Maintenance Tool Node Passing Interface
4	NODE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
5	NODE_TYPE	☐	HIER_NODET	HIER_NODET	CHAR	4	0	Valid Node Types in Structure Repository	TNODEH
6	NODE_LEVEL	☐	SEU_LEVEL	SEU_LEVEL	NUMC	2	0	Node level
7	EXTENSION	☐	HIER_NAMES	HIER_NAMES	CHAR	15	0	Structure enhancement ID	*
8	PARENT_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
9	BROTHER_ID	☐	HIER_BR_ID	CHAR40	CHAR	40	0	ID of predecessor on same level
10	TREE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
11	REFNODE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
12	REFTREE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
13	LOG_REF	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
14	LOCAL_FLAG	☐	HIER_LOCAL	HIER_YESNO	CHAR	1	0	Local use: Must not be referenced
15	VALID_F_R	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
16	VALID_T_R	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
17	VALID_F_D	☐	SYDATUM	SYDATS	DATS	8	0	System Date
18	VALID_T_D	☐	SYDATUM	SYDATS	DATS	8	0	System Date
19	FORCE_PLUS	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
20	W_SUBNODES	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
21	FILTER_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
22	LOST_EXT	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
23	LOST_NODE	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
24	APPL_FLAG1	☐	HIER_AFLAG	CHAR1	CHAR	1	0	Flag: Use by application only
25	APPL_FLAG2	☐	HIER_AFLAG	CHAR1	CHAR	1	0	Flag: Use by application only
26	APPL_FLAG3	☐	HIER_AFLAG	CHAR1	CHAR	1	0	Flag: Use by application only
27	.INCLUDE	☐				0	0	Creation data and change data for gen. hierarchy storage
28	FUSER	☐	HIER_FUSER	HIER_USER	CHAR	12	0	Created by
29	FDATE	☐	HIER_FDATE	SYDATS	DATS	8	0	Created on
30	FTIME	☐	HIER_FTIME	SYTIME	TIMS	6	0	Created at
31	FRELEASE	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
32	LUSER	☐	HIER_LUSER	HIER_USER	CHAR	12	0	Last changed by
33	LDATE	☐	HIER_LDATE	SYDATS	DATS	8	0	Last Changed On
34	LTIME	☐	HIER_LTIME	SYTIME	TIMS	6	0	Time of Last Change
35	LRELEASE	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
36	NODE_KEY	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
37	PARENT_KEY	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
38	IS_CUT	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
39	CHECKBOXST	☐	HIER_BOXST	HIER_BOXST	CHAR	1	0	Status of a checkbox in a tree structure; values: A, I, P
40	MANUAL_SET	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
41	NOFRONTEND	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
42	NO_DISPLAY	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
43	HIDDEN_FL	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
44	DOUBLE_FL	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
45	DEFAULTFLG	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
46	COPY_NODE	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
47	COPY_TREE	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
48	COPNODFRST	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
49	COPTREFRST	☐	HIER_TREEG	SYCHAR32	CHAR	32	0	GUID for Structure
50	COMPONENT	☐	SYSDLVUNIT	SYSDLVUNIT	CHAR	30	0	Technical Description of Logical Components	*
51	SYSTEMINST	☐	SYSTEMINST	SYSTEMINST	CHAR	20	0	Code for an Assigned System Landscape in Project	*
52	COMPRELFR	☐	SAPRELEASE	CHAR10	CHAR	10	0	SAP Release
53	COMPRELTO	☐	SAPRELEASE	CHAR10	CHAR	10	0	SAP Release
54	NODRAGDROP	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
55	PRDVERSFR	☐	SBORPV_FRM	SBORPVNR	CHAR	20	0	Component Release
56	PRDVERSTO	☐	SBORPV_TO	SBORPVNR	CHAR	20	0	Component Release

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in	50A