SAP ABAP Class CL_EPIC_CB_EXCEL_ABST_MANIP (EPIC: Cash budgeting excel abstract manipulator)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-EPIC-PMCTL-SMPL-UI (Package) Globalization: E-Payment Integration Payment Control UI

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_EPIC_CB_EXCEL_PLAN_MANIP	EPIC: Cash budgeting excel plan manipulator	20130708
2	Inheritance (c INHERITING FROM c_ref)	CL_EPIC_CB_EXCEL_REPORT_MANIP	EPIC: Cash budget excel report manipulation	20130708
3	Inheritance (c INHERITING FROM c_ref)	CL_EPIC_CB_EXCEL_TPL_MANIP	EPIC: Cash budgeting excel template manipulator	20130708

Properties

Class	CL_EPIC_CB_EXCEL_ABST_MANIP
Short Description	EPIC: Cash budgeting excel abstract manipulator
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	ID-FI-EPIC-PMCTL-SMPL-UI	Globalization: E-Payment Integration Payment Control UI
Created	20130620	SAP
Last change	20131127	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

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

Interfaces

Class CL_EPIC_CB_EXCEL_ABST_MANIP has no interface implemented.

Friends

Class CL_EPIC_CB_EXCEL_ABST_MANIP has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	MC_STEP	Instance attribute	Private	☐	Type reference (TYPE)	I	50		20130708
2	MV_FILE_NAME	Instance attribute	Private	☐	Type reference (TYPE)	RLGRAP-FILENAME		Local file for upload/download	20130708

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20130708
2	READ_CYCLE_DATA	Instance method	Protected	Method	Read cycle data	20130708
3	READ_CYCLE_DATA_ONE_ROUND	Instance method	Private	Method	Read cycle data one round	20130708
4	READ_LIQUIDITY_DATA	Instance method	Protected	Method	Read liquidity data	20130708
5	READ_LIQUIDITY_DATA_ONE_ROUND	Instance method	Private	Method	Read liquidity data one round	20130708
6	READ_PLAN_DATA	Instance method	Protected	Method	Read plan data	20130708
7	READ_PLAN_DATA_ONE_ROUND	Instance method	Private	Method	Read plan data one round	20130708
8	READ_SINGLE_CELL	Instance method	Protected	Method	Read single cell	20130708
9	REFRESH_CLIPBOARD	Instance method	Protected	Method	Refresh clipboard	20130708
10	SET_ACTIVE_SHEET	Instance method	Protected	Method		20130718
11	SET_CYCLE_DATA	Instance method	Protected	Method	Set cycle data	20130708
12	SET_CYCLE_TITLE	Instance method	Protected	Method	Set cycle title	20130708
13	SET_CYCLE_TITLE_SHORT	Instance method	Protected	Method		20130708
14	SET_LIQUIDITY_DATA	Instance method	Protected	Method	Set liquidity data	20130708
15	SET_LIQUIDITY_TITLE	Instance method	Protected	Method	Set liquidity title	20130708
16	SET_ORG_DATA	Instance method	Protected	Method		20130708
17	SET_ORG_TITLE	Instance method	Protected	Method		20130708
18	SET_PLAN_TITLE	Instance method	Protected	Method	Set plan title	20130708
19	SET_REPORT_DATA	Instance method	Protected	Method		20130708
20	SET_REPORT_TITLE	Instance method	Protected	Method		20130708
21	SET_SHEET_NAME	Instance method	Protected	Method	Set sheet name	20130708
22	SET_SINGLE_CELL	Instance method	Protected	Method	Set single cell	20130708
23	SPLIT_ITEM	Instance method	Protected	Method	Split result from clipboard	20130708

Events

Class CL_EPIC_CB_EXCEL_ABST_MANIP has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TY_S_CLIPBOARD_LINE	Protected	See coding			20130708	BEGIN OF ty_s_clipboard_line, line(4096) TYPE c, END OF ty_s_clipboard_line
2	TY_T_CLIPBOARD_LINE	Protected	See coding			20130708	ty_t_clipboard_line TYPE TABLE OF ty_s_clipboard_line

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_FILE_NAME	Call by reference	☐	Type reference (TYPE)	RLGRAP-FILENAME		Local file for upload/download	20130708

