SAP ABAP Class CL_RSDD_CUBE_DELTA_WRITER (Cube Write Interface Including Delta Mechanism)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DBA (Application Component) Data Basis
     ⤷ RSDD_DBA (Package) Data Manager: Write InfoCube,...

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSDD_CUBE_WRITER	Cube Write Interface	20071120

Properties

Class	CL_RSDD_CUBE_DELTA_WRITER
Short Description	Cube Write Interface Including Delta Mechanism
Super Class	CL_RSDD_CUBE_WRITER	Cube Write Interface
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSDD_DBA	Data Manager: Write InfoCube,...
Created	20071119	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RSD	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)
4	RSDW	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSDD_CUBE_DELTA_WRITER has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_RSDD_CUBE_WRITER	☐	20071125	Cube Write Interface

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	PS_DB_CLASSNM	Static Attribute	Private	☐	Type reference (TYPE)	CLASSNAME		Class Name for DB Exits	20080111

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	BUILD_DIMID_SUBSELECT	Static method	Private	Method	Build Subselect on Package DIMID	20071213
2	BUILD_SELECT_LIST	Static method	Private	Method	Build Subselect on Package DIMID	20071217
3	BUILD_WHERE_TUPLES	Static method	Private	Method	Build where restrictions for values in key... columns	20080430
4	CALL_STAGE_TAB_DDIC_EXIT	Static method	Private	Method	Get Package Size DB Threshold for DB Statistics on Cube Tab	20080111
5	CHECK_DELTA_WRITE	Static method	Public	Method	Checks whether cube can write with delta mechanism	20071123
6	CREATE_STAGING_TABLE	Static method	Public	Method	Create Staging Table for InfoCube	20071120
7	DROP_DATA_PACKAGE	Static method	Private	Method	Drop Single Staging Package	20071123
8	DROP_STAGING_TABLE	Static method	Public	Method	Drops the staging table	20080111
9	FREE_DATA_PACKAGES	Static method	Public	Method	Clean Up Delta Staging Tables for Each InfoCube	20071123
10	GET_DB_ANALYZE_THRESHOLD	Static method	Private	Method	Get Package Size DB Threshold for DB Statistics on Cube Tab	20080111
11	GET_PKG_ID	Static method	Protected	Method	Retrieve Unique ID for Delta Package	20071125
12	SET_DB_EXIT_CLASSNM	Static method	Private	Method	Get Class Name for DB Exits	20080111
13	TEST_UNIQUE_ID	Static method	Public	Method	Test unique_id	20071125
14	WRITE_DELTA	Static method	Public	Method	Create and Execute SLQ Statement to Write Delta to Cube	20071217

Events

Class CL_RSDD_CUBE_DELTA_WRITER has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	NT_S_DIM	Public	See coding			20071123	BEGIN OF nt_s_dim, dimension TYPE rsdimension, factkey TYPE rsd_fieldnm, END OF nt_s_dim
2	NT_T_DIM	Public	See coding			20071123	nt_t_dim TYPE STANDARD TABLE OF nt_s_dim WITH DEFAULT KEY
3	PT_T_DD03P	Private	See coding			20071120	pt_t_dd03p TYPE STANDARD TABLE OF dd03p WITH DEFAULT KEY
4	PT_T_DD12V	Private	See coding			20071120	pt_t_dd12v TYPE STANDARD TABLE OF dd12v WITH DEFAULT KEY
5	PT_T_DD17V	Private	See coding			20071120	pt_t_dd17v TYPE STANDARD TABLE OF dd17v WITH DEFAULT KEY

Method Signatures

Method BUILD_DIMID_SUBSELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_S_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_S_WHERE			20071213
2	Changing	C_TH_SUBQUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_SUBQUERY			20071213
3	Importing	I_PKG_FACTKEY	Call by reference	☐	Type reference (TYPE)	RSD_FIELDNM			20071213

Method BUILD_DIMID_SUBSELECT on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method BUILD_SELECT_LIST 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			20071217
2	Importing	I_PARTFIELDNM	Call by reference	☐	Type reference (TYPE)	RSD_FIELDNM			20071217
3	Importing	I_PDIMID	Call by reference	☐	Type reference (TYPE)	RSSID		Stammdaten ID	20071217
4	Importing	I_T_DIM	Call by reference	☐	Type reference (TYPE)	NT_T_DIM			20071217

Method BUILD_SELECT_LIST on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method BUILD_WHERE_TUPLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_T_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_WHERE			20080430
2	Importing	I_T_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20080430
3	Importing	I_T_DIM	Call by reference	☐	Type reference (TYPE)	NT_T_DIM			20080430

