SAP Hierarchy Storage Tables
Are you looking for the right table related to SAP Hierarchy Storage Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Hierarchy Storage (BC-CUS-TOL-HMT) module.
Top 10 tables in Hierarchy Storage
| Table | Description |
|---|---|
| TTREVT | Versions: Copy of TTREET |
| TTREELOADT | Generation data for structure buffering (texts) |
| TTREVBRAEX | Versions: Copy of TTREEBRAEX |
| TTREV_NODE | Hierarchy Tool: Structure Versioning Node Table |
| TTREVT_COM | Comparison: Header Table TTREV_COMP Texts |
| TTREESRCH | Generation data for structure buffering (nodes/links) |
| TTREV_REF | Hierarchy tool: Versioning of Links |
| TTREETYPET | Name of valid structure types |
| TTREV_VLNK | Hierarchy Tool: Link Original/Version |
| TTREV_HEAD | Header table for structure versions |
List of tables in Hierarchy Storage
| Table | Description |
|---|---|
| TTREVT | Versions: Copy of TTREET |
| TTREELOADT | Generation data for structure buffering (texts) |
| TTREVBRAEX | Versions: Copy of TTREEBRAEX |
| TTREV_NODE | Hierarchy Tool: Structure Versioning Node Table |
| TTREVT_COM | Comparison: Header Table TTREV_COMP Texts |
| TTREESRCH | Generation data for structure buffering (nodes/links) |
| TTREV_REF | Hierarchy tool: Versioning of Links |
| TTREETYPET | Name of valid structure types |
| TTREV_VLNK | Hierarchy Tool: Link Original/Version |
| TTREV_HEAD | Header table for structure versions |
| TTREE_FLNK | Link between old and new nodes in filter |
| SHIE_PROP | SHIE_PROPN domain value table |
| TTREV_FLNK | Versions: Copy of TTREE_FLNK |
| INDX_HSRCH | Text buffering table for searching in structures |
| TNODEE | Definition of attributes of a node type |
| TTREVN | Versions: Copy of TTREEN |
| TARCH01R | General Structure Storage References |
| TNODET | Name of valid node types |
| TTREVI | List of Active Nodes for a Structure |
| TTREVROAEX | Versions: Copy of TTREEROAEX |
| INDX_HIER | INDX-Like Table for Buffering of Structures |
| TTREE_FLP | Hierarchy tool: Link between filter, log. and phys. str. |
| TTREV | Versions: Header Data |
| TTREVCOUEX | Versions: Copy of TTREECOUEX |
| SHIE_PROPT | Text table for table SHIE_PROP |
| TNODERTYPE | Node type: Assignable link types |
| TTREE | Definition table for structures |
| TTREED | Hierarchy Tool: Double Nodes |
| TTREVBRAIN | Versions: Copy of TTREEBRAIN |
| TTREVROLEX | Versions: Copy of TTREEROLEX |
| TTREVROLIN | Versions: Copy of TTREEROLIN |
| TARCH01T | General Structure Storage Node Names |
| TTREV_APPL | Versions: Copy of TTREE_APPL |
| TTREVSUBEX | Versions: Copy of TTREESUBEX |
| TNODE01T | General Structure Storage Node Names |
| TTREE_APPL | Application-defined additional structure data |
| TTREVSUBIN | Versions: Copy of TTREESUBIN |
| TARCH01 | Node Table for General Structure Storage |
| TTREV_ROLE | Version Management: Comparison Results |
| TTREVS | Versions: Copy of TTREES |
| TTREE_GEN | Application-defined additional structure data |
| TNODE01 | Node Table for General Structure Storage |
| COMP_TYPES | Hierarchy Tool: Comparison Type Check Table |
| TTREEF | User-specific list of favorites of structure maintenance |
| TTREVCOUIN | Versions: Copy of TTREECOUIN |
| TTREET | Name of a structure |
| TNODES | Node type: Valid sub-node types |
| TNODE01R | General Structure Storage References |
| TTREE_EXT | Structure enhancement ID |
| TTREETYPEN | List of valid node types per structure type |
| TTREEP | Parameter for view: Maintenance by application only |
| TTREVTROLE | Version Management: Comparison Result Texts |
| TTREV_HCHI | Header table for structure versions |
| TTREEN | List of node types to be displayed for a structure |
| TRTYPET | Name of valid link types |
| TTREV_COMP | Versions: Structure/Hierarchy Comparisons |
| TTREETYPE | List of valid structure types |
| TNODEH | List of valid node types |
| TTREVROAIN | Versions: Copy of TTREEROAIN |
| TTREE_JOB | Hierarchy Tool: Background Jobs |
| TRTYPEH | List of valid link types |
| TTREELOADS | Generation data for structure buffering (nodes/links) |
| TTREV_DNUM | Version Management: Number of Deleted Header Data Records |
| TTREES | Read sequence for namespace identifier |
| TTREE_SFW_NODES | Assignment of SFW Switches to Hierarchy Tool Nodes |
| TTREVTHEAD | Versions: Header Data Texts |
| TTREV_TEXT | Hierarchy Tool: Node Text Versioning |
| TTREEI | List of Active Nodes for a Structure |
| TTREVP | Versions: Copy of TTREEP |
| TTREE_EXTT | Table TTREE_EXT text table |