SAP ABAP Class CL_RSDRH_HIER_REST (Hierarchy Restriction)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSDRC (Package) Data Manager InfoProvider Read Access

Properties

Class	CL_RSDRH_HIER_REST
Short Description	Hierarchy Restriction
Super Class
Instantiability of a Class	0	Private
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSDRC	Data Manager InfoProvider Read Access
Created	20040517	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	IF_RSDRH_HIER_STORAGE	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
2	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RSD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
4	RSDD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
5	RSDRC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
6	RSDRH	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
7	RSDRS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
8	RSHI	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSDRH_HIER_REST has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_RSDRH_DBTAB_STORAGE	☐	20041209	Database Table as Hierarchy Storage
2	CL_RSDRH_HIER_CACHE	☐	20040518	Hierarchy Cache

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	N_R_STORAGE	Instance attribute	Public	☑	Object reference (TYPE REF TO)	IF_RSDRH_HIER_STORAGE		Hierachy storage object	20040518
2	N_S_REST	Instance attribute	Public	☑	Type reference (TYPE)	TN_S_HIER_REST		Hierarchy restriction	20040518
3	PS_ACCESS_ID	Static Attribute	Private	☐	Type reference (TYPE)	I	0	Access id for hierarchy resolution (needed for cleanup)	20050429
4	PS_PROGID	Static Attribute	Private	☐	Attribute reference (LIKE)	SY-REPID		Database Dependent Report Name	20040518
5	PS_R_STAT	Static Attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDD_STATDM_ACCESS		reference to dmstat access object	20100423

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_HIER_USAGE_STATS	Static method	Public	Method	Add hierachy usage info	20100811
2	ANALYZE_TABLE	Static method	Public	Method	Create Database statistics for a temporary table	20040525
3	BUILD_RETLEVEL_FROM_NODEDR	Static method	Public	Method		20120328
4	BUILD_SELFEMS	Static method	Private	Method	Build a bitstring with all existing femses of seldr	20050726
5	CLEANUP	Static method	Public	Method	Cleanup temporary tables after query execution	20040524
6	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20040524
7	CONVERT_LEAFS_EQUALS	Static method	Private	Method	Convert Hierarchy Restrictions with only Leafs into EQUALS	20040518
8	DELETE_ALL_FEMS_NE_0	Static method	Private	Method	Delete all FEMS > 0	20040518
9	GET_DBSYS_PROGRAM	Static method	Protected	Method	Get program name with database dependent forms	20040518
10	INVALIDATE_HIERARCHY	Static method	Public	Method	Invalidate all entries belonging to the specified hierarchy	20040527
11	PROCESS	Static method	Public	Method	Process Hier Restrictions inside seldr	20040517
12	PROCESS_DB	Static method	Private	Method	Process Hier Restrictions inside seldr	20050810
13	PROCESS_TREX	Static method	Private	Method	Process Hier Restrictions inside seldr	20050810
14	PROCESS_TREX_NEW	Static method	Private	Method	Process Hier Restrictions inside seldr	20080711
15	REMOVE_DUPL_TABLNM	Static method	Private	Method	Remove duplicate entries in c_t_tablnm	20050429
16	RESOLVE	Instance method	Protected	Method	Resolve Restriction	20040517
17	SET_STORAGE	Instance method	Protected	Method	sets the storage object for the hierarchy restriction	20040518

Events

