SAP ABAP Class CL_RSDRD_SELDEL_PACK (Delete from Table on Package Basis)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSDRD (Package) Delete Data Manager Data

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDRD_SELDEL_TAB	Selective Deleting from a Table	20050726

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSDRD_SELDEL_PACK_ADA	Selective Deletion ADA: Delete in Packages	20050622
2	Inheritance (c INHERITING FROM c_ref)	CL_RSDRD_SELDEL_PACK_DB2	Selective Deletion DB6: Delete in Packages	20060907
3	Inheritance (c INHERITING FROM c_ref)	CL_RSDRD_SELDEL_PACK_DB4	Selective Deletion DB4: Delete in Packages	20050901
4	Inheritance (c INHERITING FROM c_ref)	CL_RSDRD_SELDEL_PACK_DB6	Selective Deletion DB6: Delete in Packages	20050722
5	Inheritance (c INHERITING FROM c_ref)	CL_RSDRD_SELDEL_PACK_HDB	Selective Deletion ADA: Delete in Packages	20100624
6	Inheritance (c INHERITING FROM c_ref)	CL_RSDRD_SELDEL_PACK_MSS	Selective Deletion MSS: Delete in Packages	20050726
7	Inheritance (c INHERITING FROM c_ref)	CL_RSDRD_SELDEL_PACK_ORA	Selective Deletion ORA: Delete in Packages	20050621
8	Inheritance (c INHERITING FROM c_ref)	CL_RSDRD_SELDEL_PACK_SYB	Selective Deletion SYB: Delete in Packages	20101125

Properties

Class	CL_RSDRD_SELDEL_PACK
Short Description	Delete from Table on Package Basis
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	RSDRD	Delete Data Manager Data
Created	20050726	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	RSD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RSDRS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_RSDRD_SELDEL_TAB	☐	☐	Selective Deleting from a Table	20050726

Friends

Class CL_RSDRD_SELDEL_PACK has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_DEL_CNT	Instance attribute	Private	☐	Type reference (TYPE)	I		Number of Deleted Data Records	20050726
2	P_EXPECTED_COUNT	Instance attribute	Private	☐	Type reference (TYPE)	I		Expected number of rows to be deleted	20081203
3	P_PACKSIZE	Instance attribute	Protected	☐	Type reference (TYPE)	I		Size of Data Packages upon Deletion	20050726
4	P_PARALLEL_DEGREE	Instance attribute	Protected	☐	Type reference (TYPE)	I		Number of Parallel Select Statements	20050726
5	P_TABALIAS	Instance attribute	Protected	☐	Type reference (TYPE)	RSDRS_ALIAS		Table Alias	20050726
6	P_THRESHOLD	Instance attribute	Protected	☐	Type reference (TYPE)	I		Threshold Value for Delete Mode	20050726
7	P_TRANSACT	Instance attribute	Protected	☐	Type reference (TYPE)	RS_BOOL		Transactional Deletion	20050726

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ANALYZE_TABLE	Instance method	Private	Method	Generate Statistics in Table	20051130
2	APPEND_ERROR_MESSAGES	Instance method	Private	Method	Add Error Messages to Application Log	20050726
3	BUILD_SX_QUERY_PACK	Instance method	Protected	Method	Add Condition to Package Size	20050727
4	CONSTRUCTOR	Instance method	Public	Constructor	Constructor	20050726
5	COUNT	Instance method	Public	Method	Number of Data Records to Be Deleted	20050726
6	CREATE_SHD_TABLE	Instance method	Private	Method	Create Shadow Table	20050726
7	DROP_TABLE	Instance method	Private	Method	Delete Shadow Table	20050726
8	EXEC_AFTER_DELETE	Instance method	Protected	Method	For DB-Platforms. Called After Deletion	20050726
9	EXEC_BEFORE_DELETE	Instance method	Protected	Method	For DB-Platforms. Called Before Deletion	20050726
10	FACTORY	Static method	Public	Method	Return Reference to DB-Specific Instance	20050726
11	GET_DEL_CNT	Instance method	Public	Method	Number of Deleted Data Records	20050726
12	GET_PACKSIZE	Instance method	Public	Method	Maximum Package Size upon Deletion	20050726
13	GET_PARALLEL_DEGREE	Instance method	Public	Method	Number of Parallel Processes	20050726
14	GET_THRESHOLD	Instance method	Public	Method	Read Threshold Value for Delete Mode (Delete vs. Ins. Sel.)	20050726
15	GET_TRANSACT	Instance method	Public	Method	Return 'Transactional Deletion' Status	20050726
16	INSERT_SELECT_INV	Instance method	Private	Method	Deletion Using Insert Select in Shadow Table	20050726
17	INVERT_SX_QUERY	Instance method	Private	Method	Build SX_QUERY with Inverse Delete Condition	20050726
18	LOCK_TABLE_EXCLUSIVE	Instance method	Private	Method	Lock Delete Table Excusively	20050726
19	REPAIR_INDEXES	Instance method	Protected	Method	Repair Indexes for Original Table	20050726
20	SET_COUNT	Instance method	Public	Method	Set expected number of rows to be deleted	20081203
21	SET_DEFAULTS	Instance method	Protected	Method	For DB Platforms. Set Initial Values for Class Attributes	20050726
22	SET_PACKSIZE	Instance method	Public	Method	Maximum Package Size upon Deletion	20050726
23	SET_PARALLEL_DEGREE	Instance method	Public	Method	Number of Parallel Processes	20050726
24	SET_THRESHOLD	Instance method	Public	Method	Threshold Value for Delete Mode (Delete vs. Insert Select)	20050726
25	SET_TRANSACT	Instance method	Public	Method	Transactional Deletion	20050726
26	SWITCH_SHD_TABLE	Instance method	Private	Method	Swap Shadow Table with Original Table	20050726

