SAP ABAP Table ROOHIECAT (Additional Hierarchy Information for DS in Source System)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ BC-BW (Application Component) BW Service API
     ⤷ RSUM (Package) BW Service API: Metadata

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ROOHIECAT	Table Relationship Diagram
Short Description	Additional Hierarchy Information for DS in Source System

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
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	OLTPSOURCE	☑	ROOSOURCER	ROOSOURCED	CHAR	30	0	DataSource (OSOA/OSOD)	ROOSOURCE
2	OBJVERS	☑	ROOBJVERS	ROOBJVERS	CHAR	1	0	OLTP Source Version
3	TYPEHC	☐	ROOTYPEHC	RSHCLASS	CHAR	4	0	Hierarchy Class Type of a DataSource
4	DOMANM	☐	DOMNAME	DOMNAME	CHAR	30	0	Domain name	DD01L
5	ROLLNM	☐	ROLLNAME	ROLLNAME	CHAR	30	0	Data element (semantic domain)	DD04L
6	FHCATALOG	☐	ROHIEFNAME	FUNCNAME	CHAR	30	0	Function module for collecting hierarchies	TFDIR
7	.INCLUDE	☐				0	0	Include: Hierarchy control indicator for basic characters
8	HIETABFL	☐	RSHIETABFL	XFELD	CHAR	1	0	Characteristic with hierarchies
9	HIEVERFL	☐	RSHIEVERFL	XFELD	CHAR	1	0	Hierarchies can have several versions
10	HIENMTFL	☐	RSHIENMTFL	XFELD	CHAR	1	0	Hierarchy name is time-dependent
11	HIENDTFL	☐	RSHIENDTFL	XFELD	CHAR	1	0	Hierarchy structure is time-dependent
12	HIEINTFL	☐	RSHIEINTFL	XFELD	CHAR	1	0	Intervals permitted in hierarchy
13	.INCLUDE	☐				0	0	Segment Structures for Hierarchy Extraction
14	STRUC_HDR	☐	ROSTR_HDR	AS4TAB	CHAR	30	0	Extract Structure for Hierarchy Header	DD02L
15	STRUC_HDRT	☐	ROSTR_HDRT	AS4TAB	CHAR	30	0	Extract Stucture for Hierarchy Header Texts	DD02L
16	STRUC_NODE	☐	ROSTR_NODE	AS4TAB	CHAR	30	0	Extract Structure for Hierarchy Nodes	DD02L
17	STRUC_NODT	☐	ROSTR_NODT	AS4TAB	CHAR	30	0	Extract Structure for Hierarchy Node Texts	DD02L
18	STRUC_INTV	☐	ROSTR_INTV	AS4TAB	CHAR	30	0	Extract Structure for Hierarchy Node Intervals	DD02L

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROOHIECAT	DOMANM	DD01L	DOMNAME		1	CN
2	ROOHIECAT	FHCATALOG	TFDIR	FUNCNAME		1	CN
3	ROOHIECAT	OLTPSOURCE	ROOSOURCE	OLTPSOURCE	KEY	1	CN
4	ROOHIECAT	ROLLNM	DD04L	ROLLNAME		1	CN
5	ROOHIECAT	STRUC_HDR	DD02L	TABNAME	REF	C	CN
6	ROOHIECAT	STRUC_HDRT	DD02L	TABNAME	KEY	C	CN
7	ROOHIECAT	STRUC_INTV	DD02L	TABNAME	KEY	C	CN
8	ROOHIECAT	STRUC_NODE	DD02L	TABNAME	KEY	C	CN
9	ROOHIECAT	STRUC_NODT	DD02L	TABNAME	KEY	C	CN

History

Last changed by/on	SAP	20080415
SAP Release Created in