Class CL_RSDRH_HIER_REST has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TN_SX_HIER	Public	See coding			20040518	BEGIN OF tn_sx_hier, chanm TYPE rsd_iobjnm, fems_0 TYPE rs_bool, viewnm TYPE rsd_tablnm, hier_unique TYPE rs_bool, t_rest TYPE rsdrh_t_rest, th_tablnm TYPE TN_TH_TABLNM, ts_nodedr TYPE sorted table of tn_s_nodedr with unique key fems sid, END OF tn_sx_hier
2	TN_S_FEMS_REST	Public	See coding		Restr. on Hier. Table to be included into FEMS selc restr.	20041209	BEGIN OF tn_s_fems_rest, fems TYPE rsidn4, "FEMS chanm TYPE rschanm, "Char. of seldr restriction tabnm TYPE rsd_tablnm, "Name of hierachy table/view fieldnm TYPE rsd_fieldnm, "column name of hier table/view value TYPE i, th_eqsid TYPE rrsi_ts_eqsid, "sorted table for equals END OF tn_s_fems_rest
3	TN_S_HIER_REST	Public	See coding		Hierarchy Restriction	20040517	begin of TN_S_HIER_REST, sid TYPE rssid, "SID of node to resolve returnlevel TYPE rrreturnlevel, readlevel TYPE rrnodelevel, hiesid TYPE rssid, sver TYPE rsrsver, "Version of hierarchy fems TYPE rsidn4, end of TN_S_HIER_REST
4	TN_S_NODEDR	Public	See coding			20041208	begin of tn_s_nodedr. include type rrselnode. types: fems type rsidn4, end of tn_s_nodedr
5	TN_TH_TABLNM	Public	See coding			20050429	TN_TH_TABLNM type HASHED TABLE of rsd_tablnm with unique key table_line initial size 0
6	TN_TSX_HIER	Public	See coding			20040518	tn_tsx_hier TYPE SORTED TABLE OF tn_sx_hier WITH UNIQUE KEY chanm
7	TN_TS_FEMS_REST	Public	See coding		Table of Restr. on Hier. Table to be included into FEMS	20041209	tn_ts_fems_rest TYPE SORTED TABLE OF tn_s_fems_rest WITH NON-UNIQUE KEY fems chanm
8	TN_TS_RETLEVEL	Public	See coding			20120328	tn_ts_retlevel TYPE SORTED TABLE OF rrreturnlevel WITH UNIQUE KEY table_line
9	TN_T_TABLNM	Public	See coding			20040629	TN_T_TABLNM type STANDARD TABLE of rsd_tablnm initial size 0
10	TP_S_FEMS	Private	See coding			20040518	begin of TP_S_FEMS, fems TYPE rrseldr-fems, cnt TYPE i, END OF tp_s_fems
11	TP_TS_FEMS	Private	See coding			20040518	tp_ts_fems TYPE SORTED TABLE OF tp_s_fems WITH UNIQUE KEY fems

Method Signatures

Method ADD_HIER_USAGE_STATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHANM	Call by reference	☐	Type reference (TYPE)	RSD_CHANM			20100811
2	Importing	I_DB	Call by reference	☑	Type reference (TYPE)	RS_BOOL		DB hier processing used	20100811
3	Importing	I_SX_NODEDR	Call by reference	☐	Type reference (TYPE)	RSDD_SX_SELDR-NODEDR		NODEDR part of SELDR	20100811
4	Importing	I_TREX_NEW	Call by reference	☑	Type reference (TYPE)	RS_BOOL		new trex hier used	20100811
5	Importing	I_TREX_OLD	Call by reference	☑	Type reference (TYPE)	RS_BOOL		old trex hier used	20100811

Method ADD_HIER_USAGE_STATS on class CL_RSDRH_HIER_REST has no exception.

Method ANALYZE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ROWS	Call by reference	☐	Type reference (TYPE)	I	-1	Number of Rows in Table	20040525
2	Importing	I_TABLNM	Call by reference	☐	Type reference (TYPE)	RSD_TABLNM		Table Name	20040525

Method ANALYZE_TABLE on class CL_RSDRH_HIER_REST has no exception.

Method BUILD_RETLEVEL_FROM_NODEDR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_TS_RETLEVEL	Call by reference	☐	Type reference (TYPE)	TN_TS_RETLEVEL			20120328
2	Importing	I_SX_NODEDR	Call by reference	☐	Type reference (TYPE)	RSDD_SX_NODEDR		Knoten Beschreibung	20120328
3	Importing	I_S_NODEDR	Call by reference	☐	Type reference (TYPE)	RSDD_S_NODEDR			20120328

