SAP ABAP Table TTREE (Definition table for structures)

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	TTREE	Table Relationship Diagram
Short Description	Definition table for structures

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	ID	☑	HIER_TREEG	SYCHAR32	CHAR	32	0	GUID for Structure
2	EXTENSION	☐	HIER_NAMES	HIER_NAMES	CHAR	15	0	Structure enhancement ID	*
3	EXT_KEY	☐	HIER_TREE	HIER_TREE	CHAR	12	0	External key
4	TYPE	☐	HIER_TREET	HIER_TREET	CHAR	5	0	Structure Type	TTREETYPE
5	NODE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
6	TREE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
7	MASTERLANG	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
8	RESPONSIBL	☐	UNAME	UNAME	CHAR	12	0	User Name
9	BUFFERMODE	☐	HIER_BUFMO	HIER_BUFMO	CHAR	1	0	Buffer mode of structure data
10	BUFFERVAR	☐	HIER_BUFVA	CHAR10	CHAR	10	0	Parameters for buffering
11	SINGLENODE	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
12	SUBTREEONL	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
13	LOG_STR	☐	HIER_LOSTR	HIER_LOSTR	CHAR	1	0	Flag: Logical or Physical Structure
14	.INCLUDE	☐				0	0	Creation data and change data for gen. hierarchy storage
15	FUSER	☐	HIER_FUSER	HIER_USER	CHAR	12	0	Created by
16	FDATE	☐	HIER_FDATE	SYDATS	DATS	8	0	Created on
17	FTIME	☐	HIER_FTIME	SYTIME	TIMS	6	0	Created at
18	FRELEASE	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
19	LUSER	☐	HIER_LUSER	HIER_USER	CHAR	12	0	Last changed by
20	LDATE	☐	HIER_LDATE	SYDATS	DATS	8	0	Last Changed On
21	LTIME	☐	HIER_LTIME	SYTIME	TIMS	6	0	Time of Last Change
22	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	TTREE	MASTERLANG	T002	SPRAS		1	CN
2	TTREE	TYPE	TTREETYPE	TREE_TYPE		1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in