SAP ABAP Interface IF_HDB_SERVICE (Interface for BAdI: HDB_SERVICE)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ HDB (Package) ERP Accelerators

Properties

Interface	IF_HDB_SERVICE
Short Description	Interface for BAdI: HDB_SERVICE

General Data

Package	HDB	ERP Accelerators
Created	20120912	SAP
Last changed	20130531	SAP
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

#	Interface	Abstract	Final	Description	Created on
1	IF_BADI_INTERFACE	☐	☐	Tag Interface for BAdIs	20120926

Friends

Interface IF_HDB_SERVICE has no friend.

Attributes

Interface IF_HDB_SERVICE has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	DBCON_GET_APPL	Instance method	Public	Method	Use of Alternative DB Spec. for Optimized Program Paths	20120926
2	DDL_EXECUTE_FROM_TEMPLATE	Instance method	Public	Method	Execution of any DDL Instructions	20120926
3	OBJECT_ALTER	Instance method	Public	Method	Change to Tables	20120926
4	OBJECT_CREATE	Instance method	Public	Method	Creation of Tables and Views	20120926
5	OBJECT_DROP	Instance method	Public	Method	Deletion of Tables and Views	20120926
6	OBJECT_GET_ALL	Instance method	Public	Method	List of all Tables and Views	20120926
7	OBJECT_GET_INFO	Instance method	Public	Method	Meta Information for Tables and Views	20120926
8	OLAP_CREATE	Instance method	Public	Method	Generation of OLAP Views	20120926

Events

Interface IF_HDB_SERVICE has no event.

Types

Interface IF_HDB_SERVICE has no local type.

Method Signatures

Method DBCON_GET_APPL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MESSAGE	Call by reference	☐	Type reference (TYPE)	BAPIRETTAB		Table with BAPI Return Information	20120926
2	Exporting	E_DBCON_NAME	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20120926
3	Exporting	E_HDB_IS_PRIMARY_DB	Call by reference	☐	Type reference (TYPE)	FLAG		HDB is the primary DB	20120926
4	Importing	IT_PARAMETER	Call by reference	☐	Type reference (TYPE)	HDB_T_PARAMETERS		Check additional Restrictions and Statuus	20120926
5	Importing	IT_REQUIRED_TABLE	Call by reference	☐	Type reference (TYPE)	HDB_T_TABLE		Required tables and views for application context	20120926
6	Importing	I_APPLICATION	Call by reference	☐	Type reference (TYPE)	HDB_APPLICATION		Application (Default: Cross application)	20120926
7	Importing	I_CHECK_CONNECTION	Call by reference	☐	Type reference (TYPE)	FLAG		Check connection to HDB	20120926
8	Importing	I_KEY_VALUE	Call by reference	☐	Type reference (TYPE)	HDB_KEY_VALUE		Key Value	20120926
9	Importing	I_SUBAPPLICATION	Call by reference	☐	Type reference (TYPE)	HDB_SUBAPPLICATION		Subapplication	20120926
10	Importing	I_UNAME	Call by reference	☐	Type reference (TYPE)	SY-UNAME		Check whether (batch) user is excluded in cross-application	20120926

#	Exception	Resumable	Description	Created on
1	DBCON_ERROR	☐	HDB Connection Cannot be Reached or Used	20120926
2	DBCON_NOT_EXIST	☐	HDB Connection Does Not Exist	20120926
3	DBCON_NO_USE	☐	HDB Connection should not be used in this context (see HDBC)	20120926

Method DDL_EXECUTE_FROM_TEMPLATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SCALAR_VARIABLES	Call by reference	☐	Type reference (TYPE)	HDB_TT_SCALAR_VARIABLE		Table of Scalar Variables	20120926
2	Importing	IT_TABULAR_VARIABLES	Call by reference	☐	Type reference (TYPE)	HDB_TT_TABULAR_VARIABLE		Table of Tabular Variables	20120926
3	Importing	I_TEMPLATE	Call by reference	☐	Type reference (TYPE)	PROGNAME		Name of generation template	20120926