Method BUILD_WHERE_TUPLES on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method CALL_STAGE_TAB_DDIC_EXIT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSINFOCUBE		InfoCube	20080111
2	Importing	I_STAGING_TAB	Call by reference	☐	Type reference (TYPE)	RSD_TABLNM			20080111

Method CALL_STAGE_TAB_DDIC_EXIT on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method CHECK_DELTA_WRITE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_DTA	Call by reference	☐	Type reference (TYPE)	RSD_S_DTA		Eigenschaften InfoProvider	20080125
2	Importing	I_T_DTA_PRO	Call by reference	☐	Type reference (TYPE)	RSD_T_DTA_PRO		infoobjects of infocube	20071123
3	Returning	R_DELTA_POSSIBLE	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Is a delta load possible for this infocube ?	20071123

Method CHECK_DELTA_WRITE on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method CREATE_STAGING_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSINFOCUBE		InfoCube	20071120
2	Returning	R_STAGING_TAB	Value transfer	☐	Type reference (TYPE)	RSD_TABLNM		Staging Table	20071120

#	Exception	Resumable	Description	Created on
1	CX_RSDD_NO_FACTTAB	☐	Faktentabelle nicht aktiv	20071120
2	CX_RSDD_TAB_NOT_EMPTY	☐	Staging Table is not empty	20071120
3	CX_RSDD_TAB_NO_UPD	☐	Staging Table is not empty	20080201

Method DROP_DATA_PACKAGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_PKG	Call by reference	☐	Type reference (TYPE)	RSDD_DELTA_PKG		Delta-Paket-Verwaltung für Infocube Deltaschreiben	20071123

Method DROP_DATA_PACKAGE on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method DROP_STAGING_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_INFOCUBE	Call by reference	☐	Type reference (TYPE)	RSINFOCUBE		InfoCube	20080111

Method DROP_STAGING_TABLE on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method FREE_DATA_PACKAGES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHECK_UNFREED	Call by reference	☑	Type reference (TYPE)	RS_BOOL	RS_C_FALSE		20071123
2	Returning	R_BLOCKED	Value transfer	☐	Type reference (TYPE)	RS_BOOL		TRUE = another cleanup already running	20071123

Method FREE_DATA_PACKAGES on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method GET_DB_ANALYZE_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			20080111

Method GET_DB_ANALYZE_THRESHOLD on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method GET_PKG_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_PKG_ID	Value transfer	☐	Type reference (TYPE)	RSSID		Stammdaten ID	20071125

Method GET_PKG_ID on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method SET_DB_EXIT_CLASSNM Signature

Method SET_DB_EXIT_CLASSNM on class CL_RSDD_CUBE_DELTA_WRITER has no parameter.
Method SET_DB_EXIT_CLASSNM on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method TEST_UNIQUE_ID Signature

Method TEST_UNIQUE_ID on class CL_RSDD_CUBE_DELTA_WRITER has no parameter.
Method TEST_UNIQUE_ID on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

Method WRITE_DELTA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_LINES	Value transfer	☐	Type reference (TYPE)	INT4		Number of inserted rows	20071217
2	Exporting	E_SUBRC	Value transfer	☐	Type reference (TYPE)	INT4		Natürliche Zahl	20071217
3	Importing	I_PARTFIELDNM	Call by reference	☐	Type reference (TYPE)	RSD_FIELDNM		Name of partitioning column if exists	20071217
4	Importing	I_PDIMID	Call by reference	☐	Type reference (TYPE)	RSDIMID		target package DIMID for F-Facttable	20071217
5	Importing	I_PKG_ID	Call by reference	☐	Type reference (TYPE)	RSSID		package ID in delta staging table	20071217
6	Importing	I_REQUID	Call by reference	☐	Type reference (TYPE)	RSSID		target package requid	20071217
7	Importing	I_TMP_ROWS	Call by reference	☐	Type reference (TYPE)	INT4		Number of rows in staging table	20071217
8	Importing	I_TS_PARTTIM	Call by reference	☑	Type reference (TYPE)	RRSI_TS_EQSID		Distinct part keys	20071217
9	Importing	I_T_DATA	Call by reference	☑	Type reference (TYPE)	STANDARD TABLE			20080430
10	Importing	I_T_DIM	Call by reference	☐	Type reference (TYPE)	NT_T_DIM		Dimension Information	20071217

Method WRITE_DELTA on class CL_RSDD_CUBE_DELTA_WRITER has no exception.

History

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