SAP ABAP Class CL_DPR_UPLOAD_UTILITY (DPR upload utility)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-EXT-API (Application Component) BAPI Interface for cProjects
     ⤷ DEVELOPMENT_PROJECTS_API (Package) API for Project Management

Properties

Class	CL_DPR_UPLOAD_UTILITY
Short Description	DPR upload utility
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	DEVELOPMENT_PROJECTS_API	API for Project Management
Created	20100419	SAP
Last change	20141109
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

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

Interfaces

Class CL_DPR_UPLOAD_UTILITY has no interface implemented.

Friends

Class CL_DPR_UPLOAD_UTILITY has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	MS_APPLICATION	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20100625
2	MS_COLS	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20100625
3	MS_FIRST_CELL	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20100625
4	MS_H_CELL	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20100625
5	MS_LAST_CELL	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20100625
6	MS_RANGE	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20100625
7	MS_ROWS	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20100625
8	MS_WORKBOOK	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20100625
9	MS_WORKSHEET	Instance attribute	Private	☐	Type reference (TYPE)	OLE2_OBJECT			20100625
10	MT_DPR_CHECKLIST	Static Attribute	Public	☐	Type reference (TYPE)	DPR_TT_DX_CHECKLIST		Excel Upload: Checklist Data	20100421
11	MT_DPR_CHECKLIST_ITEM	Static Attribute	Public	☐	Type reference (TYPE)	DPR_TT_DX_CHECKLIST_ITEM		Excel Upload: Checklist Item Data	20100421
12	MT_DPR_PHASE	Static Attribute	Public	☐	Type reference (TYPE)	DPR_TT_DX_PHASE		Excel Upload: Phase Data	20100421
13	MT_DPR_PROJECT	Static Attribute	Public	☐	Type reference (TYPE)	DPR_TT_DX_PROJECT		Excel Upload: Project Data	20100421
14	MT_DPR_PROJECT_STRUCTURE	Static Attribute	Public	☐	Type reference (TYPE)	DPR_TT_DX_PROJECT_STRUCTURE		Excel Upload: Project Structure	20100421
15	MT_DPR_ROLE	Static Attribute	Public	☐	Type reference (TYPE)	DPR_TT_DX_ROLE		Excel Upload: Role Data	20100421
16	MT_DPR_STAFFING	Static Attribute	Public	☐	Type reference (TYPE)	DPR_TT_DX_STAFFING		Excel Upload: Staffing Data	20100421
17	MT_DPR_TASK	Static Attribute	Public	☐	Type reference (TYPE)	DPR_TT_DX_TASK		Excel Upload: Task Data	20100421
18	MT_RPM_DX_FIELDS_T	Static Attribute	Private	☐	Type reference (TYPE)	RPM_TT_DX_FIELDS_T		Table type for table RPM_DX_FIELDS_T	20100616
19	SC_PROJECT_SHEET_COUNT	Constant	Private	☐	Type reference (TYPE)	I	8		20100420
20	SC_XLS_FILE	Constant	Private	☐	Type reference (TYPE)	STRING	'XLS'		20100419
21	SC_XML_FILE	Constant	Private	☐	Type reference (TYPE)	STRING	'XML'		20100419
22	SR_DPR_UPLOAD_UTILITY	Static Attribute	Public	☐	Object reference (TYPE REF TO)	CL_DPR_UPLOAD_UTILITY		Upload Utility	20100420

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_ROW	Instance method	Private	Method		20100419
2	CLOSE_EXCEL	Instance method	Public	Method		20100419
3	CONV_RAW_DATA_TO_DDIC	Instance method	Private	Method		20100419
4	CONV_RAW_DATA_TO_DDIC2	Instance method	Private	Method		20100604
5	CREATE_ROW_DDIC	Instance method	Private	Method		20100623
6	DISPLAY_FILE	Instance method	Public	Method		20100419
7	DISP_EXTERN_TEMPL	Instance method	Public	Method		20100419
8	ERROR_HANDLER	Instance method	Private	Method		20100419
9	GET_FILE_NAME	Instance method	Public	Method		20100419
10	GET_INSTANCE	Static method	Public	Method		20100419
11	GET_SHEET_COUNT	Instance method	Private	Method		20100419
12	INITIALIZE_XLS	Instance method	Private	Method		20100419
13	LOAD_EXTERN_FILE	Instance method	Public	Method		20100419
14	OPEN_XLS	Instance method	Private	Method		20100419
15	READ_SHEET	Instance method	Public	Method		20100419

Events

Class CL_DPR_UPLOAD_UTILITY has no event.

Types

Class CL_DPR_UPLOAD_UTILITY has no local type.

Method Signatures

Method ADD_ROW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COL_INDEX	Value transfer	☐	Type reference (TYPE)	I			20100419
2	Importing	IV_COL_NAME	Value transfer	☐	Type reference (TYPE)	FIELDNAME		Field Name	20100419
3	Importing	IV_COMMENTS	Call by reference	☑	Type reference (TYPE)	STRING		Customer Field Description	20100419

Method ADD_ROW on class CL_DPR_UPLOAD_UTILITY has no exception.

Method CLOSE_EXCEL Signature

Method CLOSE_EXCEL on class CL_DPR_UPLOAD_UTILITY has no parameter.
Method CLOSE_EXCEL on class CL_DPR_UPLOAD_UTILITY has no exception.

