SAP Table TTREE
Definition table for structures
TTREE (Definition table for structures) 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 TTREE to other SAP tables.
TTREE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | GUID for Structure | HIER_TREEG | CHAR | 32 | 0 | |||||||||
| EXTENSION | Structure enhancement ID | HIER_NAMES | CHAR | 15 | 0 | |||||||||
| EXT_KEY | External key | HIER_TREE | CHAR | 12 | 0 | |||||||||
| TYPE | Structure Type | HIER_TREET | TTREETYPE | CHAR | 5 | 0 | ||||||||
| NODE_ID | Unique ID - 32 characters | HIER_GUID | CHAR | 32 | 0 | |||||||||
| TREE_ID | Unique ID - 32 characters | HIER_GUID | CHAR | 32 | 0 | |||||||||
| MASTERLANG | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||
| RESPONSIBL | User Name | UNAME | CHAR | 12 | 0 | |||||||||
| BUFFERMODE | Buffer mode of structure data | HIER_BUFMO | CHAR | 1 | 0 |
Possible values
|
||||||||
| BUFFERVAR | Parameters for buffering | HIER_BUFVA | CHAR | 10 | 0 | |||||||||
| SINGLENODE | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | 0 |
Possible values
|
||||||||
| SUBTREEONL | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | 0 |
Possible values
|
||||||||
| LOG_STR | Flag: Logical or Physical Structure | HIER_LOSTR | CHAR | 1 | 0 |
Possible values
|
||||||||
| 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 | |||||||||