Events

Class CL_RSDRD_SELDEL_PACK has no event.

Types

Class CL_RSDRD_SELDEL_PACK has no local type.

Method Signatures

Method ANALYZE_TABLE Signature

Method ANALYZE_TABLE on class CL_RSDRD_SELDEL_PACK has no parameter.
Method ANALYZE_TABLE on class CL_RSDRD_SELDEL_PACK has no exception.

Method APPEND_ERROR_MESSAGES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_MSGTY	Call by reference	☐	Type reference (TYPE)	SYMSGTY	'E'	Nachrichtentyp	20050726
2	Importing	I_R_EXCEPTION	Call by reference	☐	Object reference (TYPE REF TO)	CX_ROOT		Abstrakte Oberklasse aller globalen Exceptions	20050726

Method APPEND_ERROR_MESSAGES on class CL_RSDRD_SELDEL_PACK has no exception.

Method BUILD_SX_QUERY_PACK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_SX_QUERY_DEL	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY		Modifizierte sx_query Struktur (Paketgröße)	20050727
2	Importing	I_DEL_CNT	Call by reference	☐	Type reference (TYPE)	I		Anzahl zu löschender Datenzätze	20050727

Method BUILD_SX_QUERY_PACK on class CL_RSDRD_SELDEL_PACK has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDRD_MESSAGE_OBJ_LIST		Message Objekt	20050726
2	Importing	I_SX_QUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY		sx_queryStruktur	20050726

Method CONSTRUCTOR on class CL_RSDRD_SELDEL_PACK has no exception.

Method COUNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SHOW_STMT	Call by reference	☑	Type reference (TYPE)	RS_BOOL		Generierte SQL Statements anzeigen	20050726
2	Returning	R_CNT	Value transfer	☐	Type reference (TYPE)	I		Anzahl zu löschender Datensätze	20050726

#	Exception	Resumable	Description	Created on
1	CX_RSDRD_EXCEPTION	☐	RSDRD Ausnahmen	20080416

Method CREATE_SHD_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_SHD_TABLNM	Value transfer	☐	Type reference (TYPE)	RSD_TABLNM		Name einer Tabelle	20050726

Method CREATE_SHD_TABLE on class CL_RSDRD_SELDEL_PACK has no exception.

Method DROP_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TABLNM	Call by reference	☐	Type reference (TYPE)	RSD_TABLNM		Name einer Tabelle	20050726

Method DROP_TABLE on class CL_RSDRD_SELDEL_PACK has no exception.

Method EXEC_AFTER_DELETE Signature

Method EXEC_AFTER_DELETE on class CL_RSDRD_SELDEL_PACK has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRD_EXCEPTION	☐	RSDRD exceptions	20121214

Method EXEC_BEFORE_DELETE Signature

Method EXEC_BEFORE_DELETE on class CL_RSDRD_SELDEL_PACK has no parameter.
Method EXEC_BEFORE_DELETE on class CL_RSDRD_SELDEL_PACK has no exception.

Method FACTORY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_LOG	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDRD_MESSAGE_OBJ_LIST		Message Objekt	20050726
2	Importing	I_SX_QUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY		sx_queryStruktur	20050726
3	Returning	R_R_SELDEL_PACK	Value transfer	☐	Object reference (TYPE REF TO)	CL_RSDRD_SELDEL_PACK		Referenz auf DB abhängige Instanz	20050726

