SAP ABAP Class CL_RSDRI_DS_ACCESS (Read Access to DataStore for Extraction)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DBA (Application Component) Data Basis
     ⤷ RSDRI_DBA (Package) Data Manager InfoCube Access

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDRI_DS_ACCESS	Read Access to Datastore and or Archive for Extraction	20070814

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSDRI_FBDS_ACCESS	Read Access to field-based DataStore for Extraction	20130716

Properties

Class	CL_RSDRI_DS_ACCESS
Short Description	Read Access to DataStore for Extraction
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	RSDRI_DBA	Data Manager InfoCube Access
Created	20070204	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	IF_RSD_INFOPROV	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	RSDRS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_RSDRI_DS_ACCESS	☐	☐	Read Access to Datastore and or Archive for Extraction	20070814

Friends

Class CL_RSDRI_DS_ACCESS has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_USE_ARCHIVE	Instance attribute	Public	☐	Attribute reference (LIKE)				20071031
2	N_SAVE_TC	Instance attribute	Public	☐	Type reference (TYPE)	RS_BOOL		Save Test Case	20070313
3	N_T_MSG	Instance attribute	Public	☑	Type reference (TYPE)	RS_T_MSG		Warning messages that occurred	20070814
4	P_DATASTORE	Instance attribute	Protected	☐	Type reference (TYPE)	RSINFOPROV		InfoProvider	20070313
5	P_ODS_TABLNM	Instance attribute	Protected	☐	Type reference (TYPE)	TABNAME		Table Name of ODS Table	20070313
6	P_REQ_TMPTAB	Instance attribute	Protected	☐	Type reference (TYPE)	TABNAME		Table of requests to be extracted	20111213
7	P_R_SQL_QUERY	Instance attribute	Protected	☐	Object reference (TYPE REF TO)	CL_RSDRS_SQL_QUERY		Reference to SQL Query Object	20070313
8	P_SINGLE_REQUEST	Instance attribute	Protected	☐	Type reference (TYPE)	RS_BOOL		Boolean	20111017
9	P_SX_QDEF	Instance attribute	Protected	☐	Type reference (TYPE)	TN_SX_QDEF		Context of Extraction Query	20070313
10	P_SX_QUERY	Instance attribute	Protected	☐	Type reference (TYPE)	RSDRS_SX_QUERY		SQL Statement Representation	20070313
11	P_S_DTA	Instance attribute	Protected	☐	Type reference (TYPE)	RSD_S_DTA		Data of ODS object	20070313
12	P_TC_NO	Instance attribute	Protected	☐	Type reference (TYPE)	I		Test Case Number	20070313
13	P_TH_ALIAS_CNT	Instance attribute	Protected	☐	Type reference (TYPE)	TP_TH_ALIAS_CNT		Alias Counter Table	20070313
14	P_TH_CHA_ATTR	Instance attribute	Protected	☐	Type reference (TYPE)	RSD_TH_CHANM		Checked attribute carrying characteristics	20070718
15	P_TS_ALIAS	Instance attribute	Protected	☐	Type reference (TYPE)	TP_TS_ALIAS		Table with Used Alias Entries	20070313
16	P_TS_DTA_PRO	Instance attribute	Private	☐	Type reference (TYPE)	IF_RSD_INFOPROV=>NT_TS_DTA_PRO		COB_PRO Information of ODS object	20130116

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_JOIN_ENTRY	Instance method	Protected	Method	Create Join Entry for Specified Characteristic	20070313
2	AUTHORITY_CHECK	Instance method	Protected	Method	Authority Check for Provider and Access	20070313
3	BUILD_ATR	Instance method	Protected	Method	Put Navigational Attribute Key into sx_Query	20070313
4	BUILD_CHA	Instance method	Protected	Method	Build Key Entry from SFC for sx_Query	20070313
5	BUILD_SX_QUERY	Instance method	Protected	Method	Build Required sx_Query Structure	20070313
6	BUILD_WHERE_FROM_RANGE	Instance method	Protected	Method	Build WHERE Conditions from SELDR	20070313
7	CHECK_LOGICALLY_DELETED	Instance method	Private	Method	checks the request is logically deleted or not	20130814
8	CLEANUP	Instance method	Protected	Method	Drop Temporary Tables Again	20070313
9	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20070313
10	CORRECT_LEFTOUTER_WHERE	Instance method	Protected	Method	correct the where conditions of all subqueries	20070718
11	CREATE_ORDERBY_TECH_KEY	Instance method	Protected	Method	Build OrderBy According to Technical Columns of OSD Object	20070313
12	DEFINE	Instance method	Public	Method	Read Data from InfoProvider	20070814
13	EXTRACT	Instance method	Public	Method	Read and Return the Data	20070814
14	FACTORY	Static method	Public	Method	returns an instance by calling the right constuctor	20130724
15	GET_ALIAS	Instance method	Protected	Method	Find Alias for Table	20070313
16	GET_DTA_INFO	Instance method	Protected	Method	Gets the Metadata Info About InfoObjects	20070313
17	GET_EXTRACTION_SQL	Instance method	Public	Method	returns the sql-statement needed for extraction	20130218
18	MERGE_WHERE_CONDITIONS	Instance method	Protected	Method	Merge WHERE FROM SELT with WHERE FROM SELC	20070313
19	PROCESS_SFC_WITH_ATR	Instance method	Protected	Method	Convert SFC Entries and Nav. Attributes to sx_query	20070313
20	PROCESS_SFK	Instance method	Protected	Method	Put Key Figures into sx_query (SQL Statement)	20070313
21	_BUILD_DSO_DELR_SUBQUERY	Instance method	Protected	Method	Create subquery for deleted DSO requests	20100827
22	_BUILD_JOIN_FOR_DEL_REQUESTS	Instance method	Protected	Method	Creates JOIN to filter deleted requests from query	20100827
23	__BUILD_DSO_DELR_WHERE	Instance method	Protected	Method	Build Where condition	20100827