Method CONV_RAW_DATA_TO_DDIC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_DDIC_STRUC	Call by reference	☐	Type reference (TYPE)	ANY			20100625
2	Exporting	ET_DDIC_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20100419
3	Importing	IS_RAW_DATA	Call by reference	☐	Type reference (TYPE)	RPM_TT_DX_RAW_DATA		RPM: External file raw data	20100419
4	Importing	IS_STRUCT	Call by reference	☐	Type reference (TYPE)	ANY			20100419
5	Importing	IT_HEADER_FIELD	Call by reference	☐	Type reference (TYPE)	RPM_TT_DX_RAW_DATA_FIELD		RPM: Single fileds of an external raw data record	20100419
6	Importing	IV_OBJECT_TYPE	Call by reference	☐	Type reference (TYPE)	RPM_TV_DX_SHEET		Sheet	20100616

#	Exception	Resumable	Description	Created on
1	GENERIC_ERROR	☐	Generic Error	20100419

Method CONV_RAW_DATA_TO_DDIC2 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_DDIC_STRUC	Call by reference	☐	Type reference (TYPE)	ANY			20100625
2	Exporting	ET_DDIC_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20100604
3	Importing	IS_RAW_DATA	Call by reference	☐	Type reference (TYPE)	RPM_TT_DX_RAW_DATA		RPM: External file raw data	20100604
4	Importing	IS_STRUCT	Call by reference	☐	Type reference (TYPE)	ANY			20100604
5	Importing	IT_HEADER_FIELD	Call by reference	☐	Type reference (TYPE)	RPM_TT_DX_RAW_DATA_FIELD		RPM: Single fileds of an external raw data record	20100604
6	Importing	IV_OBJECT_TYPE	Call by reference	☐	Type reference (TYPE)	RPM_TV_DX_SHEET		Sheet	20100616

#	Exception	Resumable	Description	Created on
1	GENERIC_ERROR	☐	Generic Error	20100604

Method CREATE_ROW_DDIC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_STRUCT	Call by reference	☐	Type reference (TYPE)	ANY			20100623

Method CREATE_ROW_DDIC on class CL_DPR_UPLOAD_UTILITY has no exception.

Method DISPLAY_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_FILENAME	Call by reference	☐	Type reference (TYPE)	STRING			20100419

Method DISPLAY_FILE on class CL_DPR_UPLOAD_UTILITY has no exception.

Method DISP_EXTERN_TEMPL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_FILENAME	Call by reference	☑	Type reference (TYPE)	STRING			20100419
2	Importing	IV_FILETYPE	Call by reference	☐	Type reference (TYPE)	RPM_TV_DX_FILETYPE		RPM DX: External File Type	20100419
3	Importing	IV_OBJ_TYPE	Call by reference	☑	Type reference (TYPE)	DPR_TV_OBJECT_TYPE		Object Category in Project Planning	20100419

Method DISP_EXTERN_TEMPL on class CL_DPR_UPLOAD_UTILITY has no exception.

Method ERROR_HANDLER Signature

Method ERROR_HANDLER on class CL_DPR_UPLOAD_UTILITY has no parameter.

#	Exception	Resumable	Description	Created on
1	OLE_ERROR	☐	EXCEL OLE ERROR	20100419

Method GET_FILE_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CV_FILENAME	Call by reference	☐	Type reference (TYPE)	ANY			20100419
2	Importing	IV_DEFPATH	Call by reference	☐	Type reference (TYPE)	ANY			20100419
3	Importing	IV_MASK	Call by reference	☐	Type reference (TYPE)	ANY			20100419
4	Importing	IV_TITLE	Call by reference	☐	Type reference (TYPE)	ANY			20100419

Method GET_FILE_NAME on class CL_DPR_UPLOAD_UTILITY has no exception.

Method GET_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RR_INSTANCE	Value transfer	☐	Object reference (TYPE REF TO)	CL_DPR_UPLOAD_UTILITY		RPM upload utility	20100625

Method GET_INSTANCE on class CL_DPR_UPLOAD_UTILITY has no exception.

Method GET_SHEET_COUNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_SHEET_COUNT	Call by reference	☐	Type reference (TYPE)	I			20100419
2	Importing	IV_OBJ_TYPE	Call by reference	☐	Type reference (TYPE)	DPR_TV_OBJECT_TYPE		Object Category in Project Planning	20100419

Method GET_SHEET_COUNT on class CL_DPR_UPLOAD_UTILITY has no exception.

Method INITIALIZE_XLS Signature

Method INITIALIZE_XLS on class CL_DPR_UPLOAD_UTILITY has no parameter.
Method INITIALIZE_XLS on class CL_DPR_UPLOAD_UTILITY has no exception.

Method LOAD_EXTERN_FILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_FILENAME	Call by reference	☐	Type reference (TYPE)	ANY			20100419
2	Importing	IV_FILETYPE	Call by reference	☐	Type reference (TYPE)	RPM_TV_DX_FILETYPE		RPM DX: External File Type	20100419
3	Importing	IV_OBJ_TYPE	Call by reference	☐	Type reference (TYPE)	DPR_TV_OBJECT_TYPE		Object Category in Project Planning	20100419

Method LOAD_EXTERN_FILE on class CL_DPR_UPLOAD_UTILITY has no exception.

Method OPEN_XLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_OBJ_TYPE	Call by reference	☐	Type reference (TYPE)	DPR_TV_OBJECT_TYPE		Object Category in Project Planning	20100419

Method OPEN_XLS on class CL_DPR_UPLOAD_UTILITY has no exception.

Method READ_SHEET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_FILENAME	Call by reference	☐	Type reference (TYPE)	ANY			20100419
2	Importing	IV_OBJ_TYPE	Call by reference	☐	Type reference (TYPE)	DPR_TV_OBJECT_TYPE		Object Category in Project Planning	20100419

Method READ_SHEET on class CL_DPR_UPLOAD_UTILITY has no exception.

History

Last changed by/on	SAP	20141109
SAP Release Created in	500_702