| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | YIT_TREE_E | IDES Repository: Demo Hierarchy | 2 | HIERARCHY | Hierarchy Type: Sorted by Name, ID, as in Online Help | nvarchar | 1 | 0 | | |
| 2 | YIT_TREE_P | IDES Repository: IDES Process Hierarchy | 2 | HIERARCHY | Hierarchy Type: Sorted by Name, ID, as in Online Help | nvarchar | 1 | 0 | | |
| 3 | YIT_TREE_PROCESS | IDES Infobase: IDES Process Hierarchy | 2 | HIERARCHY | Hierarchy Type: Sorted by Name, ID, as in Online Help | nvarchar | 1 | 0 | | |
| 4 | YIT_TREE_T | IDES Repository: Training Course Hierarchy | 2 | HIERARCHY | Hierarchy Type: Sorted by Name, ID, as in Online Help | nvarchar | 1 | 0 | | |
| TOPBusiness Planning |
| 5 | UPB_SY_HIERARCHY | Implemented Hierarchies | 1 | HIERARCHY | Select a Hierarchy | nvarchar | 4 | 0 | | |
| 6 | UPB_SY_HIER_T | Text Table for Implemented Hierarchy | 1 | HIERARCHY | Select a Hierarchy | nvarchar | 4 | 0 | | |
| TOPCentral Part of Product Master |
| 7 | COMM_APPLCATGRPR | Application Area of a Hierarchy | 3 | HIERARCHY | Category Hierarchy Used | varbinary | 16 | 0 | | |
| 8 | COMM_PRAPPL_HIER | Product Type-Specific Application Area of a Hierarchy | 4 | HIERARCHY | Category Hierarchy Used | varbinary | 16 | 0 | | |
| TOPClaims Management |
| 9 | TICL138 | Claim Item Grouping Category | 4 | HIERARCHY | Hierarchy Level of Claim Item Grouping Category | nvarchar | 2 | 0 | | |
| TOPData Collection |
| 10 | TKEBZ | Exceptions (threshold values, colors) | 14 | HIERARCHY | Exception in hierarchy graphic | nvarchar | 1 | 0 | | |
| TOPDistribution Requirements Planning |
| 11 | TCSCP_COMP_LVL | Material completion levels (including their sequence) | 3 | HIERARCHY | Hierarchy index for material completion levels | nvarchar | 2 | 0 | | |
| TOPDocument Management Framework |
| 12 | SKWF_TRANS | Shadow Table for Namespace Transport | 19 | HIERARCHY | Natural Number | int | 10 | 0 | | |
| TOPGovernance, Risk and Compliance |
| 13 | GRFNREPSTRATEGY | Report: Walking Strategy | 10 | HIERARCHY | Node is part of hierarchy | nvarchar | 1 | 0 | | |
| TOPLocalization |
| 14 | IDCN_ARCHIV_ITEM | Archive Items (Golden Audit) | 6 | HIERARCHY | Hierarchy | nvarchar | 1 | 0 | | |
| 15 | J_3RFTAX_ASSIGN | Tax hierarchy assignment to company code | 3 | HIERARCHY | Tax Objects Hierarchy Code | nvarchar | 5 | 0 | | |
| 16 | J_3RFTAX_ASSIGNE | Tax hierarchy assignment to company code/ledger | 4 | HIERARCHY | Tax Objects Hierarchy Code | nvarchar | 5 | 0 | | |
| 17 | J_3RFTAX_HIER | Tax Hierarchies | 2 | HIERARCHY | Tax Objects Hierarchy Code | nvarchar | 5 | 0 | | |
| 18 | J_3RFTAX_HIERT | Tax object hierarchies texts | 2 | HIERARCHY | Tax Objects Hierarchy Code | nvarchar | 5 | 0 | | |
| 19 | J_3RFTAX_UNCLASS | Unclassified objects | 2 | HIERARCHY | Tax Objects Hierarchy Code | nvarchar | 5 | 0 | | |
| TOPMaster Data Framework |
| 20 | DML_RELTYPE | MDF: Properties of Relationship Types | 5 | HIERARCHY | Hierarchy | nvarchar | 1 | 0 | | |
| TOPMobile Applications |
| 21 | /ISDFPS/ME_SEGM | Detailed Information for DO Segments | 13 | HIERARCHY | Classification: Level in Hierarchy | int | 10 | 0 | | |
| 22 | /ISDFPS/MSG_BODY | Data for Error/Conflict Messages | 4 | HIERARCHY | Hierarchy | nvarchar | 10 | 0 | | |
| TOPPortfolio Management |
| 23 | /RPM/PORTFOLIO_D | Portfolio Operational persisted data | 14 | HIERARCHY | Classification Hierarchy | nvarchar | 1 | 0 | | |
| 24 | RPM_PORTFOLIO_CD | Portfolio attributes - Pseudo table for change documents | 14 | HIERARCHY | Classification Hierarchy | nvarchar | 1 | 0 | | |
| TOPProject System |
| 25 | PSHLP_CACHE_DB | Maintains Project Cache Information | 14 | HIERARCHY | | ntext | 1073741823 | 0 | | |
| 26 | PSHLP_CACHE_DB_N | Maintains Project Cache Information | 14 | HIERARCHY | | image | 2147483647 | 0 | | |
| TOPPurchasing |
| 27 | WRFT_BUDG_LEV | Budget Level | 10 | HIERARCHY | Use of a Hierarchy | nvarchar | 1 | 0 | | |
| TOPSAP Business Workflow |
| 28 | TETYP | Workflow Definition: Node Types (Central) | 7 | HIERARCHY | Workflow definition: Hierarchy flag | nvarchar | 1 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 29 | TNNLCLASS_MESS | Meldung Klassifikation meldungen | 6 | HIERARCHY | | smallint | 5 | 0 | | |
| 30 | TNNLREJCLAS_MESS | Rejection Classification Messages | 6 | HIERARCHY | | tinyint | 3 | 0 | | |
| TOPSets |
| 31 | SETHANA_HIER | Status of set hierarchies in HANA | 4 | HIERARCHY | Set Name | nvarchar | 24 | 0 | | |
| 32 | SETHANA_STATUS | Status of set hierarchies in HANA | 4 | HIERARCHY | Set Name | nvarchar | 24 | 0 | | |
| TOPStakeholder Relationship Management |
| 33 | USS_TREE_DEFAULT | SRM: User-Specific Settings for Transactions usth0 and ucon0 | 4 | HIERARCHY | Version Number Component | nvarchar | 2 | 0 | | |
