| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BI0/SHIENM | Master Data IDs: InfoObject Hierarchy Name | 1 | HIENM | Hierarchy Name | nvarchar | 30 | 0 | | |
2 | CNV_20100_CEFORM | CEFORMF records with rel. org. units + addit. VALUE field | 18 | HIENM | | nvarchar | 30 | 0 | | |
3 | RSBPCB_MEM_HIE | BPC: BPF Driver Dimension Hierarchy Member Item | 10 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
4 | RSBPCE_DAP_DIM | BPC: DAP Dimension & Hierarchy | 8 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPBusiness Planning |
5 | UPB_HI_REF | Planning Applucations: Reference to Hierarchy | 2 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
6 | UPB_YT_HIERARCHY | BW Hierarchies: Header Data | 4 | HIENM | Name of Hierarchy (Technical) | nvarchar | 30 | 0 | | |
TOPBusiness Planning and Simulation |
7 | UPC_NODES | Hierarchy Node | 4 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
8 | UPC_STEPS | Relations between Characteristics of a Planning Area | 6 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
9 | UPC_VAR_HIE | Variables - Hierarchies | 4 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
10 | UPC_VAR_HIE_SEL | Variables - Selections using Hierarchies | 6 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
11 | UPC_VAR_HIE_SELA | Variables - Selections using Hierarchies (Active Values) | 6 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
12 | UPP_DOC | Planning: Layout Builder Info about Document | 13 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
13 | UPS_TP_HIERARCHY | Connection Subplan-Hierarchy | 4 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
14 | UPX_DSRC_HEAD | UPX: Data Sources - Header | 5 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
TOPBW Service API |
15 | ROVERFIELH | Hierarchy using Test Fields in Verification Scenario | 2 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
16 | ROVERHIE | Hierarchies in Verification Scenario | 2 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
17 | ROVERHIET | Hierarchy Texts in Verification Scenario | 3 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPControlling |
18 | FCOMIPHIEDIR | Unique Ids for extracted Hierarchies | 4 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPData Basis |
19 | RSHIEDIR | Hierarchy Catalog | 4 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
20 | RSMDUCMUKHIER | UT Hierarchy: Identifying attributes for MUKs | 5 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPData Mining |
21 | RSDMTP_BAT_HRHDR | BW Hierarchy Creation - Hierarchy Header Details | 2 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPData Staging |
22 | RSHIEDONE | Selection table for Fields Scheduler | 5 | HIENM | Customer-Defined Hierarchy Name | nvarchar | 30 | 0 | | |
23 | RSLDPSEL | Selection table for fields scheduler | 18 | HIENM | Customer-Defined Hierarchy Name | nvarchar | 30 | 0 | | |
24 | RSLDPSELHIST | Selection Table for Fields of Scheduler - Changes/History | 19 | HIENM | Customer-Defined Hierarchy Name | nvarchar | 30 | 0 | | |
25 | RSLDPSELSH | Selection table for fields scheduler | 17 | HIENM | Customer-Defined Hierarchy Name | nvarchar | 30 | 0 | | |
26 | RSOSOHIE | Directory for Master Data Hierarchies | 4 | HIENM | Customer-Defined Hierarchy Name | nvarchar | 30 | 0 | | |
27 | RSOSOHIESH | Shadow Table: Hierarchy Information in BW | 4 | HIENM | Customer-Defined Hierarchy Name | nvarchar | 30 | 0 | | |
28 | RSOSOHIET | Directory for Master Data Hierarchies - Texts | 5 | HIENM | Customer-Defined Hierarchy Name | nvarchar | 30 | 0 | | |
29 | RSOSOHIETSH | Shadow Table: Hierarchy Information in BW | 5 | HIENM | Customer-Defined Hierarchy Name | nvarchar | 30 | 0 | | |
TOPEnd User Technology |
30 | RSRA_BP_OBJECTS | Parts of the Batch Printing Setting | 22 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
31 | RSRA_ER_DRILL | Drill Characteristics for the Exception Reporting Setting | 7 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
32 | RSVHSUSERSETA | Value help services user setting A segment | 3 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
33 | RSVHSUSERSETB1 | Value help services user settings List of display Attributes | 3 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
34 | RSVHSUSERSETB2 | Value help services user List of Favourites and History | 3 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
35 | RSVHSVALUESET | Value help services user setting A segment | 4 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
36 | RSZELTPROP | Element properties (settings) | 44 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
37 | RSZGLOBV | Global Variables in Reporting | 32 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
38 | RSZRANGE | Selection specification for an element | 20 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPInformation System |
39 | TCNDS | Structure overview - Project Info System | 6 | HIENM | Group Name | nvarchar | 15 | 0 | | |
TOPInteractive Drilldown Reporting |
40 | TRSTHV | BRST directory of hierarchies | 8 | HIENM | Name of hierarchy | nvarchar | 30 | 0 | | |
41 | TRSTHVT | BRST Texts for hierarchies | 9 | HIENM | Name of hierarchy | nvarchar | 30 | 0 | | |
42 | TRSTHV_VP | BRST Repository of Hierarchies - Virtual InfoProvider | 9 | HIENM | Name of hierarchy | nvarchar | 30 | 0 | | |
TOPOLAP Technology |
43 | RSDDAGGRCOMP | Description of the aggregates | 10 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
44 | RSDDTPS_HIER_HNM | Hierarchies for Use in Polestar | 3 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
45 | RSDDTPS_HIER_IP | Assignment of Hiers to InfoProvider/InfoObject Combination | 5 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
46 | RSSAUTHHIER | Definition of the Authorizations for Hierarchies | 4 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPOverhead Cost Controlling |
47 | BWOM_RHIER | BCT-CO: Report Row Hierarchies | 3 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
48 | BWOM_RHIERT | BCT-CO: Texts for Report Row Hierarchies | 4 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
49 | BWOM_RHIER_LINE | BCT-CO: Rows for Report Row Hierarchies | 3 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
50 | BWOM_RHIER_LINET | BCT-CO: Row Texts for Report Row Hierarchies | 4 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPPlanning |
51 | RSPLF_SRV_COND | Rule Condition in Planning Service | 15 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
52 | RSPLF_SRV_PS | Parameter Value (Selection Type) | 17 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
53 | RSPLS_CR_RANGE | Char.Relationship: Range (for example, for DataStore Object) | 15 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
54 | RSPLS_CR_STEPS | Relationships Between Characteristics in Basic InfoProvider | 7 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
55 | RSPLS_DS_RANGE | Data Slices: Selection | 15 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPPlant Maintenance |
56 | TEQUI_HIER | Definition of Hierarchies for Equipment | 2 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
57 | TEQUI_HIERT | Text Table for TEQUI_HIER | 2 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
58 | TFUNCT_LOC_HIER | Definition of Hierarchies for Functional Locations | 2 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
59 | TFUNCT_LOC_HIERT | Text Table for TFUNCT_LOC_HIER | 2 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
TOPProfitability Analysis |
60 | CEFORMF | CO: Definition of contents of element in row/col.str. | 17 | HIENM | Name of hierarchy | nvarchar | 30 | 0 | | |
TOPStakeholder Relationship Management |
61 | USS_BW_HIERARCHY | USTH0: BW Hierarchy | 3 | HIENM | Hierarchy | nvarchar | 30 | 0 | | |
TOPWithout Description |
62 | RSBCTCBHIENM | Content Broswer Hierarchy Technical Names | 1 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
63 | RSBCTCBHIENMT | Content Browser Hierarchy Texts | 1 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
64 | RSRBDIM | Dimension table including the print settings | 25 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
65 | RSROLEHIENM | List of available role hierarchies | 1 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
66 | RSROLEHIENMT | Texts for available role hierarchies | 1 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
67 | RSROLENODES | Nodes for role hierarchy | 1 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |
68 | RSROLENODEST | node texts for role hierarchy | 1 | HIENM | Hierarchy name | nvarchar | 30 | 0 | | |