SAP ABAP Class CL_RSDRD_ARCH_EMPTY_PARTIMS (Check a delete condition, find 'empty' partitioning keys)

Hierarchy

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

Properties

Class	CL_RSDRD_ARCH_EMPTY_PARTIMS
Short Description	Check a delete condition, find 'empty' partitioning keys
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSDRD	Delete Data Manager Data
Created	20031203	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	RSDRD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RSDRS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSDRD_ARCH_EMPTY_PARTIMS has no interface implemented.

Friends

Class CL_RSDRD_ARCH_EMPTY_PARTIMS has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_DATATARGET	Instance attribute	Private	☐	Type reference (TYPE)	RSDDATATARGET		name of the info provider (info cube)	20031203
2	P_EFACTNM	Instance attribute	Private	☐	Type reference (TYPE)	RSD_TABLNM		e-fact table name	20031203
3	P_PARTKEY	Instance attribute	Private	☐	Type reference (TYPE)	RSD_FIELDNM		partition key	20031203
4	P_PDIMNM	Instance attribute	Private	☐	Type reference (TYPE)	RSD_TABLNM		t-dimension table name	20041012
5	P_PKGSIZE	Instance attribute	Private	☐	Type reference (TYPE)	I		package size	20031203
6	P_SHOW_REPORT	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		show generated SQL statement	20031203
7	P_TDIMNM	Instance attribute	Private	☐	Type reference (TYPE)	RSD_TABLNM		t-dimension table name	20031203
8	P_TEXTID	Instance attribute	Private	☐	Type reference (TYPE)	SCX_T100KEY		T100 Key with Parameters Mapped to Attribute Names	20040120
9	P_TX_DIM	Instance attribute	Private	☐	Type reference (TYPE)	RSDRD_TX_DIM_DESC		complex structure table with delete conditions used in RSDRD	20031203
10	P_T_PARTIM	Instance attribute	Private	☐	Type reference (TYPE)	RSDRD_T_PARTIM		check list of partim SIDs	20031203
11	P_WHEREMAX	Instance attribute	Private	☐	Type reference (TYPE)	I		max. number of where conditions in a sx_query-t_where table	20031203

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_PARTIM_SIDS	Instance method	Private	Method	Produces a list of empty partims	20040913
2	CHECK_TDIM	Instance method	Private	Method	Special check of the t-dimension	20040911
3	EXEC_PARANOIA_CHECK	Instance method	Private	Method	Execute a paranois check after part tims have been found	20040911
4	FILL_SX_QUERY_CNT_DEL_PARTTIM	Instance method	Private	Method	Fill sx_query structure: COUNT(*) on e-fact using del. cond.	20040911
5	FILL_SX_QUERY_CNT_DEL_TDIM	Instance method	Private	Method	Fill sx_query structure: COUNT(*) on tdim using del. cond.	20040911
6	FILL_SX_QUERY_CNT_PARTTIM	Instance method	Private	Method	Fill sx_query structure: COUNT(*) on e-fact	20040911
7	FILL_SX_QUERY_CNT_TDIM	Instance method	Private	Method	Fill sx_query structure: COUNT(*) on tdim	20040911
8	FILL_SX_QUERY_DIM	Instance method	Private	Method	Fill sx_query structure: SELECT sorted list dimids from pdim	20031203
9	FILL_SX_QUERY_DIMDEL	Instance method	Private	Method	Fill sx_query structure: SELECT sorted list dimids from JOIN	20031203
10	FILL_SX_QUERY_EFACT	Instance method	Private	Method	Fill sx_query structure: SELECT SINGLE on e-fact table	20031203
11	FILL_SX_QUERY_TDIM	Instance method	Private	Method	Fill sx_query structure: SELECT dimids from tdim	20031203
12	GET_COB_PRO	Instance method	Private	Method	Get cob_pro entries	20040120
13	GET_LIST	Static method	Public	Method	Get a list of 'empty' partims	20031203
14	READ_FROM_EFACT	Instance method	Private	Method	Check, if pdims (inverse condition) can be found in e-fact	20031203

Events

Class CL_RSDRD_ARCH_EMPTY_PARTIMS has no event.

Types

Class CL_RSDRD_ARCH_EMPTY_PARTIMS has no local type.

Method Signatures

Method CHECK_PARTIM_SIDS Signature

Method CHECK_PARTIM_SIDS on class CL_RSDRD_ARCH_EMPTY_PARTIMS has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRD_EXCEPTION	☐	RSDRD Ausnahmen	20040913
2	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20040913
3	CX_RSDR_CUBE_LOCKED	☐	Cube is locked (due to condensing, ...)	20040913
4	CX_SY_SQL_ERROR	☐	SQL Fehler	20040913

Method CHECK_TDIM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SX_DIM	Call by reference	☐	Type reference (TYPE)	RSDRD_SX_DIM_DESC			20040911

#	Exception	Resumable	Description	Created on
1	CX_RSDRD_EXCEPTION	☐	RSDRD Ausnahmen	20040911
2	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20040911
3	CX_RSDR_CUBE_LOCKED	☐	Cube is locked (due to condensing, ...)	20040911

