SAP ABAP Class CL_RSDS_ACCESS_DB_EXTRACTOR (Extractor for DB Connect DataSources)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DST (Application Component) Data Staging
     ⤷ RSDS_ACCESS (Package) Access methods Apollo DataSource

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSDS_ACCESS_EXTRACTOR		20070612
2	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDS_ACCESS_EXTRACTOR	Extractor Interface	20070612
3	Interface implementation (CLASS c. INTERFACES i_ref)	IF_SERIALIZABLE_OBJECT	Serializable Object	20070911

Properties

Class	CL_RSDS_ACCESS_DB_EXTRACTOR
Short Description	Extractor for DB Connect DataSources
Super Class	CL_RSDS_ACCESS_EXTRACTOR
Instantiability of a Class	0	Private
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSDS_ACCESS	Access methods Apollo DataSource
Created	20070207	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ADBC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RSDS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RSTT0	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_RSDS_ACCESS_EXTRACTOR	☐	☐	Extractor Interface	20070612
2	IF_SERIALIZABLE_OBJECT	☐	☐	Serializable Object	20070911

Friends

#	Friend	Modeled only	Created on	Description
1	CL_RSDS_ACCESS_EXTRACTOR	☐	20070612

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_DATAPAKID	Instance attribute	Private	☐	Type reference (TYPE)	I			20070612
2	P_OBJNAME	Instance attribute	Private	☐	Type reference (TYPE)	RSDS_SX_DB_OBJECT-OBJNAME		DB Object Name	20070612
3	P_OBJSCHEMA	Instance attribute	Private	☐	Type reference (TYPE)	RSDS_SX_DB_OBJECT-OBJSCHEMA		DB Object Schema	20070612
4	P_R_DS_UNIVERSE	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDS_DATASOURCE_UNIVERSE		Dimension Model for DDIC Structure Fields	20070612
5	P_R_SQLCON	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20070612
6	P_R_SQLRES	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET		Resulting Set of an SQL Query	20070612
7	P_R_SQLSTMT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_STATEMENT		SQL statement	20070612
8	P_SQL_STATEMENT	Instance attribute	Public	☐	Type reference (TYPE)	STRING			20070612
9	P_S_DBCON	Instance attribute	Private	☐	Type reference (TYPE)	DBCON		Description of Database Connections	20070612
10	P_S_LOGSYSDB	Instance attribute	Private	☐	Type reference (TYPE)	RSLOGSYSDB		Extras for RSBASIDOC with DB Connect Source Systems	20130806
11	P_TH_FIELDMAP	Instance attribute	Private	☐	See coding				20070612
12	P_TMPNM	Instance attribute	Private	☐	Type reference (TYPE)	TABNAME		Table Name	20130806
13	P_T_CORRESPONDING_FIELDS	Instance attribute	Private	☐	Type reference (TYPE)	ADBC_COLUMN_TAB			20070612
14	P_T_SELECT	Instance attribute	Private	☐	Type reference (TYPE)	RS_T_RSCEDST			20070612
15	P_T_SOURCE_FIELDS	Instance attribute	Private	☐	See coding				20070612
16	P_VIRTUAL_TABLE	Instance attribute	Private	☐	Type reference (TYPE)	CL_RSSDA_FEDERATION_SERVICES=>TN_TABLE_NM			20130806

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CALL_BADI_FOR_SQL_STATEMENT	Instance method	Private	Method		20070612
2	CLOSE_DB_CONNECTION	Instance method	Private	Method		20070612
3	CONSTRUCTOR	Instance method	Public	Constructor		20070612
4	CREATE_DATASOURCE_UNIVERSE	Instance method	Private	Method		20070612
5	EXECUTE_SQL_QUERY	Instance method	Private	Method		20070612
6	GET_DBCON	Instance method	Private	Method		20070612
7	GROUP_BY_REQUIRED	Instance method	Private	Method		20070612
8	SET_CORRESPONDING_FIELDS	Instance method	Private	Method		20070612
9	SET_SQL_STATEMENT	Instance method	Private	Method		20070612
10	TRANSLATE_TO_SOURCE_FIELDS	Instance method	Private	Method		20070612