Method CONSTRUCTOR on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method READ_CYCLE_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CB_EXL_CYCLE	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_CYCLE		EPIC: table type for EPIC_S_CB_EXL_CYCLE	20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method READ_CYCLE_DATA on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method READ_CYCLE_DATA_ONE_ROUND Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CB_EXL_CYCLE	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_CYCLE			20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method READ_CYCLE_DATA_ONE_ROUND on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method READ_LIQUIDITY_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CB_EXL_LQITEM	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_LQITEM		EPIC: table type for EPIC_S_CB_EXL_LQITEM	20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method READ_LIQUIDITY_DATA on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method READ_LIQUIDITY_DATA_ONE_ROUND Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CB_EXL_LQITEM	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_LQITEM		EPIC: table type for EPIC_S_CB_EXL_LQITEM	20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method READ_LIQUIDITY_DATA_ONE_ROUND on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method READ_PLAN_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CB_EXL_PLAN	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_PLAN		EPIC: table type for EPIC_S_CB_EXL_CYCLE	20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method READ_PLAN_DATA on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method READ_PLAN_DATA_ONE_ROUND Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CB_EXL_PLAN	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_PLAN		EPIC: table type for EPIC_S_CB_EXL_PLAN	20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method READ_PLAN_DATA_ONE_ROUND on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method READ_SINGLE_CELL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COLUMN_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
2	Importing	IV_ROW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
4	Returning	RV_VAL	Value transfer	☐	Type reference (TYPE)	STRING			20130708

Method READ_SINGLE_CELL on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method REFRESH_CLIPBOARD Signature

Method REFRESH_CLIPBOARD on class CL_EPIC_CB_EXCEL_ABST_MANIP has no parameter.
Method REFRESH_CLIPBOARD on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_ACTIVE_SHEET Signature

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

Method SET_ACTIVE_SHEET on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_CYCLE_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_CB_EXL_CYCLE	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_CYCLE		EPIC: table type for EPIC_S_CB_EXL_CYCLE_UPLOAD	20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_CYCLE_DATA on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_CYCLE_TITLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_CB_EXL_CYCLE_SHT_TITLE	Call by reference	☐	Type reference (TYPE)	EPIC_S_CB_EXL_CYCLE_SHT_TITLE		EPIC: Cash budgeting excel cycle sheet title	20130708
2	Importing	IV_ROW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_CYCLE_TITLE on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_CYCLE_TITLE_SHORT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_CB_EXL_CYCLE_SHT_TTL_ST	Call by reference	☐	Type reference (TYPE)	EPIC_S_CB_EXL_CYCLE_SHT_TTL_ST		EPIC: Cash budget excel cycle sheet title short	20130708
2	Importing	IV_ROW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_CYCLE_TITLE_SHORT on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_LIQUIDITY_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_CB_EXL_LQITEM	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_LQITEM		EPIC: table type for EPIC_S_CB_EXL_LQITEM	20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_LIQUIDITY_DATA on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_LIQUIDITY_TITLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_CB_EXL_LQITEM_SHT_TITLE	Call by reference	☐	Type reference (TYPE)	EPIC_S_CB_EXL_LQITEM_SHT_TITLE		EPIC: Cash budgeting excel liquidity item sheet title	20130708
2	Importing	IV_ROW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_LIQUIDITY_TITLE on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_ORG_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_CB_EXL_ORG	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_ORG		EPIC: Table type for EPIC_S_CB_EXL_ORG	20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_ORG_DATA on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_ORG_TITLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_CB_EXL_ORG_SHT_TITLE	Call by reference	☐	Type reference (TYPE)	EPIC_S_CB_EXL_ORG_SHT_TITLE		EPIC: Cash budgeting excel cycle sheet title	20130708
2	Importing	IV_ROW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_ORG_TITLE on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_PLAN_TITLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_CB_EXL_PLAN_SHT_TITLE	Call by reference	☐	Type reference (TYPE)	EPIC_S_CB_EXL_PLAN_SHT_TITLE		EPIC: Cash budgeting excel plan sheet title	20130708
2	Importing	IV_ROW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_PLAN_TITLE on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_REPORT_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_CB_EXL_REPORT	Call by reference	☐	Type reference (TYPE)	EPIC_T_CB_EXL_REPORT		EPIC: Cash budget table type for EPIC_S_CB_EXL_REPORT	20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_START_ROW	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_REPORT_DATA on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_REPORT_TITLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_CB_EXL_REPORT_SHT_TITLE	Call by reference	☐	Type reference (TYPE)	EPIC_S_CB_EXL_REPORT_SHT_TITLE		EPIC: Cash budget excel report sheet title	20130708
2	Importing	IV_ROW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_REPORT_TITLE on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_SHEET_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SHEET_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20130708
2	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708

Method SET_SHEET_NAME on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SET_SINGLE_CELL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COLUMN_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
2	Importing	IV_ROW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
3	Importing	IV_SHEET_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20130708
4	Importing	IV_VAL	Call by reference	☐	Type reference (TYPE)	STRING			20130708

Method SET_SINGLE_CELL on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

Method SPLIT_ITEM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_TAB	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20130708
2	Importing	IT_EXCEL_TAB	Call by reference	☐	Type reference (TYPE)	TY_T_CLIPBOARD_LINE			20130708

Method SPLIT_ITEM on class CL_EPIC_CB_EXCEL_ABST_MANIP has no exception.

History

Last changed by/on	SAP	20131127
SAP Release Created in