Method BUILD_RETLEVEL_FROM_NODEDR on class CL_RSDRH_HIER_REST has no exception.

Method BUILD_SELFEMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TSX_SEL	Call by reference	☐	Type reference (TYPE)	RSDD_TSX_SELDR		Selection Table	20050726
2	Returning	R_SEL_FEMS	Value transfer	☐	Type reference (TYPE)	RSDR0_SX_SPLITPACK-SEL_FEMS		Bitstring with FEMSes of SELDR	20050726

Method BUILD_SELFEMS on class CL_RSDRH_HIER_REST has no exception.

Method CLEANUP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CONNECTION	Call by reference	☐	Type reference (TYPE)	DBCON_NAME	IF_RSDRH_HIER_STORAGE=>N_C_HIER_CON	Logischer Name einer Datenbankverbindung	20060825
2	Importing	I_TH_TABLNM	Call by reference	☑	Type reference (TYPE)	RSDRH_TH_TABLNM		Used temporary tables	20040524
3	Importing	I_TREX_HIER	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	TREX Hierachies used	20040524
4	Importing	I_T_TABLNM	Call by reference	☑	Type reference (TYPE)	RSDRH_T_TABLNM		Used temporary tables	20040524

Method CLEANUP on class CL_RSDRH_HIER_REST has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FEMS	Call by reference	☐	Type reference (TYPE)	RSIDN4		BW: Allgemeines Bezugsfeld für interne IDs	20041208
2	Importing	I_READLEVEL	Call by reference	☑	Type reference (TYPE)	I		Read Level	20040524
3	Importing	I_S_HIER	Call by reference	☑	Type reference (TYPE)	TN_S_HIER_REST		Hierarchy Restriction	20040524
4	Importing	I_S_NODEDR	Call by reference	☑	Type reference (TYPE)	RSDD_S_NODEDR		Node restriction	20040524

Method CONSTRUCTOR on class CL_RSDRH_HIER_REST has no exception.

Method CONVERT_LEAFS_EQUALS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TSX_SEL	Call by reference	☐	Type reference (TYPE)	RSDD_TSX_SELDR		Selektion an den Datamanager	20040518

Method CONVERT_LEAFS_EQUALS on class CL_RSDRH_HIER_REST has no exception.

Method DELETE_ALL_FEMS_NE_0 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_CHARET	Call by reference	☐	Type reference (TYPE)	RSDR0_TH_CHARET		Tabelle selektierter Merkmale	20040518
2	Changing	C_TSX_SEL	Call by reference	☐	Type reference (TYPE)	RSDD_TSX_SELDR		Selektion an den Datamanager	20040518

Method DELETE_ALL_FEMS_NE_0 on class CL_RSDRH_HIER_REST has no exception.

Method GET_DBSYS_PROGRAM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_PROGID	Value transfer	☐	Attribute reference (LIKE)	SY-REPID			20040524

Method GET_DBSYS_PROGRAM on class CL_RSDRH_HIER_REST has no exception.

Method INVALIDATE_HIERARCHY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_HIESID	Call by reference	☐	Type reference (TYPE)	RRHI_HIESID		Hierarchy to invalidate	20040527
2	Importing	I_NODESID	Call by reference	☑	Type reference (TYPE)	RSSID		Stammdaten ID	20050620
3	Importing	I_SVER	Call by reference	☑	Type reference (TYPE)	RRHI_SVER		Version of Hierarchy	20040527

Method INVALIDATE_HIERARCHY on class CL_RSDRH_HIER_REST has no exception.

