SAP ABAP Class CL_DMC_NONSAP_EXEC (Class w/ process steps for nonsap connection)

Hierarchy

☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-EUR (Application Component) European Monetary Union: Euro
     ⤷ CNV_DMC_CONFIGURATION (Package) Package for managing configurations of MWB

Properties

Class	CL_DMC_NONSAP_EXEC
Short Description	Class w/ process steps for nonsap connection
Super Class
Instantiability of a Class	0	Private
Final	☑

General Data

Message Class
Program status
Category	0
Package	CNV_DMC_CONFIGURATION	Package for managing configurations of MWB
Created	20120622	SAP
Last change	20141030
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_DMC_NONSAP_EXEC has no forward declaration.

Interfaces

Class CL_DMC_NONSAP_EXEC has no interface implemented.

Friends

Class CL_DMC_NONSAP_EXEC has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CONFIG	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DMC_NONSAP_CONFIG		Configuration class for non-SAP connections to MWB	20120622
2	CO_APPL_LOG_SUBOBJECT	Constant	Public	☐	Type reference (TYPE)	BALSUBOBJ	'MWB_CUST'	Application Log: Subobject	20120622
3	CO_EXTID_LOG	Constant	Public	☐	Type reference (TYPE)	BALNREXT	'CL_DMC_NONSAP_EXEC'	Application Log: External ID	20120622
4	LOG_HANDLER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DMC_LOG_HANDLER		Log handler for MWB/DTL	20120622
5	MT_ID	Instance attribute	Private	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		MT_ID of the config because it is used to often	20120626
6	SRC_DB_DDIC_TOOLS	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DMC_DB_DDIC_TOOLS		Tools to access Database System DDIC	20120622

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_TABLES_FROM_SCHEMA	Instance method	Public	Method	Retrieve table list from source DB and add them to the conf	20120622
2	CLOSE_DB_CONNECTION	Instance method	Public	Method	Closes the db connection	20120622
3	CONSTRUCTOR	Instance method	Public	Constructor		20120622
4	CREATE_EXEC	Static method	Public	Method	Factory	20120622
5	CREATE_SOURCE_SYNONYM	Instance method	Private	Method	Create source synonym for one table	20120622
6	CREATE_SOURCE_SYNONYMS	Instance method	Public	Method	Create source synonyms	20120622
7	CREATE_SQL_INDEX	Instance method	Private	Method	Create table index directly on the database	20130322
8	CREATE_SQL_VIEW_DB2	Instance method	Private	Method	Create view for DB2 on database	20130322
9	CREATE_SQL_VIEW_ORA	Instance method	Private	Method	Create view directly on the database	20121214
10	CREATE_TARGET_TABLE	Instance method	Private	Method	Create target table for one source table	20120622
11	CREATE_TARGET_TABLES	Instance method	Public	Method	Create target tables	20120622
12	CREATE_TARGET_TABLE_EXT_KEYS	Instance method	Private	Method	Create target table with more than 16 keys	20121214
13	DELETE_ACCESS_PLAN	Instance method	Public	Method	Delete an access plan	20121123
14	DELETE_MIGRATION_OBJECT	Instance method	Private	Method	Delete the migration objects of a table	20120719
15	DELETE_MIGRATION_OBJECTS	Instance method	Public	Method	Delete the migration objects of this config	20120719
16	DELETE_TARGET_TABLE	Instance method	Private	Method	Delete one target table	20120718
17	DELETE_TARGET_TABLES	Instance method	Public	Method	Delete the target tables	20120622
18	DROP_SOURCE_SYNONYM	Instance method	Private	Method	Drop one source synonym	20120622
19	DROP_SOURCE_SYNONYMS	Instance method	Public	Method	Drop source synonyms	20120622
20	DROP_SQL_INDEX	Instance method	Private	Method	Drop table index directly on the database	20130322
21	DROP_SQL_VIEW	Instance method	Private	Method	Drop view on Oracle database	20130321
22	GET_SOURCE_TABLE_FIELDS	Instance method	Public	Method	Get list of all table fields	20121206
23	GET_VIEW_NAME	Instance method	Private	Method	Get name of a view associated to a target table	20121214
24	REMOVE_TABLES_FROM_CONFIG	Instance method	Public	Method	Remove tables from config and do cleanup before	20120718
25	REMOVE_TABLE_FROM_CONFIG	Instance method	Private	Method	Remove a single table from the config	20120904
26	RESET_LOADED_FLAGS	Instance method	Public	Method	Reset the loaded flags of object and the access plan	20121122
27	SET_DATA_ELEMENT_FOR_FIELD	Instance method	Private	Method	Create and set a data element for a table field	20120912
28	VALIDATE_TABLE	Instance method	Private	Method	Check if table and column names contain no "	20131014