Method FACTORY on class CL_RSDRD_SELDEL_PACK has no exception.

Method GET_DEL_CNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_DEL_CNT	Value transfer	☐	Type reference (TYPE)	I		Anzahl gelöschter Datensätze	20050726

Method GET_DEL_CNT on class CL_RSDRD_SELDEL_PACK has no exception.

Method GET_PACKSIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_PACKSIZE	Value transfer	☐	Type reference (TYPE)	I		Paketgröße	20050726

Method GET_PACKSIZE on class CL_RSDRD_SELDEL_PACK has no exception.

Method GET_PARALLEL_DEGREE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_PARALLEL_DEGREE	Value transfer	☐	Type reference (TYPE)	I		Anzahl paralleler Select Statements	20050726

Method GET_PARALLEL_DEGREE on class CL_RSDRD_SELDEL_PACK has no exception.

Method GET_THRESHOLD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_THRESHOLD	Value transfer	☐	Type reference (TYPE)	I		Schwellwert für den Löschmodus	20050726

Method GET_THRESHOLD on class CL_RSDRD_SELDEL_PACK has no exception.

Method GET_TRANSACT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_TRANSACT	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Transaktionales Löschen	20050726

Method GET_TRANSACT on class CL_RSDRD_SELDEL_PACK has no exception.

Method INSERT_SELECT_INV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DEL_CNT	Call by reference	☐	Type reference (TYPE)	I		Anzahl zu löschender Datensätze	20050727
2	Importing	I_SHOW_STMT	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Generierte SQL-Statements anzeigen	20050726
3	Returning	R_PROCESSED	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Aktion erfolgreich ausgeführt?	20050727

#	Exception	Resumable	Description	Created on
1	CX_RSDRD_EXCEPTION	☐	RSDRD Ausnahmen	20050727

Method INVERT_SX_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SX_QUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY		sx_query Struktur	20050726
2	Returning	R_SX_QUERY_INV	Value transfer	☐	Type reference (TYPE)	RSDRS_SX_QUERY		sx_query Struktur mit inverser Löschbedingung	20050726

Method INVERT_SX_QUERY on class CL_RSDRD_SELDEL_PACK has no exception.

Method LOCK_TABLE_EXCLUSIVE Signature

Method LOCK_TABLE_EXCLUSIVE on class CL_RSDRD_SELDEL_PACK has no parameter.
Method LOCK_TABLE_EXCLUSIVE on class CL_RSDRD_SELDEL_PACK has no exception.

Method REPAIR_INDEXES Signature

Method REPAIR_INDEXES on class CL_RSDRD_SELDEL_PACK has no parameter.
Method REPAIR_INDEXES on class CL_RSDRD_SELDEL_PACK has no exception.

Method SET_COUNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_COUNT	Call by reference	☐	Type reference (TYPE)	I			20081203

Method SET_COUNT on class CL_RSDRD_SELDEL_PACK has no exception.

Method SET_DEFAULTS Signature

Method SET_DEFAULTS on class CL_RSDRD_SELDEL_PACK has no parameter.
Method SET_DEFAULTS on class CL_RSDRD_SELDEL_PACK has no exception.

Method SET_PACKSIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PACKSIZE	Call by reference	☐	Type reference (TYPE)	I	1000000	Größe der Datenpakete beim Löschen	20050726

Method SET_PACKSIZE on class CL_RSDRD_SELDEL_PACK has no exception.

Method SET_PARALLEL_DEGREE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PARALLEL_DEGREE	Call by reference	☐	Type reference (TYPE)	I		Anzahl paralleler Selects	20050726

Method SET_PARALLEL_DEGREE on class CL_RSDRD_SELDEL_PACK has no exception.

Method SET_THRESHOLD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_THRESHOLD	Call by reference	☐	Type reference (TYPE)	I		Schwellwert für den Löschmodus	20050726

Method SET_THRESHOLD on class CL_RSDRD_SELDEL_PACK has no exception.

Method SET_TRANSACT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TRANSACT	Call by reference	☐	Type reference (TYPE)	RS_BOOL	''	Transaktionales Löschen einschalten	20050726

Method SET_TRANSACT on class CL_RSDRD_SELDEL_PACK has no exception.

Method SWITCH_SHD_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SHD_TABLNM	Call by reference	☐	Type reference (TYPE)	RSD_TABLNM		Name einer Schattentabelle	20050726

Method SWITCH_SHD_TABLE on class CL_RSDRD_SELDEL_PACK has no exception.

History

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