Method PROCESS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_CHARET	Call by reference	☑	Type reference (TYPE)	RSDR0_TH_CHARET		Tabelle selektierter Merkmale	20040518
2	Changing	C_TSX_SEL	Call by reference	☐	Type reference (TYPE)	RSDD_TSX_SELDR		Selektion an den Datamanager	20040518
3	Exporting	E_TS_FEMS_REST	Call by reference	☐	Type reference (TYPE)	TN_TS_FEMS_REST			20041208
4	Exporting	E_T_SELT	Call by reference	☐	Type reference (TYPE)	RSDRC_T_SELT		Selt Table restrictions	20040518
5	Exporting	E_T_TABLNM	Call by reference	☐	Type reference (TYPE)	RSDRH_T_TABLNM		Table Name	20040518
6	Importing	I_COMMIT_ALLOWED	Value transfer	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Commit on primary connection allowed	20060602
7	Importing	I_NEWBIAHIER	Value transfer	☑	Type reference (TYPE)	RRNEWBIAHIER		New BIA Hierarchieimplementation	20080711
8	Importing	I_R_STAT	Call by reference	☑	Object reference (TYPE REF TO)	CL_RSDD_STATDM_ACCESS		Dm Statistik-Erfassung, Einzelzugriff	20100423
9	Importing	I_SHOW_TABLES	Value transfer	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Show hierarchy table content ?	20040518
10	Importing	I_TH_CHANM	Call by reference	☑	Type reference (TYPE)	RSD_TH_CHANM		Chanms where pred is in result set	20121017
11	Importing	I_TH_SFC	Call by reference	☑	Type reference (TYPE)	RSDD_TH_SFC		Tabelle der benötigten Merkmale usw.	20040518
12	Importing	I_TREX_HIER	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Hierarchy processing for TREX ?	20040524

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_NO_COMMIT	☐	Kein Commit bei Query-Bearbeitung erlaubt	20060602
2	CX_RSR_HIER_MEMBER_NOT_FOUND	☐	Hierarchie-Objekt (Knoten/Blatt) nicht gefunden	20040518
3	CX_RSR_HIER_NOT_FOUND	☐	Hierarchie nicht gefunden	20040518

Method PROCESS_DB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_CHARET	Call by reference	☑	Type reference (TYPE)	RSDR0_TH_CHARET		Tabelle selektierter Merkmale	20050810
2	Changing	C_TSX_SEL	Call by reference	☐	Type reference (TYPE)	RSDD_TSX_SELDR		Selektion an den Datamanager	20050810
3	Exporting	E_T_SELT	Call by reference	☐	Type reference (TYPE)	RSDRC_T_SELT		Selt Table restrictions	20050810
4	Exporting	E_T_TABLNM	Call by reference	☐	Type reference (TYPE)	RSDRH_T_TABLNM		Table Name	20050810
5	Importing	I_COMMIT_ALLOWED	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Commit on default connection allowed	20060602
6	Importing	I_SHOW_TABLES	Value transfer	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Show hierarchy table content ?	20050810
7	Importing	I_TH_SFC	Call by reference	☐	Type reference (TYPE)	RSDD_TH_SFC		Tabelle der benötigten Merkmale usw.	20050810

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_NO_COMMIT	☐	Kein Commit bei Query-Bearbeitung erlaubt	20060602
2	CX_RSR_HIER_MEMBER_NOT_FOUND	☐	Hierarchie-Objekt (Knoten/Blatt) nicht gefunden	20050810
3	CX_RSR_HIER_NOT_FOUND	☐	Hierarchie nicht gefunden	20050810

