SAP ABAP Class CL_RSDA_DB6_INFOCUBE (DB6 NLS InfoCube Class)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-SYS-DB-DB6 (Application Component) BW DB2 Universal Database
     ⤷ RSDB6_NLS (Package) RSDB6_NLS

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSDA_DB6_INFOPROVIDER	DB6 NLS InfoProvider Class	20081210

Properties

Class	CL_RSDA_DB6_INFOCUBE
Short Description	DB6 NLS InfoCube Class
Super Class	CL_RSDA_DB6_INFOPROVIDER	DB6 NLS InfoProvider Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class	RS_DB_DB6
Program status
Category	0
Package	RSDB6_NLS	RSDB6_NLS
Created	20081210	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	IF_RSDAI_NEARLINE_CONNECTION	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
2	RSD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RSDU	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSDA_DB6_INFOCUBE has no interface implemented.

Friends

Class CL_RSDA_DB6_INFOCUBE has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_IS_CACHE_PREPARED	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Dimension cache already created	20090729
2	P_TR_COLUMNS	Instance attribute	Private	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		Column Definitions of Near-Line Table	20081210
3	P_TR_DIMENSIONS	Instance attribute	Private	☐	Type reference (TYPE)	TY_T_DIMENSIONS		ABAP Table with Dimension Information	20081210
4	P_T_DIM_BUFFERS	Instance attribute	Private	☐	Type reference (TYPE)	TY_T_DIM_BUFFERS		Dimension table cache	20090729
5	P_USE_CDE_DIM_SEQUENCE	Static Attribute	Private	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE		20130411

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_FIELDS	Instance method	Private	Method	Adds a new field	20090513
2	ALTER_DIMENSION	Instance method	Private	Method	Changes the structure of a dimension table	20090311
3	ALTER_FACT	Instance method	Private	Method	Changes the structure of the facts table	20090311
4	ALTER_FIELDS	Instance method	Private	Method	Changes the fields	20090513
5	CONSTRUCTOR	Instance method	Public	Constructor		20081211
6	CREATE_DIMENSION	Instance method	Private	Method	Creates the Dimension Table	20081210
7	CREATE_DUMMY_FACT_TABLE	Instance method	Private	Method	Creates the facts table in source system and loads 1 record	20090513
8	CREATE_FACT	Instance method	Private	Method	Creates the Fact Table	20081210
9	DELETE_DUMMY_FACT_TABLE	Instance method	Private	Method	Deletes the dummy data record	20090513
10	DENORMALIZE_FIELDS	Instance method	Private	Method	Returns all fields as a list	20090513
11	GET_BW_EFACT_TABNAME	Instance method	Private	Method	Bringt den E-Faktentabelle Namen zurück	20121005
12	GET_BW_FFACT_MDCFIELDS	Instance method	Private	Method	Brings back the MDC columns for the F fact table	20100422
13	GET_BW_FFACT_TABNAME	Instance method	Private	Method	Brings back the F fact table name	20100422
14	GET_BW_PARTTIM	Instance method	Private	Method	Brings back the Parttim column	20100422
15	MANAGE_FROM_CLAUSE_TABLES	Instance method	Private	Method	Returns the table alias/name for the column owner	20081210
16	PREPARE_DIM_BUFFERS	Instance method	Private	Method	Prepares the dimension buffer	20091013
17	UPDATE_COLDIM	Instance method	Private	Method	Sets the COLDIM information for every field	20090513
18	VERIFY_DATA	Instance method	Private	Method	Verifies the written data records	20091013

Events