Events

Class CL_DMC_NONSAP_EXEC has no event.

Types

Class CL_DMC_NONSAP_EXEC has no local type.

Method Signatures

Method ADD_TABLES_FROM_SCHEMA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_IS_UPLOAD	Call by reference	☐	Type reference (TYPE)	BOOLEAN	'X'	Upload tables directly into the configuration?	20120622
2	Importing	IV_NUM_TABLES	Call by reference	☐	Type reference (TYPE)	I	0	Number of tables that will be added	20120626
3	Returning	RT_TABLES	Value transfer	☐	Type reference (TYPE)	TTTABNAME		List of all tables	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method CLOSE_DB_CONNECTION Signature

Method CLOSE_DB_CONNECTION on class CL_DMC_NONSAP_EXEC has no parameter.
Method CLOSE_DB_CONNECTION on class CL_DMC_NONSAP_EXEC has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_CONFIG	Call by reference	☐	Object reference (TYPE REF TO)	CL_DMC_NONSAP_CONFIG		Configuration class for non-SAP connections to MWB	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method CREATE_EXEC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_CONFIG	Call by reference	☐	Object reference (TYPE REF TO)	CL_DMC_NONSAP_CONFIG		Configuration class for non-SAP connections to MWB	20120622
2	Returning	RO_EXEC	Value transfer	☐	Object reference (TYPE REF TO)	CL_DMC_NONSAP_EXEC		Class w/ process steps for nonsap connection	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method CREATE_SOURCE_SYNONYM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_DBCON	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20120622
2	Importing	IV_SCHEMA	Call by reference	☐	Type reference (TYPE)	DBCON_UID		Database user	20120622
3	Importing	IV_SYNONYM_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120622
4	Importing	IV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method CREATE_SOURCE_SYNONYMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TAB_RANGE	Call by reference	☑	Type reference (TYPE)	DMC_RANGES_TABNAME		Number of Tables	20120622
2	Importing	IV_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method CREATE_SQL_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DD03P	Call by reference	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20130322
2	Importing	IV_IS_UNIQUE_INDEX	Call by reference	☐	Type reference (TYPE)	BOOLEAN	'X'	Create unique index	20130322
3	Importing	IV_TARGET_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130322

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20130322

Method CREATE_SQL_VIEW_DB2 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DD03P	Call by reference	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20130322
2	Importing	IV_TARGET_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130322
3	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130322

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20130322

Method CREATE_SQL_VIEW_ORA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DD03P	Call by reference	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20121214
2	Importing	IV_TARGET_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20121214
3	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20121214

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20121214

Method CREATE_TARGET_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SCHEMA	Call by reference	☐	Type reference (TYPE)	DBCON_UID		Database user	20120622
2	Importing	IV_SRC_DBCON	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20120717
3	Importing	IV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120622
4	Importing	IV_TARGET_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method CREATE_TARGET_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TAB_RANGE	Call by reference	☑	Type reference (TYPE)	DMC_RANGES_TABNAME		Table Name	20120622
2	Importing	IV_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method CREATE_TARGET_TABLE_EXT_KEYS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_DD02V	Call by reference	☐	Type reference (TYPE)	DD02V		Generated Table for View DD02V	20121214
2	Importing	IS_DD09L	Call by reference	☐	Type reference (TYPE)	DD09L		DD: Technical settings of tables	20121214
3	Importing	IT_DD03P	Call by reference	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20121214
4	Importing	IV_TARGET_RFC	Call by reference	☐	Type reference (TYPE)	RFCDEST		Logical Destination (Specified in Function Call)	20121214
5	Importing	IV_TARGET_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Name of the target table	20121214

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20121214

Method DELETE_ACCESS_PLAN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TAB_RANGE	Call by reference	☑	Type reference (TYPE)	DMC_RANGES_TABNAME		Ranges Table for Table Name	20121123
2	Importing	IV_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20121123

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20121123

