| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /B364/HFPID | Hierarchy: InfoObject Structure Element | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 2 | /B364/HMPITEMS | Hierarchy: InfoObject Structure Element | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 3 | /B631/HACTTYPE | Hierarchy: InfoObject Activity Type | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 4 | /B631/HCOORDER | Hierarchy: InfoObject Order | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 5 | /B631/HCOSTCNTR | Hierarchy: InfoObject Cost Center | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 6 | /B631/HCOSTELMT | Hierarchy: InfoObject Cost Element | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 7 | /B631/HPLANT | Hierarchy: InfoObject Plant | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 8 | /B631/HPROFTCTR | Hierarchy: InfoObject Profit Center | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 9 | /B631/HWBSELMT | Hierarchy: InfoObject WBS Element | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 10 | /B631/JACTTYPE | Hierarchy Interval: InfoObject Activity Type | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 11 | /B631/JCOORDER | Hierarchy Interval: InfoObject Order | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 12 | /B631/JCOSTCNTR | Hierarchy Interval: InfoObject Cost Center | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 13 | /B631/JCOSTELMT | Hierarchy Interval: InfoObject Cost Element | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 14 | /B631/JPROFTCTR | Hierarchy Interval: InfoObject Profit Center | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 15 | /BI0/HBUCKET | Hierarchy: InfoObject Directory of Precalc | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 16 | /BI0/HCALMONTH | Hierarchy: InfoObject Calendar Year/Month | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 17 | /BI0/HCALMONTH2 | Hierarchy: InfoObject Calendar month | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 18 | /BI0/HDATE | Hierarchy: InfoObject Date | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 19 | /BI0/HFISCPER | Hierarchy: InfoObject Fiscal year/period | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 20 | /BI0/HHALFYEAR1 | Hierarchy: InfoObject Halfyear | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 21 | /BI0/HINFOPROV | Hierarchy: InfoObject InfoProvider | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 22 | /BI0/HIOBJNM | Hierarchy: InfoObject InfoObject | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 23 | /BI0/HRSPL_ORG | Hierarchy: InfoObject Area of Responsibil. | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 24 | /BI0/HRSTT_EID | Hierarchy: InfoObject Error ID | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 25 | /BI0/HRSTT_FTPC | Hierarchy: InfoObject Function Subject | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 26 | /BI0/HRSTT_FUNC | Hierarchy: InfoObject Functions | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 27 | /BI0/HRSTT_IONM | Hierarchy: InfoObject InfoObject | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 28 | /BI0/HRSTT_IPBZM | Hierarchy: InfoObject RTM for Non-Cum. | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 29 | /BI0/HRSTT_IPNM | Hierarchy: InfoObject InfoProvider Name | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 30 | /BI0/HRSTT_JID | Hierarchy: InfoObject Job ID | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 31 | /BI0/HRSTT_OBJNM | Hierarchy: InfoObject Object Name | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 32 | /BI0/HRSTT_PID | Hierarchy: InfoObject Trace Package ID | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 33 | /BI0/HRSTT_PVAR | Hierarchy: InfoObject Play Variant | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 34 | /BI0/HRSTT_QYNM | Hierarchy: InfoObject Query Name | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 35 | /BI0/HRSTT_RQID | Hierarchy: InfoObject Test Request | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 36 | /BI0/HRSTT_RVAR | Hierarchy: InfoObject Ref. Data Variant | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 37 | /BI0/HRSTT_SAPCP | Hierarchy: InfoObject SAP Component | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 38 | /BI0/HRSTT_SVARI | Hierarchy: InfoObject Selection Variant | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 39 | /BI0/HRSTT_TID | Hierarchy: InfoObject Trace ID | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 40 | /BI0/HRSTT_TLAY | Hierarchy: InfoObject Trace Layer | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 41 | /BI0/HRSTT_TOTYP | Hierarchy: InfoObject Object Type (Transp) | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 42 | /BI0/HRSTT_TRANR | Hierarchy: InfoObject Transport Request | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 43 | /BI0/HRSTT_TRTGT | Hierarchy: InfoObject Transport Target | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 44 | /BI0/HRSTT_USER | Hierarchy: InfoObject Trace User | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 45 | /BI0/HTCAIFAREA | Hierarchy: InfoObject InfoArea Analys. Aut | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 46 | /BI0/HTCTAPPL | Hierarchy: InfoObject Appl. Component | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 47 | /BI0/HTCTBWOBJCT | Hierarchy: InfoObject BI Object | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 48 | /BI0/HTCTIFAREA | Hierarchy: InfoObject InfoArea | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 49 | /BI0/HTCTMDXFC | Hierarchy: InfoObject MDX Functions | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 50 | /BI0/HTCTPRCSCHN | Hierarchy: InfoObject Process Chain ID | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 51 | /BI0/HTCTQUERID | Hierarchy: InfoObject Query (UID) | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 52 | /BI0/HTCTSOURSYS | Hierarchy: InfoObject Source System | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 53 | /BI0/HTCTSTATEVT | Hierarchy: InfoObject Statistics Event | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 54 | /BI0/HTCTSYSID | Hierarchy: InfoObject BW System | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 55 | /BI0/HTCTUSERNM | Hierarchy: InfoObject User | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 56 | /BI0/HTCTUSRNM | Hierarchy: InfoObject User ID | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 57 | /BI0/JDATE | Hierarchy Interval: InfoObject Date | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 58 | CNV_20333_PRIO | CKRCO key for priority VD object numbers | 5 | HIEID | | nvarchar | 8 | 0 | | |
| 59 | RSDMHIETAB740 | Model Table: Hierarchies of a Characteristic (from 3.0B) | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 60 | RSDMHINTAB740 | Model table: Hierarchy intervals of a characteristic | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 61 | RSECHIE_STRING | Status of Authorization Hierarchies | 6 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 62 | T241E | Text to sort reports into report portfolio | 5 | HIEID | User group | nvarchar | 2 | 0 | | |
| 63 | T241H | Text for report portfolio hierarchy | 3 | HIEID | User group | nvarchar | 2 | 0 | | |
| 64 | T241Z | User profile text table | 3 | HIEID | User group | nvarchar | 2 | 0 | | |
| 65 | T242E | Sort reports into report portfolio | 4 | HIEID | User group | nvarchar | 2 | 0 | | |
| 66 | T242H | Hierarchies in report portfolio | 2 | HIEID | User group | nvarchar | 2 | 0 | | |
| 67 | T242Z | Hierarchy index | 2 | HIEID | User group | nvarchar | 2 | 0 | | |
| TOPBusiness Planning |
| 68 | UPB_YT_HIERARCHY | BW Hierarchies: Header Data | 2 | HIEID | Hierarchy Key BW | nvarchar | 25 | 0 | | |
| TOPControlling |
| 69 | FCOMIPHIEDIR | Unique Ids for extracted Hierarchies | 2 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| TOPData Basis |
| 70 | RSEHIERNODE | Master Data: Hierarchy Nodes that Cannot Be Posted To | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 71 | RSHIEDIR | Hierarchy Catalog | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 72 | RSHIEDIRT | Hierarchy directory texts | 2 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 73 | RSHIELVT | Levels Table for Hierarchies in BW | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 74 | RSMAXHIETAB | Hierarchy Node Table with Maximum Possible Structure | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 75 | RSMDHIERATTR | Attribute Table Metadata Hierarchies | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 76 | RSMDUCMUKHIER | UT Hierarchy: Identifying attributes for MUKs | 4 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 77 | RSMHIERNODE | Master data: Hierarchy nodes that cannot be posted to | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 78 | RSTHIERNODE | Texts of Non-Postable Hierarchy Nodes | 2 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| TOPData Collection |
| 79 | TKEBG | Graphic settings for hierarchy graphic | 3 | HIEID | User group | nvarchar | 2 | 0 | | |
| TOPData Staging |
| 80 | RSOSOHIE | Directory for Master Data Hierarchies | 10 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 81 | RSOSOHIESH | Shadow Table: Hierarchy Information in BW | 10 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 82 | RSOSOHIET | Directory for Master Data Hierarchies - Texts | 11 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 83 | RSOSOHIETSH | Shadow Table: Hierarchy Information in BW | 11 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| TOPEnd User Technology |
| 84 | RSRFAVREPT | Text table for executable nodes in the favorites | 2 | HIEID | UUID in compressed form | nvarchar | 25 | 0 | | |
| TOPInteractive Drilldown Reporting |
| 85 | TRSTHV_VP | BRST Repository of Hierarchies - Virtual InfoProvider | 2 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| TOPMetadata Repository |
| 86 | RSDMHIETAB | Obsolete from APOLLO -> RSDMHIERTABNEW | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 87 | RSDMHIETABNEW | Model Table: Hierarchies of a Characteristic (from 3.0B) | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 88 | RSDMHINTAB | Obsolete from APOLLO -> RSDMHINTABNEW | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 89 | RSDMHINTABNEW | Model table: Hierarchy intervals of a characteristic | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| TOPOLAP Technology |
| 90 | RSDDAGGRCOMP | Description of the aggregates | 5 | HIEID | Hierarchy ID for characteristic | nvarchar | 25 | 0 | | |
| 91 | RSDDCHNGPROT | Table with InfoObject whose master table has been changed | 3 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 92 | RSDDTPS_HIER_HNM | Hierarchies for Use in Polestar | 5 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 93 | RSDDTPS_HIER_IP | Assignment of Hiers to InfoProvider/InfoObject Combination | 6 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 94 | RSECHIE | Status of Authorization Hierarchies | 5 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 95 | RSECHIE_CL | Authorization Hierarchies Changes Change Log | 9 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 96 | RSRHIEDIR_OLAP | OLAP Relevant Information for the Hierarchies | 7 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 97 | RSSAUTHHIER | Definition of the Authorizations for Hierarchies | 3 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| TOPPurchasing |
| 98 | WRFT_BUDG_LEV | Budget Level | 11 | HIEID | Hierarchy ID | nvarchar | 2 | 0 | | |
| TOPReport Selection for Product Costing |
| 99 | CKRCO | Anchor Entry of Summarized CO Object (Summarization Object) | 3 | HIEID | Hierarchy ID | nvarchar | 8 | 0 | | |
| 100 | CKRCT | Texts for CKRCO | 3 | HIEID | Hierarchy ID | nvarchar | 8 | 0 | | |
| TOPWithout Description |
| 101 | RSDDCVERREPHIER | Aggregates that should be refilled after correction | 1 | HIEID | Internal hierarchy ID (unique ID) | nvarchar | 25 | 0 | | |
| 102 | RSHIENODES | Hierarchy Node(s) | 1 | HIEID | UUID in compressed form | nvarchar | 25 | 0 | | |
