SAP ABAP Class CL_RSMIGRATION_DDL (DB independent DDL generation for BW tables)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-SYS-DB (Application Component) BW Database platforms
     ⤷ RSMIGR (Package) DB Heterogeneous Migration

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_SMIGRATION_BASE	General base class for Basis and BW migration	20110223

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSMIGRATION_DDL_MSS	MSS specific DDL generation for BW tables	20110223

Properties

Class	CL_RSMIGRATION_DDL
Short Description	DB independent DDL generation for BW tables
Super Class	CL_SMIGRATION_BASE	General base class for Basis and BW migration
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	RSMIGR	DB Heterogeneous Migration
Created	20110223	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	MGR	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RSD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
4	RSDG	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
5	RSDU	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
6	RSODS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSMIGRATION_DDL has no interface implemented.

Friends

Class CL_RSMIGRATION_DDL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_BW_TABTYPE	Instance attribute	Protected	☐	Type reference (TYPE)	MGR_TABLETYPE		Table type of BW table	20110223
2	P_INSTANCE	Static Attribute	Protected	☐	Object reference (TYPE REF TO)	CL_RSMIGRATION_DDL		Get DDL for BW tables	20110223

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CREATE_DFACT_PRIMARY_KEY	Instance method	Protected	Method	Creates ~P or ~0 index for Fact tables	20110223
2	DDSTORAGE_DIM_IDX	Instance method	Protected	Method	Writes Index-DDSTORAGE entries for the according table type	20110223
3	DDSTORAGE_DIM_TBL	Instance method	Protected	Method	Writes Table-DDSTORAGE entries for the according table type	20110223
4	DDSTORAGE_DUDSO_ACTDATA_IDX	Instance method	Protected	Method	Writes Index-DDSTORAGE entries for the according table type	20110223
5	DDSTORAGE_DUDSO_ACTDATA_TBL	Instance method	Protected	Method	Writes Table-DDSTORAGE entries for the according table type	20110223
6	DDSTORAGE_EFACT_IDX	Instance method	Protected	Method	Writes Index-DDSTORAGE entries for the according table type	20110223
7	DDSTORAGE_EFACT_TBL	Instance method	Protected	Method	Writes Table-DDSTORAGE entries for the according table type	20110223
8	DDSTORAGE_FFACT_IDX	Instance method	Protected	Method	Writes Index-DDSTORAGE entries for the according table type	20110223
9	DDSTORAGE_FFACT_TBL	Instance method	Protected	Method	Writes Table-DDSTORAGE entries for the according table type	20110223
10	DDSTORAGE_PSA_IDX	Instance method	Protected	Method	Writes Index-DDSTORAGE entries for the according table type	20110223
11	DDSTORAGE_PSA_TBL	Instance method	Protected	Method	Writes Table-DDSTORAGE entries for the according table type	20110223
12	DDSTORAGE_STDDSO_ACTDATA_IDX	Instance method	Protected	Method	Writes Index-DDSTORAGE entries for the according table type	20110223
13	DDSTORAGE_STDDSO_ACTDATA_TBL	Instance method	Protected	Method	Writes Table-DDSTORAGE entries for the according table type	20110223
14	DDSTORAGE_STDDSO_ACTQUEUE_IDX	Instance method	Protected	Method	Writes Index-DDSTORAGE entries for the according table type	20110223
15	DDSTORAGE_STDDSO_ACTQUEUE_TBL	Instance method	Protected	Method	Writes Table-DDSTORAGE entries for the according table type	20110223
16	DDSTORAGE_STDDSO_CHANGELOG_IDX	Instance method	Protected	Method	Writes Index-DDSTORAGE entries for the according table type	20110223
17	DDSTORAGE_STDDSO_CHANGELOG_TBL	Instance method	Protected	Method	Writes Table-DDSTORAGE entries for the according table type	20110223
18	DDSTORAGE_WODSO_ACTDATA_IDX	Instance method	Protected	Method	Writes Index-DDSTORAGE entries for the according table type	20110223
19	DDSTORAGE_WODSO_ACTDATA_TBL	Instance method	Protected	Method	Writes Table-DDSTORAGE entries for the according table type	20110223
20	GET_CUBE_ACTIVATION_INDEXES	Instance method	Protected	Method	Determines sec. indexes for a cube based on the activation	20120522
21	GET_INSTANCE_RUN	Static method	Public	Method	Instanatiates the class and triggers get_ddl	20110223
22	GET_TABLE_TYPE	Static method	Public	Method	Returns the BW table type of the given table	20110223
23	PUT_PARTITION_STORAGE	Instance method	Protected	Method	Writes DDSTORAGE entries for a table to be paritioned	20110223