Class CL_RSDA_DB6_INFOCUBE has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TY_SX_DIMENSION	Private	See coding			20081210	BEGIN OF ty_sx_dimension, table_name TYPE tabname, table_type TYPE rsdai_coldim, id_field TYPE IF_RSDAI_NEARLINE_CONNECTION=>S_TABLE_FIELD, columns TYPE IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS, select_stmt TYPE string, insert_stmt TYPE string, * Statements for CDE select_cde_stmt TYPE string, insert_cde_stmt TYPE string, insert_shd_cde_stmt TYPE string, select_seq_cde_stmt TYPE string, END OF ty_sx_dimension
2	TY_SX_DIM_BUFFER	Private	See coding			20090729	BEGIN OF ty_sx_dim_buffer, table_name TYPE tabname, table_type TYPE string, fk_name TYPE string, id_fieldname TYPE fieldname, maxdimid TYPE i, r_data TYPE REF TO data, r_t_data TYPE REF TO data, r_t_cde_data TYPE REF TO data, set_dim_id TYPE string, " INSERT statement for dimension table r_prepared_statement TYPE REF TO cl_sql_prepared_statement, sel_dim_id TYPE string, r_select_prep_stmt TYPE REF TO cl_sql_prepared_statement, sel_dim_id_shd_cde TYPE string, r_select_prep_shd_cde_stmt TYPE REF TO cl_sql_prepared_statement, * statements for CDE tables set_dim_id_cde TYPE string, " INSERT statement for CDE dimension table r_prepared_cde_statement TYPE REF TO cl_sql_prepared_statement, sel_seq_dim_id_cde TYPE string, r_select_seq_prep_cde_stmt TYPE REF TO cl_sql_prepared_statement, set_dim_id_shd_cde TYPE string, " INSERT statement for CDE dimension table r_prepared_cde_shd_statement TYPE REF TO cl_sql_prepared_statement, END OF ty_sx_dim_buffer
3	TY_SX_FROM_CLAUSE	Private	See coding			20081210	BEGIN OF ty_sx_from_clause, table_name TYPE string, coldim TYPE rsdai_coldim, END OF ty_sx_from_clause
4	TY_T_DIMENSIONS	Private	See coding			20081210	ty_t_dimensions TYPE STANDARD TABLE OF ty_sx_dimension WITH DEFAULT KEY
5	TY_T_DIM_BUFFERS	Private	See coding			20090729	ty_t_dim_buffers TYPE STANDARD TABLE OF ty_sx_dim_buffer WITH KEY table_name
6	TY_T_FROM_CLAUSE	Private	See coding			20081210	ty_t_from_clause TYPE STANDARD TABLE OF ty_sx_from_clause WITh KEY table_name

Method Signatures

Method ADD_FIELDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_T_TABLES	Call by reference	☐	Type reference (TYPE)	TY_T_TABNAMES			20090513
2	Importing	I_ONLY_COLLECT	Call by reference	☐	Type reference (TYPE)	BOOLEAN	C_BOOLEAN-TRUE	boolsche Variable (X=true, -=false, space=unknown)	20090513
3	Importing	I_T_ADDED_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS			20090513
4	Importing	I_T_DENORMALIZED_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS			20090513
5	Importing	I_T_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS			20090513

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20090513

Method ALTER_DIMENSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DIMENSION	Call by reference	☐	Type reference (TYPE)	TY_SX_DIMENSION			20090311
2	Importing	I_OPERATION	Call by reference	☐	Type reference (TYPE)	STRING			20090513
3	Importing	I_T_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		Spaltendefinitionen einer Nearline-Tabelle	20090513

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20090311

Method ALTER_FACT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_OPERATION	Call by reference	☐	Type reference (TYPE)	STRING			20090513
2	Importing	I_T_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		Spaltendefinitionen einer Nearline-Tabelle	20090513

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20090311

Method ALTER_FIELDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_T_TABLES	Call by reference	☐	Type reference (TYPE)	TY_T_TABNAMES			20090513
2	Importing	I_ONLY_COLLECT	Call by reference	☐	Type reference (TYPE)	BOOLEAN	C_BOOLEAN-TRUE	boolsche Variable (X=true, -=false, space=unknown)	20090513
3	Importing	I_T_DENORMALIZED_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		Spaltendefinitionen einer Nearline-Tabelle	20090513
4	Importing	I_T_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		Spaltendefinitionen einer Nearline-Tabelle	20090513
5	Importing	I_T_MODIFIED_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		Spaltendefinitionen einer Nearline-Tabelle	20090513

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20090513
2	CX_RSDAI_ACTION_NOT_SUPPORTED	☐	Aktion wird nicht unterstützt	20090513

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_OBJNAME	Call by reference	☐	Type reference (TYPE)	RSDAI_NEARLINE_OBJECT			20081211
2	Importing	I_R_CONNECTION	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDA_DB6_CONNECTION			20081211
3	Importing	I_R_LOG	Call by reference	☑	Object reference (TYPE REF TO)	IF_RSDAI_NEARLINE_LOG			20081211