Events

Class CL_RSDRI_DS_ACCESS has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TN_SX_QDEF	Public	See coding			20070313	BEGIN OF tn_sx_qdef, th_sfc TYPE rsdri_th_sfc, th_sfk TYPE rsdri_th_sfk, t_range TYPE rsdri_t_range, tx_rangetab TYPE rsdri_tx_rangetab, t_requid TYPE rsdr0_t_requid, keydate TYPE rsdri_refdate, maxrows TYPE i, use_db_aggr TYPE rs_bool, table_type TYPE rsdodstabt, END OF tn_sx_qdef
2	TP_S_ALIAS	Protected	See coding		Alias Entry for Characteristic Inside a Table	20070313	BEGIN OF TP_S_ALIAS, tablnm TYPE rsd_tablnm, "Tablename chanm TYPE rsd_iobjnm, "Characteristic Name aliasnm TYPE rsd_tablnm, "Alias Name END OF tp_s_alias
3	TP_S_ALIAS_CNT	Protected	See coding		Counter for Alias Entries	20070313	BEGIN OF TP_S_ALIAS_CNT, tabtp TYPE rsd_tablnm, "Table Type alias TYPE NUMC3, "Alias counter END OF tp_s_alias_cnt
4	TP_TH_ALIAS_CNT	Protected	See coding		Table with Alias Counters	20070313	tp_th_alias_cnt TYPE HASHED TABLE OF tp_s_alias_cnt WITH UNIQUE KEY tabtp initial size 0
5	TP_TS_ALIAS	Protected	See coding		Table with Used Alias Entries	20070313	tp_ts_alias TYPE SORTED TABLE OF tp_s_alias WITH NON-UNIQUE KEY tablnm initial size 0

Method Signatures

Method ADD_JOIN_ENTRY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_CHA_ALIASNM	Call by reference	☐	Type reference (TYPE)	RSD_TABLNM		Alias Name of Characteristic	20070313
2	Exporting	E_CHA_TABLNM	Call by reference	☐	Type reference (TYPE)	RSD_TABLNM		Table Name of Characteristic	20070313
3	Importing	I_ATRTIMFL	Call by reference	☐	Type reference (TYPE)	RSDCOBPRO-ATRTIMFL		Attributes time dependent ?	20070313
4	Importing	I_CHANM	Call by reference	☐	Type reference (TYPE)	RSD_IOBJNM		Name of Infoobject to add join for	20070313
5	Importing	I_LEFTOUTER	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Lefot outer Join ?	20070718
6	Importing	I_S_DTA_PRO	Call by reference	☐	Type reference (TYPE)	RSD_S_DTA_PRO		DTA_PRO entry for Characteristic	20070313
7	Importing	I_TABTP	Call by reference	☐	Type reference (TYPE)	RSDRS_TABTP		Table Type of Master Data Table	20070313

Method ADD_JOIN_ENTRY on class CL_RSDRI_DS_ACCESS has no exception.

Method AUTHORITY_CHECK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_AUTHORITY_CHECK	Call by reference	☐	Type reference (TYPE)	RSDRI_AUTHCHK		DM: Art der Berechtigungsprüfung	20070313

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_ILLEGAL_INPUT_RANGE	☐	Fehler in range (RSDRI...)	20070313
2	CX_RSDRC_ILLEGAL_INPUT_SFC	☐	Fehler in sfc (RSDRI...)	20070313
3	CX_RSDRC_ILLEGAL_INPUT_SFK	☐	Fehler in sfk (RSDRI...)	20070313
4	CX_RSDRC_NOT_AUTHORIZED	☐	Keine Berechtigung für Infoprov	20070313
5	CX_RS_MSG	☐	BW Exception mit generischer Nachricht (keine spez. Attrib.)	20070313

Method BUILD_ATR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_LEFTOUTER	Call by reference	☐	Type reference (TYPE)	RS_BOOL		left outer join needed ?	20070718
2	Importing	I_S_SFC	Call by reference	☐	Type reference (TYPE)	RSDRI_S_SFC		sfc entry of navigational attribute	20070313

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_ILLEGAL_INPUT_SFC	☐	Fehler in sfc (RSDRI...)	20070313

