SAP ABAP Class CL_FCOM_HDB_SELECT (Data Selection from HDB)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO-PC-IS (Application Component) Product Cost Controlling Information System
     ⤷ KKB (Package) Reporting for Costing

Properties

Class	CL_FCOM_HDB_SELECT
Short Description	Data Selection from HDB
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	KKB	Reporting for Costing
Created	20111025	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)

Interfaces

Class CL_FCOM_HDB_SELECT has no interface implemented.

Friends

Class CL_FCOM_HDB_SELECT has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	MR_DBCON	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection Reference	20111026
2	MR_OUTPUT_TABLE	Instance attribute	Private	☐	Object reference (TYPE REF TO)	DATA		Reference of output table	20111031
3	MR_SQL_EXCEPTION	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20111026
4	MR_SQL_RESULT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_RESULT_SET		Resulting Set of an SQL Query	20111031
5	MT_META_DATA	Instance attribute	Private	☐	Type reference (TYPE)	ADBC_TABCOL_DESCR_TAB			20111116
6	MT_SELECTION_TABLE	Instance attribute	Private	☐	Type reference (TYPE)	FCOM_HDB_T_CEDST		Table type for CEDST	20111216
7	MV_DB_CONNECTION	Instance attribute	Public	☐	Type reference (TYPE)	DBCON-CON_NAME		Name of Database connection	20111025
8	MV_MESSAGE_TEXT	Instance attribute	Public	☐	Type reference (TYPE)	STRING		Message Text	20111026
9	MV_PACKAGE_SIZE	Instance attribute	Private	☐	Type reference (TYPE)	I		data package size for select	20111031
10	MV_SCHEMA_NAME	Instance attribute	Public	☐	Type reference (TYPE)	STRING		Schema name	20111025
11	MV_SELECT_STATEMENT_SEC	Instance attribute	Private	☐	Type reference (TYPE)	FCOM_HDB_STRING		String type for HDB Selection Criteria	20111219
12	MV_TABLE_NAME	Instance attribute	Public	☐	Type reference (TYPE)	STRING		Table or View name	20111025
13	MV_TABLE_TYPE	Instance attribute	Public	☐	Type reference (TYPE)	STRING		'T' for Table or 'V' for View	20111025

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20111025
2	DETERMINE_WHERE_CLAUSE	Instance method	Private	Method	determines where clause	20111109
3	GET_DATA	Instance method	Public	Method	returns data	20111025
4	GET_DATA_PACKAGE_NEXT	Instance method	Public	Method	returns data (in case package size was filled in GET_DATA)	20111031
5	GET_META_DATA	Instance method	Public	Method	get meta data of output structure	20111116
6	GET_OUTPUT_STRUCTURE	Instance method	Public	Method	determines output structure and select statement	20111025
7	GET_SELECT_STATEMENT	Instance method	Private	Method	determines and returns Select statement	20111025

Events

Class CL_FCOM_HDB_SELECT has no event.

Types

Class CL_FCOM_HDB_SELECT has no local type.

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_DB_CONNECTION	Call by reference	☐	Type reference (TYPE)	DBCON-CON_NAME		Logical name for a database connection	20111025
2	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	FCOM_HDB_STRING		Schema name	20111025
3	Importing	IV_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	FCOM_HDB_STRING		Table or View name	20111025
4	Importing	IV_TABLE_TYPE	Call by reference	☐	Type reference (TYPE)	FCOM_HDB_STRING	'T'	Table ('T') or View ('V')	20111025

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

Method DETERMINE_WHERE_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EV_WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	FCOM_HDB_STRING		String type for HDB Selection Criteria	20111109
2	Importing	IT_SELECTION_TABLE	Call by reference	☐	Type reference (TYPE)	FCOM_HDB_T_CEDST		Table type for CEDST	20111109

Method DETERMINE_WHERE_CLAUSE on class CL_FCOM_HDB_SELECT has no exception.

Method GET_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_OUTPUT	Call by reference	☐	Type reference (TYPE)	TABLE			20111025
2	Exporting	EV_COUNT_ENTRIES	Call by reference	☐	Type reference (TYPE)	I		Counter of result table	20111031
3	Importing	IV_PACKAGE_SIZE	Call by reference	☑	Type reference (TYPE)	I			20111025
4	Importing	IV_SELECT_STATEMENT	Call by reference	☐	Type reference (TYPE)	FCOM_HDB_STRING		String type for HDB Selection Criteria	20111025

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

Method GET_DATA_PACKAGE_NEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_OUTPUT	Call by reference	☐	Type reference (TYPE)	TABLE			20111031
2	Exporting	EV_COUNT_ENTRIES	Call by reference	☐	Type reference (TYPE)	I		Counter of result table	20111031

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

Method GET_META_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_META_DATA_INFO	Call by reference	☐	Type reference (TYPE)	ADBC_TABCOL_DESCR_TAB			20111116

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

Method GET_OUTPUT_STRUCTURE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ER_OUTPUT_STRUCTURE_REF	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20111025
2	Exporting	ET_META_DATA_INFO	Call by reference	☐	Type reference (TYPE)	ADBC_TABCOL_DESCR_TAB			20111025
3	Exporting	EV_SELECT_STATEMENT	Call by reference	☐	Type reference (TYPE)	FCOM_HDB_STRING		String type for HDB Selection Criteria	20111026
4	Importing	IT_SELECTED_FIELDS	Call by reference	☐	Type reference (TYPE)	FCOM_HDB_T_CFBSF01		Table Type for CFBSF01	20111025
5	Importing	IT_SELECTION_TABLE	Call by reference	☑	Type reference (TYPE)	FCOM_HDB_T_CEDST		Table type for CEDST	20111025

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

Method GET_SELECT_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_SELECT_STATEMENT	Call by reference	☐	Type reference (TYPE)	FCOM_HDB_STRING		Select Statement	20111026
2	Importing	IT_SELECTED_FIELDS	Call by reference	☐	Type reference (TYPE)	FCOM_HDB_T_CFBSF01		CFBSF01	20111025
3	Importing	IT_SELECTION_TABLE	Call by reference	☑	Type reference (TYPE)	FCOM_HDB_T_CEDST		CEDST	20111025

Method GET_SELECT_STATEMENT on class CL_FCOM_HDB_SELECT has no exception.

History

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