SAP ABAP Table RSHIEDIR (Hierarchy Catalog)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DBA (Application Component) Data Basis
     ⤷ RSSH (Package) BW: Hierarchy Processing - General

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	RSHIEDIR	Table Relationship Diagram
Short Description	Hierarchy Catalog

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	HIEID	☑	RSHIEID	SYSUUID_25	CHAR	25	0	Internal hierarchy ID (unique ID)
2	OBJVERS	☑	RSOBJVERS	RSOBJVERS	CHAR	1	0	Object version
3	HIETYPE	☐	RSHITYPE	RSHIERTYPE	CHAR	1	0	BW Hierarchy Types
4	HIENM	☐	RSHIENM	RSHIENM	CHAR	30	0	Hierarchy name
5	VERSION	☐	RSVERSION	RSVERSION	CHAR	3	0	Hierarchy version
6	DATETO	☐	RSDATETO	DATUM	DATS	8	0	Valid-to date
7	IOBJNM	☐	RSIOBJNM	RSIOBJNM	CHAR	30	0	InfoObject	RSDIOBJ
8	DATEFROM	☐	RSDATEFROM	DATUM	DATS	8	0	Valid-From Date
9	LOGSYS	☐	RSSLOGSYS	LOGSYS	CHAR	10	0	Source system	TBDLS
10	REQUEST	☐	RSREQUNR	RSREQUNR	CHAR	30	0	Request number for the data transfer
11	OBJSTAT	☐	RSOBJSTAT	RSOBJSTAT	CHAR	3	0	Object Status
12	ACTIVFL	☐	RSACTIVFL	XFELD	CHAR	1	0	Active and revised version do not agree
13	CONTREL	☐	RSCONTREL	CHAR6	CHAR	6	0	Content release
14	OWNER	☐	RSOWNER	XUBNAME	CHAR	12	0	Owner (Person Responsible)	*
15	DBPART	☐	RSDBPART	CHAR16	CHAR	16	0	DB partition
16	HIENDTFL	☐	RSHIENDTFL	XFELD	CHAR	1	0	Hierarchy structure is time-dependent
17	NORESTNODES	☐	RSHIERNOREST	RSBOOL	CHAR	1	0	Suppression of unassigned nodes
18	STARTLEVEL	☐	RSSTARTLEVEL	RSTLEVEL	NUMC	2	0	Level on which the hierarchy is first expanded
19	NUMBERLEVEL	☐	RSNUMBERLEV	RSTLEVEL	NUMC	2	0	Number of levels in a hierarchy
20	MAXNODEID	☐	RSMAXNODEID	RSHIENODID	NUMC	8	0	Largest Node ID of Hierarchy
21	LEVELTABTYPE	☐	RSLEVELTABTYPE	RSLEVELTABTYPE	NUMC	1	0	Level table type for hierarchies in BW
22	NODEPOSITION	☐	RRXHRYNODEPOSIT	RRXHRYNODEPOSIT	CHAR	1	0	Positions of the nodes in reference to their leaves
23	ALEAFNODSP	☐	RSSHCRLEAFDSP	RSSHCRLEAFDSP	CHAR	1	0	Do Not Display Leaves for Inner-Nodes in the Query
24	ALEAFNODCH	☐	RSSHCLDSPCH	RSSHCLDSPCH	CHAR	1	0	Display for Generated Leaves Cannot Be Changed
25	.INCLUDE	☐				0	0	Include: Last changed by, time stamp in internal format
26	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	USR02
27	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
28	CONSISTENT	☐	RSCHECKED2	XFELD	CHAR	1	0	Indicator: hierarchy is consistent
29	SIGNCHEXIST	☐	RSSHSIGNCHEXIST	RSSHSIGNCHEXIST	CHAR	1	0	Reverse Sign Set for at Least one Node
30	LINKEXIST	☐	RSSHLINKEXIST	RSBOOL	CHAR	1	0	Link Nodes Exist
31	ROOTID	☐	RSSHROOTID	RSHIENODID	NUMC	8	0	Hierarchy Root Node Id
32	INTERVALLEXIST	☐	RSRINTVLFL	RSBOOL	CHAR	1	0	Flag: Hierarchy contains intervals
33	HIERCLNM	☐	RRHICLNM	SEOCLSNAME	CHAR	30	0	Name of the Hierarchy Read Class
34	SOURCE_TIMESTMP	☐	RSSH_SOURCE_TIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp of Last Change to Data in Source
35	IS_REMOTE_HIER	☐	RSSH_IS_REMOTE_HIER	RS_BOOL	CHAR	1	0	Hierarchy Data Only Returned by Remote DTP (Indicator)
36	DTP_ID	☐	RSBKDTPNM	RSBKDTPNM	CHAR	30	0	Data Transfer Process ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RSHIEDIR	IOBJNM	RSDIOBJ	IOBJNM		CN
2	RSHIEDIR	LOGSYS	TBDLS	LOGSYS		CN
3	RSHIEDIR	TSTPNM	USR02	BNAME	KEY	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in