Method DELETE_MIGRATION_OBJECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SOURCE_SYNONYM	Call by reference	☐	Type reference (TYPE)	TABNAME		Source synonym (Tabname used in DMC_MT_TABLES)	20120719
2	Importing	IV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Source tabname (tabname used in DMC_MT_TABLE_MAP)	20120719

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120719

Method DELETE_MIGRATION_OBJECTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TAB_RANGE	Call by reference	☑	Type reference (TYPE)	DMC_RANGES_TABNAME		Number of Tables	20120719
2	Importing	IV_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20120719

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120719

Method DELETE_TARGET_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_IS_RESET_MIGS	Call by reference	☐	Type reference (TYPE)	BOOLEAN	'-'	Reset dependent migration object?	20120718
2	Importing	IV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120718
3	Importing	IV_TARGET_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120718

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120718

Method DELETE_TARGET_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TAB_RANGE	Call by reference	☑	Type reference (TYPE)	DMC_RANGES_TABNAME		Number of Tables	20120622
2	Importing	IV_IS_RESET_MIGS	Call by reference	☐	Type reference (TYPE)	BOOLEAN	'-'	Reset dependent migration objects?	20120718
3	Importing	IV_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method DROP_SOURCE_SYNONYM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_IS_RESET_MIGS	Call by reference	☐	Type reference (TYPE)	BOOLEAN	'-'	Reset dependent migration objects?	20120718
2	Importing	IV_SCHEMA	Call by reference	☐	Type reference (TYPE)	DBCON_UID		Database user	20120622
3	Importing	IV_SYNONYM_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120622
4	Importing	IV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method DROP_SOURCE_SYNONYMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TAB_RANGE	Call by reference	☑	Type reference (TYPE)	DMC_RANGES_TABNAME		Number of Tables	20120622
2	Importing	IV_IS_RESET_MIGS	Call by reference	☐	Type reference (TYPE)	BOOLEAN	'-'	Reset dependent migration objects?	20120718
3	Importing	IV_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20120622

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120622

Method DROP_SQL_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_TARGET_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130322

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20130322

Method DROP_SQL_VIEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130321

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20130321

Method GET_SOURCE_TABLE_FIELDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SCHEMA	Call by reference	☐	Type reference (TYPE)	CHAR30		Database schema	20121206
2	Importing	IV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20121206
3	Returning	RT_DD03P	Value transfer	☐	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20121206

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20121206

Method GET_VIEW_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_TARGET_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		only /1LT/ and /1CADMC/ namespaces permitted	20121214
2	Returning	RV_VIEW_NAME	Value transfer	☐	Type reference (TYPE)	TABNAME		Table Name	20121214

Method GET_VIEW_NAME on class CL_DMC_NONSAP_EXEC has no exception.

Method REMOVE_TABLES_FROM_CONFIG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TAB_RANGE	Call by reference	☑	Type reference (TYPE)	DMC_RANGES_TABNAME		Ranges Table for Table Name	20120718
2	Importing	IV_IS_CLEAN_ALL	Call by reference	☐	Type reference (TYPE)	BOOLEAN	'-'	boolean variable (X=true, -=false, space=unknown)	20120718
3	Importing	IV_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20120718

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120718

Method REMOVE_TABLE_FROM_CONFIG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_TABLE	Call by reference	☐	Type reference (TYPE)	DMC_MT_TABLE_MAP		Table Name	20120904
2	Importing	IV_IS_CLEAN_DEEP	Call by reference	☐	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20120904
3	Importing	IV_SCHEMA	Call by reference	☐	Type reference (TYPE)	DBCON_UID		Database user	20120904

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120904

Method RESET_LOADED_FLAGS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TAB_RANGE	Call by reference	☑	Type reference (TYPE)	DMC_RANGES_TABNAME		Ranges Table for Table Name	20121122
2	Importing	IV_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20121122

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20131017

Method SET_DATA_ELEMENT_FOR_FIELD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CS_DD03P	Call by reference	☐	Type reference (TYPE)	DD03P		Structure	20120912

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20120912

Method VALIDATE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_DD03P	Call by reference	☑	Type reference (TYPE)	DMC_DD03P_TAB		DMC: Table type for the field list of a structure	20131014
2	Importing	IV_TABNAME	Call by reference	☑	Type reference (TYPE)	TABNAME		Table Name	20131014

#	Exception	Resumable	Description	Created on
1	CX_DMC_CONFIG	☐	Exception class for MWB configuration classes	20131014

History

Last changed by/on	SAP	20141030
SAP Release Created in	2010_1_620