#	Exception	Resumable	Description	Created on
1	HDB_ERROR	☐	HDB SQL Error	20120926
2	TEMPLATE_BAD_FORMAT	☐	Generation template not well-formed	20120926
3	TEMPLATE_NOT_EXIST	☐	Generation template not found	20120926

Method OBJECT_ALTER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_LIKE_ERP_TABLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Add / Drop columns according to ERP table	20120926
2	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120926
3	Changing	XT_ADD_COLUMN	Call by reference	☐	Type reference (TYPE)	HDB_T_DDFIELD		Add columns to table on HDB	20120926
4	Changing	XT_DROP_COLUMN	Call by reference	☐	Type reference (TYPE)	HDB_T_DDFIELD		Drop columns to table on HDB	20120926

#	Exception	Resumable	Description	Created on
1	DDIC_ERROR	☐	Table definition not available or incorrect	20120926
2	HDB_ERROR	☐	HDB SQL Error	20120926
3	TABLE_NOT_EXIST	☐	Table not exits on HDB	20120926

Method OBJECT_CREATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DDFIELD	Call by reference	☑	Type reference (TYPE)	HDB_T_DDFIELD		Definition either from DDIC or from T_DDFIELD	20120926
2	Importing	I_AS_ROW_STORE	Call by reference	☑	Type reference (TYPE)	FLAG		Create a Row store (default Column store)	20120926
3	Importing	I_OBJECT_TYPE	Call by reference	☐	Type reference (TYPE)	CHAR1	'T'	(T)able or (V)iew	20120926
4	Importing	I_OTHER_TABNAME_ON_ERP	Call by reference	☐	Type reference (TYPE)	TABNAME		Read definition from other ERP Table	20120926
5	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120926

#	Exception	Resumable	Description	Created on
1	DDIC_ERROR	☐	Table definition not available or incorrect	20120926
2	HDB_ERROR	☐	HDB SQL Error	20120926
3	TABLE_ALREADY_EXIST	☐	Table already exists on HDB	20120926

Method OBJECT_DROP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DROP_WITH_DATA	Call by reference	☑	Type reference (TYPE)	FLAG		allgemeines flag	20120926
2	Importing	I_OBJECT_TYPE	Call by reference	☐	Type reference (TYPE)	CHAR1	'T'	(T)able or (V)iew	20120926
3	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20120926

#	Exception	Resumable	Description	Created on
1	HDB_ERROR	☐	HDB SQL Error	20120926
2	TABLE_CONTAINS_DATA	☐	Table contains data	20120926

Method OBJECT_GET_ALL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_TABLE	Call by reference	☐	Type reference (TYPE)	HDB_T_TABLE		List of Tables or Views	20120926
2	Importing	IT_PRESELECTION	Call by reference	☐	Type reference (TYPE)	ADBC_NAME_RGTAB			20120926
3	Importing	I_OBJECT_TYPE	Call by reference	☐	Type reference (TYPE)	CHAR1	'T'	(T)able or (V)iew	20120926
4	Importing	I_ONLY_ERP_TABLES	Call by reference	☐	Type reference (TYPE)	FLAG		allgemeines flag	20120926

#	Exception	Resumable	Description	Created on
1	HDB_ERROR	☐	HDB SQL Error	20120926

