SAP ABAP Class CL_IUUC_ODQ_TABLES_ACCESS (access class for db table)

Hierarchy

☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-EUR (Application Component) European Monetary Union: Euro
     ⤷ CNV_IUUC_DB_CONNECTION (Package) Encapsulation of communication with remote systems non RFC

Properties

Class	CL_IUUC_ODQ_TABLES_ACCESS
Short Description	access class for db table
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	CNV_IUUC_DB_CONNECTION	Encapsulation of communication with remote systems non RFC
Created	20130308	SAP
Last change	20141030
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_IUUC_ODQ_TABLES_ACCESS has no forward declaration.

Interfaces

Class CL_IUUC_ODQ_TABLES_ACCESS has no interface implemented.

Friends

Class CL_IUUC_ODQ_TABLES_ACCESS has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CO_DMC_EDITOR_LINE_LENGTH	Constant	Public	☐	Type reference (TYPE)	I	72		20130314
2	CO_EXTRACT_MODE_LOAD	Constant	Public	☐	Type reference (TYPE)	IUUC_ODQ_EXTRACT_MODE	'F'	IUUC_ODQ_EXTRACTION_MODE	20130308
3	CO_EXTRACT_MODE_REPL	Constant	Public	☐	Type reference (TYPE)	IUUC_ODQ_EXTRACT_MODE	'C'	IUUC_ODQ_EXTRACTION_MODE	20130308
4	CO_EXTRACT_MODE_REPL_ONLY	Constant	Public	☐	Type reference (TYPE)	IUUC_ODQ_EXTRACT_MODE	'S'	IUUC_ODQ_EXTRACTION_MODE	20130308
5	CO_FLAG_NO	Constant	Public	☐	Type reference (TYPE)	IUUC_ODQ_BOOLEAN	''	Boolean constant no	20130321
6	CO_FLAG_YES	Constant	Public	☐	Type reference (TYPE)	IUUC_ODQ_BOOLEAN	'X'	Boolean constant yes	20130315
7	CO_ODQ_CHANGEMODE	Constant	Public	☐	Type reference (TYPE)	FIELDNAME	'ODQ_CHANGEMODE'	Field Name	20130417
8	CO_ODQ_ENTITYCNTR	Constant	Public	☐	Type reference (TYPE)	FIELDNAME	'ODQ_ENTITYCNTR'	Field Name	20130417

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_REQUEST_EXISTS	Static method	Public	Method	check if request or similar request for the same table exist	20130321
2	DELETE_REQUEST	Static method	Public	Method	delete request	20130315
3	DELETE_REQUEST_PARAM	Static method	Public	Method	delete ODQ request parameters (selection and projections)	20130314
4	GET_ALL_REQUEST_BY_MT_ID	Static method	Public	Method	get all request by mt_id & tablenames (optional)	20130421
5	GET_MT_TABNAME_BY_SUBST	Static method	Public	Method	Returns the original tablename based on the substitution	20140116
6	GET_REQUEST_BY_INDEX	Static method	Public	Method	get request by mt_id and tablename	20130308
7	GET_REQUEST_FULL	Static method	Public	Method	Read	20130315
8	GET_REQUEST_HEADER	Static method	Public	Method	Read request data	20130315
9	GET_REQUEST_PARAM	Static method	Public	Method	save ODQ request parameters (selection and projections)	20130314
10	GET_SUBSTS_BY_MT_ID_TAB	Static method	Public	Method	Returns all substitutes for an original table	20140115
11	GET_TABANME_SUBST_BY_REQUEST	Static method	Public	Method	Returns the substitution name in case it exists	20140115
12	SAVE_REQUEST	Static method	Public	Method	save a new request	20130315
13	SAVE_REQUEST_PARAM	Static method	Public	Method	save ODQ request parameters (selection and projections)	20130315
14	SAVE_TABNAME_SUBST	Static method	Public	Method	Update record entry with substitue name	20140115
15	UPDATE_REQUEST_BY_MT_ID	Static method	Public	Method	update the status of a request	20130412

Events

Class CL_IUUC_ODQ_TABLES_ACCESS has no event.

Types

Class CL_IUUC_ODQ_TABLES_ACCESS has no local type.

Method Signatures

Method CHECK_REQUEST_EXISTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_ENTRY_BY_REQUEST_ID	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_TABLES		tables for processing as ODQ provider	20140305
2	Exporting	ET_ENTRIES_BY_MT_TABNAME	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_TABLES_TAB		tables for processing as ODQ provider	20140305
3	Importing	IS_REQUEST_HEADER	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_TABLES		tables for processing as ODQ provider	20140305

Method CHECK_REQUEST_EXISTS on class CL_IUUC_ODQ_TABLES_ACCESS has no exception.

Method DELETE_REQUEST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	REQUEST_ID	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_RID		tables for processing as ODQ provider	20130315

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130315