Method PROCESS_TREX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_CHARET	Call by reference	☑	Type reference (TYPE)	RSDR0_TH_CHARET		Tabelle selektierter Merkmale	20050810
2	Changing	C_TSX_SEL	Call by reference	☐	Type reference (TYPE)	RSDD_TSX_SELDR		Selektion an den Datamanager	20050810
3	Exporting	E_TS_FEMS_REST	Call by reference	☐	Type reference (TYPE)	TN_TS_FEMS_REST			20050810
4	Exporting	E_T_SELT	Call by reference	☐	Type reference (TYPE)	RSDRC_T_SELT		Selt Table restrictions	20050810
5	Exporting	E_T_TABLNM	Call by reference	☐	Type reference (TYPE)	RSDRH_T_TABLNM		Table Name	20050810
6	Importing	I_SHOW_TABLES	Value transfer	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Show hierarchy table content ?	20050810
7	Importing	I_TH_CHANM	Call by reference	☐	Type reference (TYPE)	RSD_TH_CHANM		Chanms where pred is in groupby	20121017
8	Importing	I_TH_SFC	Call by reference	☐	Type reference (TYPE)	RSDD_TH_SFC		Tabelle der benötigten Merkmale usw.	20050810

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_NO_COMMIT	☐	Kein Commit bei Query-Bearbeitung erlaubt	20060602
2	CX_RSR_HIER_MEMBER_NOT_FOUND	☐	Hierarchie-Objekt (Knoten/Blatt) nicht gefunden	20050810
3	CX_RSR_HIER_NOT_FOUND	☐	Hierarchie nicht gefunden	20050810

Method PROCESS_TREX_NEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_CHARET	Call by reference	☑	Type reference (TYPE)	RSDR0_TH_CHARET		Tabelle selektierter Merkmale	20080711
2	Changing	C_TSX_SEL	Call by reference	☐	Type reference (TYPE)	RSDD_TSX_SELDR		Selektion an den Datamanager	20080711
3	Exporting	E_TS_FEMS_REST	Call by reference	☐	Type reference (TYPE)	TN_TS_FEMS_REST			20080711
4	Exporting	E_T_SELT	Call by reference	☐	Type reference (TYPE)	RSDRC_T_SELT		Selt Table restrictions	20080711
5	Exporting	E_T_TABLNM	Call by reference	☐	Type reference (TYPE)	RSDRH_T_TABLNM		Table Name	20080711
6	Importing	I_SHOW_TABLES	Value transfer	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Show hierarchy table content ?	20080711
7	Importing	I_TH_CHANM	Call by reference	☐	Type reference (TYPE)	RSD_TH_CHANM		chanms where pred is in groupby (alt to sfc)	20121017
8	Importing	I_TH_SFC	Call by reference	☐	Type reference (TYPE)	RSDD_TH_SFC		Tabelle der benötigten Merkmale usw.	20080711

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_NO_COMMIT	☐	Kein Commit bei Query-Bearbeitung erlaubt	20080711
2	CX_RSR_HIER_MEMBER_NOT_FOUND	☐	Hierarchie-Objekt (Knoten/Blatt) nicht gefunden	20080711
3	CX_RSR_HIER_NOT_FOUND	☐	Hierarchie nicht gefunden	20080711

Method REMOVE_DUPL_TABLNM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_T_TABLNM	Call by reference	☐	Type reference (TYPE)	RSDRH_T_TABLNM			20050429

Method REMOVE_DUPL_TABLNM on class CL_RSDRH_HIER_REST has no exception.

Method RESOLVE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_STORAGE	Call by reference	☐	Object reference (TYPE REF TO)	IF_RSDRH_HIER_STORAGE		Storage for a resolved hierachy restriction	20040628
2	Importing	I_TIMESTMP	Call by reference	☑	Type reference (TYPE)	RSTIMESTMP		Timestamp of hierarchy	20040518

#	Exception	Resumable	Description	Created on
1	CX_RSR_HIER_MEMBER_NOT_FOUND	☐	Hierarchie-Objekt (Knoten/Blatt) nicht gefunden	20040518
2	CX_RSR_HIER_NOT_FOUND	☐	Hierarchie nicht gefunden	20040518

Method SET_STORAGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_STORAGE	Call by reference	☐	Object reference (TYPE REF TO)	IF_RSDRH_HIER_STORAGE		Storage for a resolved hierachy restriction	20040518

Method SET_STORAGE on class CL_RSDRH_HIER_REST has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	400