Events

Class CL_RSMIGRATION_DDL has no event.

Types

Class CL_RSMIGRATION_DDL has no local type.

Method Signatures

Method CREATE_DFACT_PRIMARY_KEY Signature

Method CREATE_DFACT_PRIMARY_KEY on class CL_RSMIGRATION_DDL has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐		20110223

Method DDSTORAGE_DIM_IDX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_BREAK_EXCEPTION	☐	Breaks processing while running SMIGR_CREATE_DDL	20110308
2	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_DIM_TBL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_BREAK_EXCEPTION	☐	Breaks processing while running SMIGR_CREATE_DDL	20110308
2	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_DUDSO_ACTDATA_IDX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_DUDSO_ACTDATA_TBL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_EFACT_IDX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_EFACT_TBL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_FFACT_IDX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_FFACT_TBL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_PSA_IDX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_PSA_TBL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_STDDSO_ACTDATA_IDX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_STDDSO_ACTDATA_TBL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_STDDSO_ACTQUEUE_IDX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_STDDSO_ACTQUEUE_TBL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_STDDSO_CHANGELOG_IDX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_STDDSO_CHANGELOG_TBL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_WODSO_ACTDATA_IDX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method DDSTORAGE_WODSO_ACTDATA_TBL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORCE_HETERO	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Force hetergeneous way	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method GET_CUBE_ACTIVATION_INDEXES Signature

Method GET_CUBE_ACTIVATION_INDEXES on class CL_RSMIGRATION_DDL has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20120522

Method GET_INSTANCE_RUN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_ERRORS	Value transfer	☐	Type reference (TYPE)	SMIGRATIONERRORTAB			20120530
2	Importing	I_BW_TABTYPE	Call by reference	☐	Type reference (TYPE)	MGR_TABLETYPE		BW table type info	20110223
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	TABART		Data class in technical settings	20110223
4	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20110223
5	Importing	I_TARGET_DB	Call by reference	☐	Type reference (TYPE)	MGR_S_DB_INFO		Target db system and release info	20110223
6	Importing	I_UNICODE_MIGRATION	Call by reference	☐	Type reference (TYPE)	C	' '	Indicates unicode migration	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_BREAK_EXCEPTION	☐	Breaks processing while running SMIGR_CREATE_DDL	20110223
2	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method GET_TABLE_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_TABLE_TYPE	Call by reference	☐	Type reference (TYPE)	MGR_TABLETYPE		BW table type	20110223
2	Importing	I_TBLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_BREAK_EXCEPTION	☐		20120530
2	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

Method PUT_PARTITION_STORAGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_LEFT_RIGHT	Call by reference	☐	Type reference (TYPE)	CHAR10	'RIGHT'	Character Field Length = 10	20110223
2	Importing	I_PARTITIONING_TYPE	Call by reference	☐	Type reference (TYPE)	CHAR10	'RANGE'	Character Field Length = 10	20110223
3	Importing	I_PART_COLUMN	Call by reference	☐	Type reference (TYPE)	FIELDNAME		Field Name	20110223
4	Importing	I_PART_NAMES	Call by reference	☑	Type reference (TYPE)	STRINGTAB		Partition names	20110223
5	Importing	I_PART_VALUES	Call by reference	☐	Type reference (TYPE)	STRINGTAB		Partition values	20110223

#	Exception	Resumable	Description	Created on
1	CX_SMIGRATION_EXCEPTION	☐	Exception during execution of SMIGR_CREATE_DDL	20110223

History

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