Events

Class CL_RSDS_ACCESS_DB_EXTRACTOR has no event.

Types

Class CL_RSDS_ACCESS_DB_EXTRACTOR has no local type.

Method Signatures

Method CALL_BADI_FOR_SQL_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	I_SQL_STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING			20070612

Method CALL_BADI_FOR_SQL_STATEMENT on class CL_RSDS_ACCESS_DB_EXTRACTOR has no exception.

Method CLOSE_DB_CONNECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_SQLCON	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20070612

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20070612

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DATASOURCE	Call by reference	☐	Type reference (TYPE)	RSOLTPSOURCER		DataSource	20070612
2	Importing	I_LOGSYS	Call by reference	☐	Type reference (TYPE)	RSSLOGSYS		Source system	20070612
3	Importing	I_R_ATTRIBUTES	Call by reference	☐	Object reference (TYPE REF TO)	OBJECT			20070612

#	Exception	Resumable	Description	Created on
1	CX_RSDS_ACCESS_LOGSYS_ERROR	☐	Source System Error	20070612

Method CREATE_DATASOURCE_UNIVERSE Signature

Method CREATE_DATASOURCE_UNIVERSE on class CL_RSDS_ACCESS_DB_EXTRACTOR has no parameter.
Method CREATE_DATASOURCE_UNIVERSE on class CL_RSDS_ACCESS_DB_EXTRACTOR has no exception.

Method EXECUTE_SQL_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SQL_STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING			20070612

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20070612

Method GET_DBCON Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_S_DBCON	Call by reference	☐	Type reference (TYPE)	DBCON		Description of Database Connections	20070612
2	Exporting	E_S_LOGSYSDB	Call by reference	☐	Type reference (TYPE)	RSLOGSYSDB		Extras for RSBASIDOC with DB Connect Source Systems	20130806
3	Importing	I_LOGSYS	Call by reference	☐	Type reference (TYPE)	RSSLOGSYS		Source system	20070612

#	Exception	Resumable	Description	Created on
1	CX_RSDS_ACCESS_LOGSYS_ERROR	☐	Source System Error	20070612

Method GROUP_BY_REQUIRED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_GROUP_BY_REQUIRED	Value transfer	☐	Type reference (TYPE)	RSBOOL		Flag structure	20070612
2	Importing	I_T_FIELDS	Call by reference	☐	Type reference (TYPE)	RSDS_T_EXTRACT_FIELDS		Fields for Extraction	20070612

Method GROUP_BY_REQUIRED on class CL_RSDS_ACCESS_DB_EXTRACTOR has no exception.

Method SET_CORRESPONDING_FIELDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_CORRESPONDING_FIELDS	Call by reference	☐	Attribute reference (LIKE)	P_T_CORRESPONDING_FIELDS			20070612
2	Importing	I_T_FIELDS	Call by reference	☐	Type reference (TYPE)	RSDS_T_EXTRACT_FIELDS		Fields for Extraction	20070612

Method SET_CORRESPONDING_FIELDS on class CL_RSDS_ACCESS_DB_EXTRACTOR has no exception.

Method SET_SQL_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_GROUP_BY_REQUIRED	Call by reference	☐	Type reference (TYPE)	RSBOOL		Flag structure	20070612
2	Returning	R_SQL_STATEMENT	Value transfer	☐	Type reference (TYPE)	STRING			20070612

#	Exception	Resumable	Description	Created on
1	CX_RSDS_ACCESS_EXTRACTOR_ERROR	☐	Error during extraction of data	20130829

Method TRANSLATE_TO_SOURCE_FIELDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_SOURCE_FIELDS	Call by reference	☐	Attribute reference (LIKE)	P_T_SOURCE_FIELDS		Fields for Extraction	20070612
2	Importing	I_T_FIELDS	Call by reference	☐	Type reference (TYPE)	RSDS_T_EXTRACT_FIELDS		Fields for Extraction	20070612

Method TRANSLATE_TO_SOURCE_FIELDS on class CL_RSDS_ACCESS_DB_EXTRACTOR has no exception.

History

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