SAP ABAP Class CL_ISU_SVOFFERS_CALCINTEGRATE (Excel Integration for Price Calculation)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CS-CRM (Application Component) Integration: Customer Relationship Management
     ⤷ EE_SALES (Package) IS-U Sales Processing

Properties

Class	CL_ISU_SVOFFERS_CALCINTEGRATE
Short Description	Excel Integration for Price Calculation
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	EE_SALES	IS-U Sales Processing
Created	20001222	SAP
Last change	20050224	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

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

Interfaces

Class CL_ISU_SVOFFERS_CALCINTEGRATE has no interface implemented.

Friends

Class CL_ISU_SVOFFERS_CALCINTEGRATE has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CO_DOC_URL	Instance attribute	Private	☐	Type reference (TYPE)	CHAR128		Business Document Service: URI	20010105
2	CO_L_SIZE	Instance attribute	Private	☐	Type reference (TYPE)	I		Transfer Document Size	20010105
3	CO_L_TXT	Instance attribute	Private	☐	Type reference (TYPE)	CHAR200		Text field length 200	20010108
4	CO_L_TXTTABLE	Instance attribute	Private	☐	See coding				20010108
5	CO_PROGRAM	Instance attribute	Private	☐	Type reference (TYPE)	SY-REPID	'ZFG_SVANGEBOTE'	Current program	20010104
6	LO_CONTAINER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Object: Container	20001222
7	LO_CONTROL	Instance attribute	Private	☐	Object reference (TYPE REF TO)	I_OI_CONTAINER_CONTROL		Object: Control	20001222
8	LO_DOCUMENT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	I_OI_DOCUMENT_PROXY		Object: Document	20001222
9	LO_ERROR	Instance attribute	Private	☐	Object reference (TYPE REF TO)	I_OI_ERROR		Object: Errors	20001222
10	LO_IT_ERROR	Instance attribute	Private	☐	See coding				20010108
11	LO_SPREADSHEET	Instance attribute	Private	☐	Object reference (TYPE REF TO)	I_OI_SPREADSHEET		Object: Spreadsheet	20001222
12	LO_WA_ERROR	Instance attribute	Private	☐	See coding				20010108
13	SOI_IT_FORMATRANGE	Instance attribute	Private	☐	Type reference (TYPE)	SOI_FORMAT_TABLE		Define Format of Area	20010105
14	SOI_IT_FULLRANGE	Instance attribute	Private	☐	Type reference (TYPE)	SOI_FULL_RANGE_TABLE		Structure for Inclusion of Ranges	20010105
15	SOI_IT_GENERICTABLE	Instance attribute	Private	☐	Type reference (TYPE)	SOI_GENERIC_TABLE		Data Content of Areas	20010108
16	SOI_IT_RANGELIST	Instance attribute	Private	☐	Type reference (TYPE)	SOI_RANGE_LIST		Descriptions of Area (Ranges)	20010105
17	SOI_WA_FORMATRANGE	Instance attribute	Private	☐	Type reference (TYPE)	SOI_FORMAT_ITEM		Define Format of Area	20010105
18	SOI_WA_FULLRANGE	Instance attribute	Private	☐	Type reference (TYPE)	SOI_FULL_RANGE_ITEM		Structure for Inclusion of Ranges	20010105
19	SOI_WA_GENERICTABLE	Instance attribute	Private	☐	See coding			Data Content of Area	20010109
20	SOI_WA_RANGEITEM	Instance attribute	Private	☐	Type reference (TYPE)	SOI_RANGE_ITEM		Description of Area (Ranges)	20010108
21	SO_RETCODE	Instance attribute	Private	☐	Type reference (TYPE)	SOI_RET_STRING		General Return String	20001222

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	EH_LOADING_IMPOSSIBLE	Instance method	Public	Event handling method	Event Handler for LOADING_IMPOSSIBLE	20010105
2	GET_DATA_FROM_FILE	Instance method	Public	Method	Fetch Ranges from Table Calculation	20010105
3	GET_EXISTING_FILE	Instance method	Public	Method	Available Calculation File Loading	20010105
4	GET_NEW_FILE	Instance method	Public	Method	Initial Calculation File Loading	20010103
5	INIT_EXCEL_INTEGRATION	Instance method	Public	Method	Prepares Integration of Table Calculation	20010103
6	INIT_RANGES_IN_EXCELSHEET	Instance method	Public	Method	Prepares Transfer Structures in Table Calculation	20010104
7	REMOVE_INTEGRATION	Instance method	Public	Method	Clean up Table Integration	20010105

Events

#	Event	Type	Visibility	Description	Created on
1	LOADING_IMPOSSIBLE	Instance Event (0)	Public (2)	File Could not be Loaded	20010105

Types