Method CONSTRUCTOR on class CL_RSDA_DB6_INFOCUBE has no exception.

Method CREATE_DIMENSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DIMENSION	Call by reference	☐	Type reference (TYPE)	TY_SX_DIMENSION			20081211

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐		20081211

Method CREATE_DUMMY_FACT_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	STRING		wHERE-Clause für den geladenen Datensatz	20090513

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20090513

Method CREATE_FACT Signature

Method CREATE_FACT on class CL_RSDA_DB6_INFOCUBE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐		20081211

Method DELETE_DUMMY_FACT_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_WHERE_CLAUSE	Call by reference	☐	Type reference (TYPE)	STRING			20090513

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20090513

Method DENORMALIZE_FIELDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		Spaltendefinitionen einer Nearline-Tabelle	20090513
2	Importing	I_ACCESS_METHOD	Call by reference	☐	Type reference (TYPE)	STRING			20090513

Method DENORMALIZE_FIELDS on class CL_RSDA_DB6_INFOCUBE has no exception.

Method GET_BW_EFACT_TABNAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20121005
2	Exporting	E_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20121005

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_OBJECT_NOT_FOUND	☐		20121005

Method GET_BW_FFACT_MDCFIELDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_T_MDCFIELDS	Value transfer	☐	Type reference (TYPE)	RSDU_T_FIELDNM		Tabellenname	20100422

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20100422

Method GET_BW_FFACT_TABNAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSD_INFOCUBE			20100422
2	Exporting	E_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20100422

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_OBJECT_NOT_FOUND	☐	Objekt nicht gefunden	20100422

Method GET_BW_PARTTIM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_PARTTIM	Value transfer	☐	Type reference (TYPE)	RSPARTTIM		Partitionierungs-Zeitmerkmal	20100422

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20100422

Method MANAGE_FROM_CLAUSE_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_T_FROM_CLAUSE	Call by reference	☐	Type reference (TYPE)	TY_T_FROM_CLAUSE			20081211
2	Exporting	E_TABLE_ALIAS	Call by reference	☐	Type reference (TYPE)	STRING			20081211
3	Exporting	E_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20081211
4	Importing	I_FIELD_NAME	Call by reference	☐	Type reference (TYPE)	FIELDNAME			20081211

Method MANAGE_FROM_CLAUSE_TABLES on class CL_RSDA_DB6_INFOCUBE has no exception.

Method PREPARE_DIM_BUFFERS Signature

Method PREPARE_DIM_BUFFERS on class CL_RSDA_DB6_INFOCUBE has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20091013

Method UPDATE_COLDIM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_AFTER_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS			20090513
2	Importing	I_ONLY_COLLECT	Call by reference	☐	Type reference (TYPE)	BOOLEAN	C_BOOLEAN-TRUE	boolsche Variable (X=true, -=false, space=unknown)	20090513
3	Importing	I_T_DENORMALIZED_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS			20090513
4	Importing	I_T_FIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS			20090513

Method UPDATE_COLDIM on class CL_RSDA_DB6_INFOCUBE has no exception.

Method VERIFY_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20091013
2	Importing	I_T_LOOKUP_DATA	Call by reference	☐	Type reference (TYPE)	ANY TABLE			20091013
3	Importing	I_T_TABFIELDS	Call by reference	☐	Type reference (TYPE)	IF_RSDAI_NEARLINE_CONNECTION=>T_TABLE_FIELDS		Spaltendefinitionen einer Nearline-Tabelle	20091013
4	Importing	I_VERIFY_CONDITION	Call by reference	☐	Type reference (TYPE)	STRING			20091013

#	Exception	Resumable	Description	Created on
1	CX_RSDAI_ACTION_FAILED	☐	Aktion wurde abgebrochen	20091013

History

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