| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /B364/IFPID | SID Structure of Hierarchies: InfoObject Structure Element | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
2 | /B364/IMPITEMS | SID Structure of Hierarchies: InfoObject Structure Element | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
3 | /B364/KFPID | Conversion of Hierarchy Nodes - SID: InfoObject Structure El | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
4 | /B364/KMPITEMS | Conversion of Hierarchy Nodes - SID: InfoObject Structure El | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
5 | /B631/IACTTYPE | SID Structure of Hierarchies: InfoObject Activity Type | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
6 | /B631/ICOORDER | SID Structure of Hierarchies: InfoObject Order | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
7 | /B631/ICOSTCNTR | SID Structure of Hierarchies: InfoObject Cost Center | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
8 | /B631/ICOSTELMT | SID Structure of Hierarchies: InfoObject Cost Element | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
9 | /B631/IPLANT | SID Structure of Hierarchies: InfoObject Plant | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
10 | /B631/IPROFTCTR | SID Structure of Hierarchies: InfoObject Profit Center | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
11 | /B631/IWBSELMT | SID Structure of Hierarchies: InfoObject WBS Element | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
12 | /B631/KACTTYPE | Conversion of Hierarchy Nodes - SID: InfoObject Activity Typ | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
13 | /B631/KCOORDER | Conversion of Hierarchy Nodes - SID: InfoObject Order | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
14 | /B631/KCOSTCNTR | Conversion of Hierarchy Nodes - SID: InfoObject Cost Center | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
15 | /B631/KCOSTELMT | Conversion of Hierarchy Nodes - SID: InfoObject Cost Element | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
16 | /B631/KPLANT | Conversion of Hierarchy Nodes - SID: InfoObject Plant | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
17 | /B631/KPROFTCTR | Conversion of Hierarchy Nodes - SID: InfoObject Profit Cente | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
18 | /B631/KWBSELMT | Conversion of Hierarchy Nodes - SID: InfoObject WBS Element | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
19 | /BI0/IBUCKET | SID Structure of Hierarchies: InfoObject Directory of Precal | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
20 | /BI0/ICALMONTH | SID Structure of Hierarchies: InfoObject Calendar Year/Month | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
21 | /BI0/ICALMONTH2 | SID Structure of Hierarchies: InfoObject Calendar month | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
22 | /BI0/IDATE | SID Structure of Hierarchies: InfoObject Date | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
23 | /BI0/IFISCPER | SID Structure of Hierarchies: InfoObject Fiscal year/period | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
24 | /BI0/IHALFYEAR1 | SID Structure of Hierarchies: InfoObject Halfyear | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
25 | /BI0/IINFOPROV | SID Structure of Hierarchies: InfoObject InfoProvider | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
26 | /BI0/IIOBJNM | SID Structure of Hierarchies: InfoObject InfoObject | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
27 | /BI0/IRSPL_ORG | SID Structure of Hierarchies: InfoObject Area of Responsibil | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
28 | /BI0/IRSTT_EID | SID Structure of Hierarchies: InfoObject Error ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
29 | /BI0/IRSTT_FTPC | SID Structure of Hierarchies: InfoObject Function Subject | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
30 | /BI0/IRSTT_FUNC | SID Structure of Hierarchies: InfoObject Functions | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
31 | /BI0/IRSTT_IONM | SID Structure of Hierarchies: InfoObject InfoObject | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
32 | /BI0/IRSTT_IPBZM | SID Structure of Hierarchies: InfoObject RTM for Non-Cum. | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
33 | /BI0/IRSTT_IPNM | SID Structure of Hierarchies: InfoObject InfoProvider Name | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
34 | /BI0/IRSTT_JID | SID Structure of Hierarchies: InfoObject Job ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
35 | /BI0/IRSTT_OBJNM | SID Structure of Hierarchies: InfoObject Object Name | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
36 | /BI0/IRSTT_PID | SID Structure of Hierarchies: InfoObject Trace Package ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
37 | /BI0/IRSTT_PVAR | SID Structure of Hierarchies: InfoObject Play Variant | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
38 | /BI0/IRSTT_QYNM | SID Structure of Hierarchies: InfoObject Query Name | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
39 | /BI0/IRSTT_RQID | SID Structure of Hierarchies: InfoObject Test Request | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
40 | /BI0/IRSTT_RVAR | SID Structure of Hierarchies: InfoObject Ref. Data Variant | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
41 | /BI0/IRSTT_SAPCP | SID Structure of Hierarchies: InfoObject SAP Component | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
42 | /BI0/IRSTT_SVARI | SID Structure of Hierarchies: InfoObject Selection Variant | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
43 | /BI0/IRSTT_TID | SID Structure of Hierarchies: InfoObject Trace ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
44 | /BI0/IRSTT_TLAY | SID Structure of Hierarchies: InfoObject Trace Layer | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
45 | /BI0/IRSTT_TOTYP | SID Structure of Hierarchies: InfoObject Object Type (Transp | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
46 | /BI0/IRSTT_TRANR | SID Structure of Hierarchies: InfoObject Transport Request | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
47 | /BI0/IRSTT_TRTGT | SID Structure of Hierarchies: InfoObject Transport Target | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
48 | /BI0/IRSTT_USER | SID Structure of Hierarchies: InfoObject Trace User | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
49 | /BI0/ITCAIFAREA | SID Structure of Hierarchies: InfoObject InfoArea Analys. Au | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
50 | /BI0/ITCTAPPL | SID Structure of Hierarchies: InfoObject Appl. Component | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
51 | /BI0/ITCTBWOBJCT | SID Structure of Hierarchies: InfoObject BI Object | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
52 | /BI0/ITCTIFAREA | SID Structure of Hierarchies: InfoObject InfoArea | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
53 | /BI0/ITCTMDXFC | SID Structure of Hierarchies: InfoObject MDX Functions | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
54 | /BI0/ITCTPRCSCHN | SID Structure of Hierarchies: InfoObject Process Chain ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
55 | /BI0/ITCTQUERID | SID Structure of Hierarchies: InfoObject Query (UID) | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
56 | /BI0/ITCTSOURSYS | SID Structure of Hierarchies: InfoObject Source System | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
57 | /BI0/ITCTSTATEVT | SID Structure of Hierarchies: InfoObject Statistics Event | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
58 | /BI0/ITCTSYSID | SID Structure of Hierarchies: InfoObject BW System | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
59 | /BI0/ITCTUSERNM | SID Structure of Hierarchies: InfoObject User | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
60 | /BI0/ITCTUSRNM | SID Structure of Hierarchies: InfoObject User ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
61 | /BI0/KBUCKET | Conversion of Hierarchy Nodes - SID: InfoObject Directory of | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
62 | /BI0/KCALMONTH | Conversion of Hierarchy Nodes - SID: InfoObject Calendar Yea | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
63 | /BI0/KCALMONTH2 | Conversion of Hierarchy Nodes - SID: InfoObject Calendar mon | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
64 | /BI0/KDATE | Conversion of Hierarchy Nodes - SID: InfoObject Date | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
65 | /BI0/KFISCPER | Conversion of Hierarchy Nodes - SID: InfoObject Fiscal year/ | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
66 | /BI0/KHALFYEAR1 | Conversion of Hierarchy Nodes - SID: InfoObject Halfyear | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
67 | /BI0/KINFOPROV | Conversion of Hierarchy Nodes - SID: InfoObject InfoProvider | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
68 | /BI0/KIOBJNM | Conversion of Hierarchy Nodes - SID: InfoObject InfoObject | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
69 | /BI0/KRSPL_ORG | Conversion of Hierarchy Nodes - SID: InfoObject Area of Resp | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
70 | /BI0/KRSTT_EID | Conversion of Hierarchy Nodes - SID: InfoObject Error ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
71 | /BI0/KRSTT_FTPC | Conversion of Hierarchy Nodes - SID: InfoObject Function Sub | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
72 | /BI0/KRSTT_FUNC | Conversion of Hierarchy Nodes - SID: InfoObject Functions | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
73 | /BI0/KRSTT_IONM | Conversion of Hierarchy Nodes - SID: InfoObject InfoObject | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
74 | /BI0/KRSTT_IPBZM | Conversion of Hierarchy Nodes - SID: InfoObject RTM for Non- | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
75 | /BI0/KRSTT_IPNM | Conversion of Hierarchy Nodes - SID: InfoObject InfoProvider | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
76 | /BI0/KRSTT_JID | Conversion of Hierarchy Nodes - SID: InfoObject Job ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
77 | /BI0/KRSTT_OBJNM | Conversion of Hierarchy Nodes - SID: InfoObject Object Name | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
78 | /BI0/KRSTT_PID | Conversion of Hierarchy Nodes - SID: InfoObject Trace Packag | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
79 | /BI0/KRSTT_PVAR | Conversion of Hierarchy Nodes - SID: InfoObject Play Variant | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
80 | /BI0/KRSTT_QYNM | Conversion of Hierarchy Nodes - SID: InfoObject Query Name | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
81 | /BI0/KRSTT_RQID | Conversion of Hierarchy Nodes - SID: InfoObject Test Request | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
82 | /BI0/KRSTT_RVAR | Conversion of Hierarchy Nodes - SID: InfoObject Ref. Data Va | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
83 | /BI0/KRSTT_SAPCP | Conversion of Hierarchy Nodes - SID: InfoObject SAP Componen | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
84 | /BI0/KRSTT_SVARI | Conversion of Hierarchy Nodes - SID: InfoObject Selection Va | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
85 | /BI0/KRSTT_TID | Conversion of Hierarchy Nodes - SID: InfoObject Trace ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
86 | /BI0/KRSTT_TLAY | Conversion of Hierarchy Nodes - SID: InfoObject Trace Layer | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
87 | /BI0/KRSTT_TOTYP | Conversion of Hierarchy Nodes - SID: InfoObject Object Type | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
88 | /BI0/KRSTT_TRANR | Conversion of Hierarchy Nodes - SID: InfoObject Transport Re | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
89 | /BI0/KRSTT_TRTGT | Conversion of Hierarchy Nodes - SID: InfoObject Transport Ta | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
90 | /BI0/KRSTT_USER | Conversion of Hierarchy Nodes - SID: InfoObject Trace User | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
91 | /BI0/KTCAIFAREA | Conversion of Hierarchy Nodes - SID: InfoObject InfoArea Ana | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
92 | /BI0/KTCTAPPL | Conversion of Hierarchy Nodes - SID: InfoObject Appl. Compon | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
93 | /BI0/KTCTBWOBJCT | Conversion of Hierarchy Nodes - SID: InfoObject BI Object | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
94 | /BI0/KTCTIFAREA | Conversion of Hierarchy Nodes - SID: InfoObject InfoArea | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
95 | /BI0/KTCTMDXFC | Conversion of Hierarchy Nodes - SID: InfoObject MDX Function | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
96 | /BI0/KTCTPRCSCHN | Conversion of Hierarchy Nodes - SID: InfoObject Process Chai | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
97 | /BI0/KTCTQUERID | Conversion of Hierarchy Nodes - SID: InfoObject Query (UID) | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
98 | /BI0/KTCTSOURSYS | Conversion of Hierarchy Nodes - SID: InfoObject Source Syste | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
99 | /BI0/KTCTSTATEVT | Conversion of Hierarchy Nodes - SID: InfoObject Statistics E | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
100 | /BI0/KTCTSYSID | Conversion of Hierarchy Nodes - SID: InfoObject BW System | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
101 | /BI0/KTCTUSERNM | Conversion of Hierarchy Nodes - SID: InfoObject User | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
102 | /BI0/KTCTUSRNM | Conversion of Hierarchy Nodes - SID: InfoObject User ID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
103 | RSDB2A_STA_HIE | DB2 Accelerator: hierarchy status table | 4 | HIESID | Master data ID | int | 10 | 0 | | |
104 | RSDMHSITAB740 | Model table: Conversion of hierarchy nodes - SID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
105 | RSECHIE_STRING | Status of Authorization Hierarchies | 5 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
106 | RSRHINTAB_OLAP_S | Hierarchy interval for the OLAP processor | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
TOPMetadata Repository |
107 | RSDMHSITAB | Obsolete from APOLLO ->RSDMHSITABNEW | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
108 | RSDMHSITABNEW | Model table: Conversion of hierarchy nodes - SID | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
109 | RSDMHSITABTHJ | Model Table: Conversion Hierarchy Nodes - SID (THJ) | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
110 | RSDMINCTAB | Model table: SID structure of the hierarchies of a charact. | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
TOPOLAP Technology |
111 | RSDDAGGRCOMP | Description of the aggregates | 6 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
112 | RSDDSTATAGGRDEF | Statistics data OLAP: Navigation step / aggregate definition | 9 | HIESID | Master data ID | int | 10 | 0 | | |
113 | RSDDTPS_HIER_IDX | Polestar Hierarchy Indexes | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
114 | RSDDTPS_HIER_IP | Assignment of Hiers to InfoProvider/InfoObject Combination | 3 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
115 | RSDRHLRUBUFFER | LRU-Buffer for the Hierarchy Processing | 1 | HIESID | Master data ID | int | 10 | 0 | | |
116 | RSDRHTREXBUFFER | LRU-Buffer for the Hierarchy Processing | 1 | HIESID | Master data ID | int | 10 | 0 | | |
117 | RSECHIE | Status of Authorization Hierarchies | 4 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
118 | RSECHIE_CL | Authorization Hierarchies Changes Change Log | 8 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
119 | RSRHIEDIR_OLAP | OLAP Relevant Information for the Hierarchies | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
120 | RSRHIEDIR_SHORT | Structure for Appropriate Lock Object for Hierarchies | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
121 | RSRHIEDIR_TIMDEP | Time Intervals with Time-Dependent Hierarchies | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
122 | RSRHINTAB_OLAP | (obsolete) Hierarchy interval for the OLAP /XPRA -> 7.40 rel | 1 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |
123 | RSSAUTHHIER | Definition of the Authorizations for Hierarchies | 2 | HIESID | SID for Hierarchy ID | int | 10 | 0 | | |