SAP ABAP Class CL_KE_HDB_TABLE_ACCESS (Access to Tables in HANA)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KE (Package) Profitability Analysis

Properties

Class	CL_KE_HDB_TABLE_ACCESS
Short Description	Access to Tables in HANA
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	KE	Profitability Analysis
Created	20110616	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_KE_HDB_TABLE_ACCESS has no interface implemented.

Friends

Class CL_KE_HDB_TABLE_ACCESS has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CO_VALUE_REGEX	Static Attribute	Private	☐	Type reference (TYPE)	STRING	'[^0-9a-zA-Z-]'	Value Check	20110616
2	DB_CONNECTION	Instance attribute	Private	☐	Type reference (TYPE)	DBCON_NAME		Logical Name for a Database Connection	20110616
3	DELETE_STATEMENT	Instance attribute	Private	☐	Type reference (TYPE)	STRING		DELETE Statement	20110616
4	OCONCERN	Instance attribute	Private	☐	Type reference (TYPE)	ERKRS		Operating Concern	20110616
5	PARAMETER_TAB	Instance attribute	Private	☐	Type reference (TYPE)	STRING_TABLE		Parameter table	20110616
6	SELECT_STATEMENT	Instance attribute	Private	☐	Type reference (TYPE)	STRING		SELECT Statement	20110616
7	WHERE_CLAUSE	Instance attribute	Private	☐	Type reference (TYPE)	STRING		WHERE Condition	20110616
8	WHERE_TAB	Instance attribute	Private	☐	Type reference (TYPE)	STRING_TABLE			20110616

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_AUTHORITY	Static method	Private	Method	Check Authorization	20110628
2	CHECK_OPERATING_CONCERN	Static method	Private	Method	Test Whether Operating Concern Exists	20110629
3	CHECK_SELTAB	Static method	Public	Method	Check Selection Criteria for SQL Injection	20110616
4	CONSTRUCTOR	Instance method	Public	Constructor	Generate Access Object	20110616
5	DEFINE_SELECTION	Instance method	Public	Method	Define Selection Criteria for Access	20110616
6	DEFINE_SELECTION_PAOBJNR	Instance method	Private	Method	Define List of PAOBJNR as Selection Criterion	20110616
7	EXEC_DELETE	Instance method	Public	Method	Run DELETE	20110616
8	EXEC_DELETE_PAOBJNR	Static method	Public	Method	Run DELETE for List of PAOBJNR	20110616
9	EXEC_SELECT_COUNT	Instance method	Public	Method	Run SELECT COUNT	20110616
10	GET_SELECTION_CRITERIA	Instance method	Public	Method	Returns Selection Criteria for Log	20110616
11	GET_TABLE_NAME	Static method	Public	Method	Determine Table Name	20110616
12	RESET	Instance method	Public	Method	Reset Operating Concern and Delete Selection	20110616
13	SELLINE_TO_WHERE	Static method	Private	Method	Convert Selection Criteria into WHERE Condition	20110616
14	SET_STMT_DELETE	Instance method	Private	Method	Generate DELETE Statement	20110616
15	SET_STMT_SELECT_COUNT	Instance method	Private	Method	Generate SELECT Count Statement	20110616

Events

Class CL_KE_HDB_TABLE_ACCESS has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	PAOBJNR_TABLE	Public	See coding			20110616	paobjnr_table type standard table of rkeobjnr
2	STRING_TABLE	Public	See coding			20110616	string_table type standard table of string

Method Signatures

Method CHECK_AUTHORITY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IM_ERKRS	Call by reference	☑	Type reference (TYPE)	ERKRS		Ergebnisbereich	20110628

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	HANA Exceptions	20110628

Method CHECK_OPERATING_CONCERN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IM_ERKRS	Value transfer	☐	Type reference (TYPE)	ERKRS		Ergebnisbereich	20110629

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	HANA Exceptions	20110629

Method CHECK_SELTAB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EX_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20110616
2	Exporting	EX_VALUE	Call by reference	☐	Type reference (TYPE)	STRING			20110616
3	Importing	IT_SELTAB	Call by reference	☐	Type reference (TYPE)	COPA_YT_SELTAB		Komplexe Selektionsbedingung	20110616

Method CHECK_SELTAB on class CL_KE_HDB_TABLE_ACCESS has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IM_ERKRS	Value transfer	☐	Type reference (TYPE)	ERKRS		Ergebnisbereich	20110616

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20110616

