SAP ABAP Table RSSH_SX_HTABS (Structure Hierarchy Tables)

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	INTTAB	Structure
Structure	RSSH_SX_HTABS	Table Relationship Diagram
Short Description	Structure Hierarchy Tables

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A