Method EXEC_PARANOIA_CHECK Signature

Method EXEC_PARANOIA_CHECK on class CL_RSDRD_ARCH_EMPTY_PARTIMS has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRD_EXCEPTION	☐	RSDRD Ausnahmen	20040911
2	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20040911
3	CX_RSDR_CUBE_LOCKED	☐	Cube is locked (due to condensing, ...)	20040911

Method FILL_SX_QUERY_CNT_DEL_PARTTIM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	SX_QUERY	Value transfer	☐	Type reference (TYPE)	RSDRS_SX_QUERY			20040911

Method FILL_SX_QUERY_CNT_DEL_PARTTIM on class CL_RSDRD_ARCH_EMPTY_PARTIMS has no exception.

Method FILL_SX_QUERY_CNT_DEL_TDIM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PARTTIM	Call by reference	☐	Type reference (TYPE)	I			20040911
2	Importing	I_SX_DIM	Call by reference	☐	Type reference (TYPE)	RSDRD_SX_DIM_DESC			20040911
3	Returning	SX_QUERY	Value transfer	☐	Type reference (TYPE)	RSDRS_SX_QUERY			20040911

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

Method FILL_SX_QUERY_CNT_PARTTIM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	SX_QUERY	Value transfer	☐	Type reference (TYPE)	RSDRS_SX_QUERY			20040911

Method FILL_SX_QUERY_CNT_PARTTIM on class CL_RSDRD_ARCH_EMPTY_PARTIMS has no exception.

Method FILL_SX_QUERY_CNT_TDIM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PARTTIM	Call by reference	☐	Type reference (TYPE)	I			20040911
2	Importing	I_SX_DIM	Call by reference	☐	Type reference (TYPE)	RSDRD_SX_DIM_DESC			20040911
3	Returning	SX_QUERY	Value transfer	☐	Type reference (TYPE)	RSDRS_SX_QUERY			20040911

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

Method FILL_SX_QUERY_DIM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_SX_QUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY		complex query structure used in RSDRS	20031203
2	Importing	L_SX_DIM	Call by reference	☐	Type reference (TYPE)	RSDRD_SX_DIM_DESC		complex query structure used in RSDRS	20031203

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

Method FILL_SX_QUERY_DIMDEL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_SX_QUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY		complex query structure used in RSDRS	20031203
2	Importing	L_SX_DIM	Call by reference	☐	Type reference (TYPE)	RSDRD_SX_DIM_DESC		complex query structure used in RSDRS	20031203

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

Method FILL_SX_QUERY_EFACT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_SX_QUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY		complex query structure used in RSDRS	20031203
2	Importing	I_S_PARTIM	Call by reference	☐	Type reference (TYPE)	RSDRD_S_PARTIM		partim	20031203
3	Importing	I_T_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_WHERE		where conditions of complex query structure used in RSDRS	20031203

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

Method FILL_SX_QUERY_TDIM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SX_DIM	Call by reference	☐	Type reference (TYPE)	RSDRD_SX_DIM_DESC			20040911
2	Returning	SX_QUERY	Value transfer	☐	Type reference (TYPE)	RSDRS_SX_QUERY			20040911

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

Method GET_COB_PRO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_TH_COB_PRO	Value transfer	☐	Type reference (TYPE)	RSDRS_TH_COB_PRO			20040120

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

Method GET_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_PARTIM	Call by reference	☐	Type reference (TYPE)	RSDRD_T_PARTIM		list of partims	20031203
2	Importing	I_DATATARGET	Call by reference	☐	Type reference (TYPE)	RSDDATATARGET		Datenziel für Bewegungsdaten (InfoCube, ODS Objekt, ...)	20031203
3	Importing	I_PKGSIZE	Call by reference	☐	Type reference (TYPE)	I	10000000	Package size (max. number of records read from DB in one st)	20031203
4	Importing	I_SHOW_REPORT	Call by reference	☐	Type reference (TYPE)	RS_BOOL	''	Show generated SQL statements	20031203
5	Importing	I_TX_DIM	Call by reference	☐	Type reference (TYPE)	RSDRD_TX_DIM_DESC		complex structure with delete conditions used in RSDRD	20031203
6	Importing	I_WHEREMAX	Call by reference	☐	Type reference (TYPE)	I	2	Maximum number of BETWEEN conditions in a where clause	20031203

#	Exception	Resumable	Description	Created on
1	CX_RSDRD_EXCEPTION	☐	error during RSDRD part of archieving ...	20040120

Method READ_FROM_EFACT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_WHERE		where condition (dimids inverse del. cond.) on e-fact tables	20031203

#	Exception	Resumable	Description	Created on
1	CX_RSDRD_EXCEPTION	☐	RSDRD Ausnahmen	20040120
2	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20031203
3	CX_RSDR_CUBE_LOCKED	☐	Cube is locked (due to condensing, ...)	20031203
4	CX_SY_SQL_ERROR	☐	SQL Fehler	20031203

History

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