Method DEFINE_SELECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SELTAB	Call by reference	☐	Type reference (TYPE)	COPA_YT_SELTAB		Komplexe Selektionsbedingung	20110616

Method DEFINE_SELECTION on class CL_KE_HDB_TABLE_ACCESS has no exception.

Method DEFINE_SELECTION_PAOBJNR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_PAOBJNR	Call by reference	☐	Type reference (TYPE)	PAOBJNR_TABLE			20110616

Method DEFINE_SELECTION_PAOBJNR on class CL_KE_HDB_TABLE_ACCESS has no exception.

Method EXEC_DELETE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EX_ROW_COUNT	Call by reference	☐	Type reference (TYPE)	I			20110616
2	Exporting	EX_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DDOBJNAME		Name eines ABAP Dictionary-Objekts	20110616
3	Importing	IM_PLIKZ	Value transfer	☐	Type reference (TYPE)	PLIKZ		Plan-/Istkennzeichen	20110616

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20110628

Method EXEC_DELETE_PAOBJNR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EX_ROW_COUNT	Call by reference	☐	Type reference (TYPE)	I			20110616
2	Exporting	EX_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DDOBJNAME		Name eines ABAP Dictionary-Objekts	20110616
3	Importing	IM_ERKRS	Value transfer	☐	Type reference (TYPE)	ERKRS		Ergebnisbereich	20110616
4	Importing	IM_PLIKZ	Value transfer	☐	Type reference (TYPE)	PLIKZ		Plan-/Istkennzeichen	20110616
5	Importing	IT_PAOBJNR	Call by reference	☐	Type reference (TYPE)	PAOBJNR_TABLE			20110616

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20110628

Method EXEC_SELECT_COUNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EX_ROW_COUNT	Call by reference	☐	Type reference (TYPE)	I			20110616
2	Exporting	EX_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	DDOBJNAME		Name eines ABAP Dictionary-Objekts	20110616
3	Importing	IM_PLIKZ	Value transfer	☐	Type reference (TYPE)	PLIKZ		Plan-/Istkennzeichen	20110616

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20110628

Method GET_SELECTION_CRITERIA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EX_SELECTION_CRITERIA_TAB	Call by reference	☐	Type reference (TYPE)	STRING_TABLE		Selektionskriterien	20110616

Method GET_SELECTION_CRITERIA on class CL_KE_HDB_TABLE_ACCESS has no exception.

Method GET_TABLE_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EX_TABLE_NAME	Value transfer	☐	Type reference (TYPE)	DDOBJNAME		Name eines ABAP Dictionary-Objekts	20110616
2	Importing	IM_ERKRS	Value transfer	☐	Type reference (TYPE)	ERKRS		Ergebnisbereich	20110616
3	Importing	IM_PLIKZ	Value transfer	☐	Type reference (TYPE)	PLIKZ		Plan-/Istkennzeichen	20110616

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	HANA Exceptions	20110629

Method RESET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IM_ERKRS	Call by reference	☐	Type reference (TYPE)	ERKRS		Ergebnisbereich	20110616

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20110628

Method SELLINE_TO_WHERE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EX_T_PARAM	Call by reference	☐	Type reference (TYPE)	STRING_TABLE			20110616
2	Exporting	EX_WHERE_CLAUSE	Call by reference	☐	Type reference (TYPE)	STRING			20110616
3	Exporting	EX_WHERE_CLAUSE_FILLED	Call by reference	☐	Type reference (TYPE)	STRING			20110616
4	Importing	IM_CEDST	Call by reference	☐	Type reference (TYPE)	CEDST		Struktur der Selektionstabelle für Objekttabelle/-ebene	20110616

Method SELLINE_TO_WHERE on class CL_KE_HDB_TABLE_ACCESS has no exception.

Method SET_STMT_DELETE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IM_PLIKZ	Value transfer	☐	Type reference (TYPE)	PLIKZ		Plan-/Istkennzeichen	20110616

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	HANA Exceptions	20110701

Method SET_STMT_SELECT_COUNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IM_PLIKZ	Call by reference	☐	Type reference (TYPE)	PLIKZ		Plan-/Istkennzeichen	20110616

#	Exception	Resumable	Description	Created on
1	CX_KE_HANA_EXCEPTION	☐	HANA Exceptions	20110701

History

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