Method OBJECT_GET_INFO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_ALL_INFO_TABLE	Call by reference	☐	Type reference (TYPE)	HDB_S_TABLE_DETAIL		Table Details	20120926
2	Exporting	ES_ALL_INFO_VIEW	Call by reference	☐	Type reference (TYPE)	HDB_S_VIEW_DETAIL		View details	20120926
3	Exporting	ET_FCAT_COMPARE	Call by reference	☐	Type reference (TYPE)	HDB_T_COLUM_DESCR		Column Compare ERP HDB	20120926
4	Exporting	E_COL_CREATE_TIME	Call by reference	☐	Type reference (TYPE)	HDB_TIMESTAMP		Only for ColStore: Created time	20120926
5	Exporting	E_COL_IS_LOADED	Call by reference	☐	Type reference (TYPE)	FLAG		Only for ColStore: 'True' if some or all columns loaded into	20120926
6	Exporting	E_COL_LAST_MERGE_TIME	Call by reference	☐	Type reference (TYPE)	HDB_TIMESTAMP		Only for ColStore: Last Merge time	20120926
7	Exporting	E_COL_MODIFY_TIME	Call by reference	☐	Type reference (TYPE)	HDB_TIMESTAMP		Only for ColStore: Modified time	20120926
8	Exporting	E_ERP_DDTEXT	Call by reference	☐	Type reference (TYPE)	DDTEXT		Explanatory Short Text	20120926
9	Exporting	E_ERP_EXIST	Call by reference	☐	Type reference (TYPE)	FLAG		Exists on ERP	20120926
10	Exporting	E_ERP_IDENTICAL	Call by reference	☐	Type reference (TYPE)	FLAG		Fieldcatalog Identical on HDB and ERP	20120926
11	Exporting	E_HDB_EXIST	Call by reference	☐	Type reference (TYPE)	FLAG		Exists on HDB	20120926
12	Exporting	E_IS_COLUMN_TABLE	Call by reference	☐	Type reference (TYPE)	FLAG		Is a Column Store Table	20120926
13	Exporting	E_RECORD_COUNT	Call by reference	☐	Type reference (TYPE)	HDB_CNT		Record Count on HDB	20120926
14	Exporting	E_TABLE_SIZE	Call by reference	☐	Type reference (TYPE)	HDB_CNT		Total Table Size on HDB	20120926
15	Importing	I_FORCE_SELECT_COUNT	Call by reference	☑	Type reference (TYPE)	FLAG		Perform a select count( * ) to get exact number of entries	20120926
16	Importing	I_LANGU	Call by reference	☐	Type reference (TYPE)	SY-LANGU		Language Key of Current Text Environment	20120926
17	Importing	I_OBJECT_TYPE	Call by reference	☐	Type reference (TYPE)	CHAR1	'T'	(T)able or (V)iew	20120926
18	Importing	I_OTHER_TABNAME_ON_ERP	Call by reference	☐	Type reference (TYPE)	TABNAME		Compare with other ERP Table	20120926
19	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120926

#	Exception	Resumable	Description	Created on
1	DDIC_ERROR	☐	DDIC error	20120926
2	HDB_ERROR	☐	HDB SQL Error	20120926

Method OLAP_CREATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_ATTRIBUTE	Call by reference	☐	Type reference (TYPE)	HDB_T_OLAP_ATTRIBUTE		Attributes	20120926
2	Importing	IT_JOIN	Call by reference	☐	Type reference (TYPE)	HDB_T_OLAP_JOIN		Joined Attribute Tables	20120926
3	Importing	IT_KEYFIGURE	Call by reference	☐	Type reference (TYPE)	HDB_T_OLAP_KEYFIGURE		Keyfigures (Fields from Fact Table of Formular)	20120926
4	Importing	I_FACT_TABLE	Call by reference	☐	Type reference (TYPE)	TABNAME		"Fact Table" on HDB	20120926
5	Importing	I_VIEWNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Name of OLAP View	20120926

#	Exception	Resumable	Description	Created on
1	DDIC_ERROR	☐	Table definition not available or incorrect	20120926
2	HDB_ERROR	☐	HDB SQL Error	20120926
3	VIEW_ALREADY_EXIST	☐	View already exists on HDB	20120926

History

Last changed by/on	SAP	20130531
SAP Release Created in