Class CL_ISU_SVOFFERS_CALCINTEGRATE has no local type.

Method Signatures

Method EH_LOADING_IMPOSSIBLE Signature

Method EH_LOADING_IMPOSSIBLE on class CL_ISU_SVOFFERS_CALCINTEGRATE has no parameter.
Method EH_LOADING_IMPOSSIBLE on class CL_ISU_SVOFFERS_CALCINTEGRATE has no exception.

Method GET_DATA_FROM_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	X_SOI_IT_GENERICTABLE	Call by reference	☐	Type reference (TYPE)	SOI_GENERIC_TABLE		Übergabe Excelwerte	20010109
2	Importing	Y_SPREADSHEET	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_SPREADSHEET		Tabellenschnittstelle	20010105

Method GET_DATA_FROM_FILE on class CL_ISU_SVOFFERS_CALCINTEGRATE has no exception.

Method GET_EXISTING_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	XY_DOC_URL	Call by reference	☐	Type reference (TYPE)	ESALES_FILE_URL	'FILE://C:/BCS Stuff/eon_20.xls'	URL	20010105
2	Exporting	X_CONTROL	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_CONTAINER_CONTROL		Document-Container-Control-Schnittstelle	20010105
3	Exporting	X_DOCUMENT	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_DOCUMENT_PROXY		Docomentref	20010105
4	Exporting	X_L_SIZE	Call by reference	☐	Type reference (TYPE)	I		Übergabe Dokumentengrösse	20010108
5	Exporting	X_L_TXTTABLE	Call by reference	☐	Type reference (TYPE)	TABLE		Übergabe Dokumentenstruktur	20010108
6	Exporting	X_NOTFOUND	Call by reference	☐	Type reference (TYPE)	FLAG		allgemeines flag	20010105
7	Exporting	X_SPREADSHEET	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_SPREADSHEET		Spreadsheet	20010105

Method GET_EXISTING_FILE on class CL_ISU_SVOFFERS_CALCINTEGRATE has no exception.

Method GET_NEW_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	XY_DOCUMENT	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_DOCUMENT_PROXY		Docomentref	20010105

Method GET_NEW_FILE on class CL_ISU_SVOFFERS_CALCINTEGRATE has no exception.

Method INIT_EXCEL_INTEGRATION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	XY_CONTAINER	Call by reference	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container fuer Custom Controls in der Dynpro Area	20010105
2	Changing	XY_CONTROL	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_CONTAINER_CONTROL		Containerref	20010105
3	Changing	XY_DOCUMENT	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_DOCUMENT_PROXY		Documentref	20010105
4	Changing	XY_ERROR	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_ERROR		Container fuer Ref error	20010108
5	Importing	X_ACT_PROGRAM	Call by reference	☑	Type reference (TYPE)	SY-REPID		ABAP-Programm, aktuelles Rahmenprogramm	20010131
6	Importing	X_DOCUMENT_TYPE	Call by reference	☑	Type reference (TYPE)	C	'Excel.Sheet'	Art der Tabellenkalkulation	20010103
7	Importing	X_SET_TOOLBAR	Call by reference	☐	Type reference (TYPE)	FLAG	' '	Toolbar aktiv oder nicht	20010314

Method INIT_EXCEL_INTEGRATION on class CL_ISU_SVOFFERS_CALCINTEGRATE has no exception.

Method INIT_RANGES_IN_EXCELSHEET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	XY_SPREADSHEET	Call by reference	☑	Object reference (TYPE REF TO)	I_OI_SPREADSHEET		Übergabe Ref Spreadsheet	20010108
2	Importing	X_GENERIC_TABLE	Call by reference	☑	Type reference (TYPE)	ANY		Übergabe Settypstruktur	20010105
3	Importing	X_STRUCTURENAME	Call by reference	☑	Type reference (TYPE)	DDOBJNAME		Name eines ABAP Dictionary-Objekts	20010108

Method INIT_RANGES_IN_EXCELSHEET on class CL_ISU_SVOFFERS_CALCINTEGRATE has no exception.

Method REMOVE_INTEGRATION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	XY_CONTROL	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_CONTAINER_CONTROL		Document-Container-Control-Schnittstelle	20010105
2	Changing	XY_DOCUMENT	Call by reference	☐	Object reference (TYPE REF TO)	I_OI_DOCUMENT_PROXY		Docref	20010105

Method REMOVE_INTEGRATION on class CL_ISU_SVOFFERS_CALCINTEGRATE has no exception.

Event Signatures

Event LOADING_IMPOSSIBLE Signature
Event LOADING_IMPOSSIBLE on class CL_ISU_SVOFFERS_CALCINTEGRATE has no parameter.

History

Last changed by/on	SAP	20050224
SAP Release Created in	463