Method DELETE_REQUEST_PARAM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DELETE_PROJECTIONS	Call by reference	☑	Type reference (TYPE)	IUUC_ODQ_BOOLEAN		Replication ODQ_BOOLEAN	20130315
2	Importing	DELETE_SELECTION	Call by reference	☑	Type reference (TYPE)	IUUC_ODQ_BOOLEAN		Replication ODQ_BOOLEAN	20130315
3	Importing	REQUEST_ID	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_RID		tables for processing as ODQ provider	20130315

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130314

Method GET_ALL_REQUEST_BY_MT_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_TABNAME	Call by reference	☑	Type reference (TYPE)	IUUC_T_REPL_TABNAME		Table Names	20130421
2	Importing	IV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20130421
3	Returning	RT_REQUESTS	Value transfer	☐	Type reference (TYPE)	IUUC_ODQ_TABLES_TAB		Table Name	20130421

Method GET_ALL_REQUEST_BY_MT_ID on class CL_IUUC_ODQ_TABLES_ACCESS has no exception.

Method GET_MT_TABNAME_BY_SUBST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20140116
2	Exporting	EV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20140116
3	Importing	IV_SUBST_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20140116

Method GET_MT_TABNAME_BY_SUBST on class CL_IUUC_ODQ_TABLES_ACCESS has no exception.

Method GET_REQUEST_BY_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20130308
2	Importing	IV_TABLENAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130308
3	Returning	RV_REQUEST_ID	Value transfer	☐	Type reference (TYPE)	IUUC_ODQ_RID		ODQ request id	20130308

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130315

Method GET_REQUEST_FULL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	IS_REQUEST	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_TABLES		tables for processing as ODQ provider	20130315
2	Exporting	I_PROJECTIONS	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_PROJECTIONS_SET		ODQ request projection set	20130315
3	Exporting	I_SELECTION	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_SELECTION_SET		ODQ request selection statement	20130315
4	Importing	REQUEST_ID	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_RID		ODQ request id	20130315

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130315

Method GET_REQUEST_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	IS_REQUEST	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_TABLES		tables for processing as ODQ provider	20130315
2	Importing	REQUEST_ID	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_RID		ODQ request id	20130315

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130315

Method GET_REQUEST_PARAM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	I_PROJECTIONS	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_PROJECTIONS_SET		ODQ request projection set	20130314
2	Exporting	I_SELECTION	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_SELECTION_SET		ODQ request selection statement	20130314
3	Importing	REQUEST_ID	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_RID		tables for processing as ODQ provider	20130315

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130314

Method GET_SUBSTS_BY_MT_ID_TAB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20140115
2	Importing	IV_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20140115
3	Returning	RT_SUBST_TABLES	Value transfer	☐	Type reference (TYPE)	IUUC_TT_TABNAME		List of table names	20140115

Method GET_SUBSTS_BY_MT_ID_TAB on class CL_IUUC_ODQ_TABLES_ACCESS has no exception.

Method GET_TABANME_SUBST_BY_REQUEST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_REQUEST_ID	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_RID		ODQ request id	20140115
2	Returning	RV_TABNAME_SUBST	Value transfer	☐	Type reference (TYPE)	TABNAME		Table Name	20140115

#	Exception	Resumable	Description	Created on
1	CX_IUUC_ODQ	☐	Excep. class for ODQ provider	20140115

Method SAVE_REQUEST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_REQUEST	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_TABLES		tables for processing as ODQ provider	20130315
2	Importing	I_PROJECTIONS	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_PROJECTIONS_SET		ODQ request projection set	20130315
3	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_SELECTION_SET		ODQ request selection statement	20130315

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130315

Method SAVE_REQUEST_PARAM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PROJECTIONS	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_PROJECTIONS_SET		ODQ request projection set	20130315
2	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_SELECTION_SET		ODQ request selection statement	20130315
3	Importing	REQUEST_ID	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_RID		tables for processing as ODQ provider	20130315

#	Exception	Resumable	Description	Created on
1	CX_IUUC_REPL_SQL	☐	SQL error in the access clases	20130315

Method SAVE_TABNAME_SUBST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_REQUEST_ID	Call by reference	☐	Type reference (TYPE)	IUUC_ODQ_RID		ODQ request id	20140115
2	Importing	IV_SUBST_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20140115

#	Exception	Resumable	Description	Created on
1	CX_IUUC_ODQ	☐	Excep. class for ODQ provider	20140115

Method UPDATE_REQUEST_BY_MT_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_ACTIVE	Call by reference	☐	Type reference (TYPE)	BOOLEAN		boolean variable (X=true, -=false, space=unknown)	20130412
2	Importing	IV_MT_ID	Call by reference	☐	Type reference (TYPE)	DMC_MT_IDENTIFIER		DMC: Indicator for Mass Transfer	20130412
3	Importing	IV_TABLENAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130412

#	Exception	Resumable	Description	Created on
1	CX_IUUC_ODQ	☐	Excep. class for ODQ provider	20130412

History

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