Method BUILD_CHA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_SFC	Call by reference	☐	Type reference (TYPE)	RSDRI_S_SFC		Single SFC Entry	20070313

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_ILLEGAL_INPUT_SFC	☐	Fehler in sfc (RSDRI...)	20070313

Method BUILD_SX_QUERY Signature

Method BUILD_SX_QUERY on class CL_RSDRI_DS_ACCESS has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_INPUT_ERROR	☐	Fehler in Eingabeparametern (RSDRI...)	20070313

Method BUILD_WHERE_FROM_RANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_WHERE		Where conditions built	20111018

Method BUILD_WHERE_FROM_RANGE on class CL_RSDRI_DS_ACCESS has no exception.

Method CHECK_LOGICALLY_DELETED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_LOGICALLY_DELETED_ALL	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Boolean	20130814

Method CHECK_LOGICALLY_DELETED on class CL_RSDRI_DS_ACCESS has no exception.

Method CLEANUP Signature

Method CLEANUP on class CL_RSDRI_DS_ACCESS has no parameter.
Method CLEANUP on class CL_RSDRI_DS_ACCESS has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DATASTORE	Call by reference	☐	Type reference (TYPE)	RSINFOPROV		InfoProvider	20070313

Method CONSTRUCTOR on class CL_RSDRI_DS_ACCESS has no exception.

Method CORRECT_LEFTOUTER_WHERE Signature

Method CORRECT_LEFTOUTER_WHERE on class CL_RSDRI_DS_ACCESS has no parameter.
Method CORRECT_LEFTOUTER_WHERE on class CL_RSDRI_DS_ACCESS has no exception.

Method CREATE_ORDERBY_TECH_KEY Signature

Method CREATE_ORDERBY_TECH_KEY on class CL_RSDRI_DS_ACCESS has no parameter.
Method CREATE_ORDERBY_TECH_KEY on class CL_RSDRI_DS_ACCESS has no exception.

Method DEFINE Signature

Method DEFINE on class CL_RSDRI_DS_ACCESS has no parameter.
Method DEFINE on class CL_RSDRI_DS_ACCESS has no exception.

Method EXTRACT Signature

Method EXTRACT on class CL_RSDRI_DS_ACCESS has no parameter.
Method EXTRACT on class CL_RSDRI_DS_ACCESS has no exception.

Method FACTORY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_R_DS_EXTRACTOR	Value transfer	☐	Object reference (TYPE REF TO)	CL_RSDRI_DS_ACCESS		Read Access to DataStore for Extraction	20130724
2	Importing	I_DATASTORE	Call by reference	☐	Type reference (TYPE)	RSINFOPROV		InfoProvider	20130724

Method FACTORY on class CL_RSDRI_DS_ACCESS has no exception.

Method GET_ALIAS 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_IOBJNM		character to search for	20070313
2	Importing	I_TABLNM	Call by reference	☐	Type reference (TYPE)	RSD_TABLNM		Name of table	20070313
3	Importing	I_TABTP	Call by reference	☐	Type reference (TYPE)	RSDRS_TABTP		Type of table	20070313
4	Returning	R_ALIAS	Value transfer	☐	Type reference (TYPE)	RSD_TABLNM		Alias for Table	20070313

Method GET_ALIAS on class CL_RSDRI_DS_ACCESS has no exception.

Method GET_DTA_INFO Signature

Method GET_DTA_INFO on class CL_RSDRI_DS_ACCESS has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RS_MSG	☐	BW Exception mit generischer Nachricht (keine spez. Attrib.)	20070313

Method GET_EXTRACTION_SQL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_SQL_STATEMENT	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE		SQL-statement for extraction	20130218

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20130218

Method MERGE_WHERE_CONDITIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_T_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_WHERE		Where conditions to append	20070313

Method MERGE_WHERE_CONDITIONS on class CL_RSDRI_DS_ACCESS has no exception.

Method PROCESS_SFC_WITH_ATR Signature

Method PROCESS_SFC_WITH_ATR on class CL_RSDRI_DS_ACCESS has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_ILLEGAL_INPUT_SFC	☐	Fehler in sfc (RSDRI...)	20070313

Method PROCESS_SFK Signature

Method PROCESS_SFK on class CL_RSDRI_DS_ACCESS has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRC_ILLEGAL_INPUT_SFK	☐	Fehler in sfk (RSDRI...)	20070313

Method _BUILD_DSO_DELR_SUBQUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_SUBQUERY_ID	Value transfer	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID			20100827

Method _BUILD_DSO_DELR_SUBQUERY on class CL_RSDRI_DS_ACCESS has no exception.

Method _BUILD_JOIN_FOR_DEL_REQUESTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_SUBQUERY_ID	Value transfer	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID			20100827

Method _BUILD_JOIN_FOR_DEL_REQUESTS on class CL_RSDRI_DS_ACCESS has no exception.

Method __BUILD_DSO_DELR_WHERE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_WHERE			20111018

Method __BUILD_DSO_DELR_WHERE on class CL_RSDRI_DS_ACCESS has no exception.

History

Last changed by/on	SAP	20140121
SAP Release Created in	720