- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- ABAP Runtime Environment - ABAP Language Issues Only (BC-ABA)
- ABAP Workbench, Java IDE and Infrastructure (BC-DWB)
- BW Service API (BC-BW)
- Basis Services / Communication Interfaces (BC-SRV)
- Basis pieces of Central Business Configuration (BC-CBC)
- Business Management (BC-BMT)
- Business Server Pages (BC-BSP)
- Change & Transport System (BC-CTS)
- Client/Server Technology (BC-CST)
- Component Integration / Installation Windows Components (BC-CI)
- Customizing (Use Subcomponents) (BC-CUS)
- Customizing Tools (Techniques): Use Subcomponents (BC-CUS-TOL)
- Business Configuration API (SAP-internal) (BC-CUS-TOL-API)
- Business Configuration Sets (BC-CUS-TOL-BCD)
- Business Navigator (BC-CUS-TOL-NAV)
- Cross-System Tools (BC-CUS-TOL-CST)
- Customizing Project Management (IMG) (BC-CUS-TOL-PAD)
- Hierarchy Storage (BC-CUS-TOL-HMT)
- Implementation Guide (BC-CUS-TOL-IMG)
- Table Maintenance Tool (BC-CUS-TOL-TME)
- Customizing Tools (Techniques): Use Subcomponents (BC-CUS-TOL)
- Database Interface, Database Platforms (BC-DB)
- Documentation and Translation Tools (BC-DOC)
- Enterprise Content Management (ECM) (BC-ECM)
- Enterprise Information Management (use subcomponents) (BC-EIM)
- Enterprise Service Infrastructure (BC-ESI)
- Exchange Infrastructure - Use subcomponents (BC-XI)
- Frontend Services - Use subcomponents (see SAP Note 1322184) (BC-FES)
- Guided Procedure (BC-GP)
- Help Infrastructure (BC-HLP)
- Information Lifecycle Management (BC-ILM)
- Installation Tools (Use Subcomponents) (BC-INS)
- Intelligent Scenario Lifecycle Management (BC-ISM)
- Internationalization (I18N) (BC-I18)
- Middleware (BC-MID)
- Musing Tools (BC-MUS)
- Operating System Platforms (BC-OP)
- Ready-to-Run R/3 (BC-RRR)
- SAP NetWeaver Mobile - Use subcomponents (BC-MOB)
- SAP Screen Personas (BC-PER)
- Security (BC-SEC)
- TREX (BC-TRX)
- Test Workbench (BC-TWB)
- Upgrade - General (BC-UPG)
- Use Subcomponents (BC-CCM)
- Use subcomponents (BC-NWA)
- Virtual Machine Container (BC-VMC)
- Web Dynpro (BC-WD)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
TTREV_NODE
Hierarchy Tool: Structure Versioning Node Table
|
#transactional
|
Component: Hierarchy Storage
- 🔑 Keys (2)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (6)
- ☰ Categorical (15)
- Other (30)
- 🔗 Relations (1)
| Column Name | Description | |
|---|---|---|
| VERSION | Version ID | |
| NODE_COUNT | Hierarchy Tool: Counter of a Versioned Node |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| VALID_F_D | System Date | |
| VALID_T_D | System Date | |
| FDATE | Created On | |
| FTIME | Created at | |
| LDATE | Last Changed On | |
| LTIME | Time of Last Change |
| Column Name | Description | |
|---|---|---|
| LOG_REF | Flag with values ' ' and 'X' | Show values |
| LOCAL_FLAG | Local use: Must not be referenced | Show values |
| FORCE_PLUS | Flag with values ' ' and 'X' | Show values |
| W_SUBNODES | Flag with values ' ' and 'X' | Show values |
| LOST_EXT | Flag with values ' ' and 'X' | Show values |
| LOST_NODE | Flag with values ' ' and 'X' | Show values |
| IS_CUT | Flag with values ' ' and 'X' | Show values |
| CHECKBOXST | Status of a checkbox in a tree structure; values: A, I, P | Show values |
| MANUAL_SET | Flag with values ' ' and 'X' | Show values |
| NOFRONTEND | Flag with values ' ' and 'X' | Show values |
| NO_DISPLAY | Flag with values ' ' and 'X' | Show values |
| HIDDEN_FL | Flag with values ' ' and 'X' | Show values |
| DOUBLE_FL | Flag with values ' ' and 'X' | Show values |
| DEFAULTFLG | Flag with values ' ' and 'X' | Show values |
| NODRAGDROP | Flag with values ' ' and 'X' | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| NODE_ID | Unique ID - 32 characters | SYCHAR32 | |
| NODE_LEVEL | Node level | SEU_LEVEL | |
| EXTENSION | Structure enhancement ID | HIER_NAMES | |
| PARENT_ID | Unique ID - 32 characters | SYCHAR32 | |
| BROTHER_ID | ID of predecessor on same level | CHAR40 | |
| TREE_ID | Unique ID - 32 characters | SYCHAR32 | |
| REFNODE_ID | Unique ID - 32 characters | SYCHAR32 | |
| REFTREE_ID | Unique ID - 32 characters | SYCHAR32 | |
| VALID_F_R | Release of SAP System | SYCHAR04 | |
| VALID_T_R | Release of SAP System | SYCHAR04 | |
| FILTER_ID | Unique ID - 32 characters | SYCHAR32 | |
| APPL_FLAG1 | Flag: Use by application only | CHAR1 | |
| APPL_FLAG2 | Flag: Use by application only | CHAR1 | |
| APPL_FLAG3 | Flag: Use by application only | CHAR1 | |
| FUSER | Created By | HIER_USER | |
| FRELEASE | Release of SAP System | SYCHAR04 | |
| LUSER | Last Changed By | HIER_USER | |
| LRELEASE | Release of SAP System | SYCHAR04 | |
| NODE_KEY | Tree Control: Node Key | TM_CHAR12 | |
| PARENT_KEY | Tree Control: Node Key | TM_CHAR12 | |
| COPY_NODE | Unique ID - 32 characters | SYCHAR32 | |
| COPY_TREE | Unique ID - 32 characters | SYCHAR32 | |
| COPNODFRST | Unique ID - 32 characters | SYCHAR32 | |
| COPTREFRST | GUID for Structure | SYCHAR32 | |
| COMPONENT | Technical Description of Logical Components | SYSDLVUNIT | |
| SYSTEMINST | Code for an Assigned System Landscape in Project | SYSTEMINST | |
| COMPRELFR | SAP Release | CHAR10 | |
| COMPRELTO | SAP Release | CHAR10 | |
| PRDVERSFR | Component Release | SBORPVNR | |
| PRDVERSTO | Component Release | SBORPVNR |
| Master Data Relations | Join Conditions |
|---|---|
| Foreign key for node type | TTREV_NODE.NODE_TYPE == TNODEH.NODE_TYPE |