SAP ABAP Class CL_FDT_DT_EXCEL (FDT: Decision Table Excel Integrator)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-BR (Application Component) BRFplus - ABAP-Based Business Rules
     ⤷ SFDT_EXCEL_API (Package) Main api for handling Excel documents

Properties

Class	CL_FDT_DT_EXCEL
Short Description	FDT: Decision Table Excel Integrator
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SFDT_EXCEL_API	Main api for handling Excel documents
Created	20080617	SAP
Last change	20130531	SAP
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	CL_FDT_DECISION_TABLE	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)
3	CL_FDT_EXPR_SV	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)
4	IF_FDT_CONSTANTS	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
5	IF_FDT_DECISION_TABLE	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
6	IF_FDT_DOC_SPREADSHEET	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
7	IF_FDT_ELEMENT	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
8	IF_FDT_RANGE	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
9	IF_FDT_TYPES	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...

Interfaces

Class CL_FDT_DT_EXCEL has no interface implemented.

Friends

Class CL_FDT_DT_EXCEL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GTH_COL_NAMES	Static Attribute	Private	☐	Type reference (TYPE)	TH_COL_NAMES			20120630
2	GTS_COL_NAME	Static Attribute	Private	☐	Type reference (TYPE)	TS_COL_NAME		Used Column Names	20120630
3	MO_DECISION_TABLE	Instance attribute	Private	☐	Object reference (TYPE REF TO)	IF_FDT_DECISION_TABLE			20090209
4	MR_ALIAS_COL_DATA	Instance attribute	Private	☐	Object reference (TYPE REF TO)	DATA			20130213
5	MR_MAPPING_COL_DATA	Instance attribute	Private	☐	Object reference (TYPE REF TO)	DATA			20120629
6	MT_COLUMN	Static Attribute	Private	☐	Type reference (TYPE)	IF_FDT_DOC_SPREADSHEET=>T_COLUMN			20111003
7	MT_MAPPING_COLUMN	Instance attribute	Private	☐	Type reference (TYPE)	IF_FDT_DOC_SPREADSHEET=>T_COLUMN			20120629
8	MV_IMPORT_UUID_AS_TEXT	Instance attribute	Private	☐	Type reference (TYPE)	BOOLE_D		True if object Id's should be imported as text	20111104
9	MV_OVERRIDE_EXPRESSIONS	Instance attribute	Private	☐	Type reference (TYPE)	BOOLE_D		True if named expressions have to be overridden	20111017
10	MV_TIMESTAMP	Instance attribute	Private	☐	Type reference (TYPE)	IF_FDT_TYPES=>TIMESTAMP		Time Stamp (active version)	20090209

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	APPLY_CONVERSION_ROUTINE	Instance method	Private	Method	Apply the conversion routines on the table cell values	20120914
2	CONSTRUCTOR	Instance method	Public	Constructor	Creates a CL_FDT_DT_EXCEL object loading decision table data	20080618
3	CREATE_DYNAMIC_STRUCTURE	Instance method	Private	Method	Creates a dynamic structure to store decision table data	20080618
4	CREATE_EXCEL_CONTENT	Instance method	Private	Method	Creates an excel content with decision table data	20080618
5	CREATE_EXCEL_FROM_DEC_TAB	Static method	Public	Method	Creates an excel spreadsheet from the decision table data	20110131
6	CREATE_SIMPLE_VALUE	Instance method	Private	Method	Creates an expression depending on the exp type	20090209
7	CREATE_TABLE_CELL	Instance method	Private	Method	Create decision table cell from excel cell data	20111017
8	FORMAT_EXCEL_DATA	Instance method	Private	Method	Converts the data to decision table data format	20090209
9	GET_ALIAS_NAME	Instance method	Private	Method	Get the alias name for duplicate columns in Decision Table	20120630
10	GET_FORMATTED_DT_COL	Instance method	Private	Method	Gets the column description of decision table	20111215
11	GET_FORMATTED_DT_DATA	Instance method	Private	Method	Get decision table data in excel compatible format	20080618
12	MODIFY_DECTAB_FROM_EXCEL	Instance method	Public	Method	Gets the decision table data from the excel spreadsheet	20100921

Events

Class CL_FDT_DT_EXCEL has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	S_COL_ALIAS	Public	See coding			20120629	BEGIN OF s_col_alias, alias_name TYPE if_fdt_types=>name, col_id TYPE if_fdt_types=>id, END OF s_col_alias
2	S_COL_CONV_ROUT	Private	See coding			20120914	BEGIN OF S_COL_CONV_ROUT, col_no TYPE int4, conv_rout TYPE string, ref_data TYPE REF TO DATA, END OF S_COL_CONV_ROUT
3	S_COL_DESC	Private	See coding			20111003	BEGIN OF s_col_desc, col_name TYPE if_fdt_types=>name, col_text TYPE if_fdt_types=>text, col_is_res TYPE abap_bool, col_type TYPE string, col_binding TYPE string, col_length TYPE fdt_element_length , col_decimal TYPE fdt_element_decimals, col_positive TYPE abap_bool, col_uppercase TYPE abap_bool, col_tp_type TYPE string, col_dim_key TYPE fdt_quantity_dimension , END OF s_col_desc
4	S_COL_NAMES	Private	See coding			20120629	BEGIN OF S_COL_NAMES , col_name TYPE char30, number TYPE i, END OF S_COL_NAMES
5	S_COND_CELL	Private	See coding			20111017	BEGIN OF s_cond_cell, col_no TYPE int4, col_id TYPE if_fdt_types=>id, range_str TYPE string, rows TYPE string, counter TYPE i, END OF s_cond_cell
6	S_MAP_COL_DATA	Public	See coding			20120629	BEGIN OF s_map_col_data, col_name TYPE string, alias_name TYPE if_fdt_types=>name, id TYPE if_fdt_types=>id, END OF s_map_col_data
7	S_RESULT_CELL	Private	See coding			20111017	BEGIN OF s_result_cell, col_no TYPE int4, col_id TYPE if_fdt_types=>id, value_str TYPE string, rows TYPE string, counter TYPE i, END OF s_result_cell
8	S_TABLE_DATA	Private	See coding			20100805	BEGIN OF s_table_data, col_no TYPE int4, row_no TYPE int4, expression_id TYPE if_fdt_types=>id, s_value TYPE cl_fdt_expr_sv=>s_value, ts_range TYPE cl_fdt_expr_sv=>ts_range, END OF s_table_data
9	TH_COL_CONV_ROUT	Private	See coding			20120914	TH_COL_CONV_ROUT TYPE SORTED TABLE OF S_COL_CONV_ROUT WITH UNIQUE KEY col_no
10	TH_COL_EXCEL_DATA	Public	See coding			20121129	TH_COL_EXCEL_DATA TYPE TABLE OF TS_COL_EXCEL_DATA
11	TH_COL_NAMES	Private	See coding			20120629	TH_COL_NAMES TYPE HASHED TABLE OF s_col_names WITH UNIQUE KEY col_name
12	TS_COL_ALIAS	Public	See coding			20120629	ts_col_alias TYPE STANDARD TABLE OF s_col_alias
13	TS_COL_DESC	Private	See coding			20111003	ts_col_desc TYPE STANDARD TABLE OF s_col_desc
14	TS_COL_EXCEL_DATA	Public	See coding			20121129	BEGIN OF TS_COL_EXCEL_DATA, col_no TYPE int4, row_no TYPE int4, column_data TYPE string , END OF TS_COL_EXCEL_DATA
15	TS_COL_NAME	Private	See coding			20120629	TS_COL_NAME TYPE HASHED TABLE OF string WITH UNIQUE DEFAULT KEY
16	TS_COND_CELL	Private	See coding			20111017	ts_cond_cell TYPE STANDARD TABLE OF s_cond_cell WITH NON-UNIQUE KEY col_no range_str
17	TS_MAP_COL_DATA	Public	See coding			20120629	ts_map_col_data TYPE STANDARD TABLE OF s_map_col_data
18	TS_RESULT_CELL	Private	See coding			20111017	ts_result_cell TYPE SORTED TABLE OF s_result_cell WITH UNIQUE KEY col_no value_str
19	TS_TABLE_DATA	Private	See coding			20100805	ts_table_data TYPE SORTED TABLE OF s_table_data WITH UNIQUE KEY col_no row_no

Method Signatures

Method APPLY_CONVERSION_ROUTINE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CS_VALUE	Call by reference	☑	Type reference (TYPE)	CL_FDT_EXPR_SV=>S_VALUE		Simple Value	20120917
2	Changing	CTS_RANGE	Call by reference	☑	Type reference (TYPE)	CL_FDT_EXPR_SV=>TS_RANGE		Range Table (internal)	20120917
3	Importing	ITH_COL_CONV_ROUT	Call by reference	☐	Type reference (TYPE)	TH_COL_CONV_ROUT		Table of fields with their conversion routine	20120917
4	Importing	IV_COL_NO	Call by reference	☐	Type reference (TYPE)	INT4		Column Number	20120917

#	Exception	Resumable	Description	Created on
1	CX_FDT_EXCEL	☐	FDT: Export/Import to Excel errors	20130426

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_ID	Call by reference	☐	Type reference (TYPE)	IF_FDT_TYPES=>ID			20080618
2	Importing	IV_IMPORT_UUID_AS_TEXT	Call by reference	☐	Type reference (TYPE)	BOOLE_D	ABAP_FALSE	'X': Import Object Id's as text	20111104
3	Importing	IV_OVERRIDE_EXPRESSIONS	Call by reference	☐	Type reference (TYPE)	BOOLE_D	ABAP_FALSE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	20111017
4	Importing	IV_OVERRIDE_NOT_SUPPORTED	Call by reference	☐	Type reference (TYPE)	BOOLE_D	ABAP_FALSE	(OBSOLETE parameter, use iv_override_expressions instead )	20111022
5	Importing	IV_TIMESTAMP	Call by reference	☑	Type reference (TYPE)	IF_FDT_TYPES=>TIMESTAMP		Time Stamp (active version)	20090209

#	Exception	Resumable	Description	Created on
1	CX_FDT_EXCEL	☐		20080618

Method CREATE_DYNAMIC_STRUCTURE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ER_ELEMENT_STRUCTURE	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20110201
2	Exporting	ER_ELEMENT_TABLE	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20110201
3	Importing	IV_FROM_IMPORT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20110906

Method CREATE_DYNAMIC_STRUCTURE on class CL_FDT_DT_EXCEL has no exception.

Method CREATE_EXCEL_CONTENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_CONTENT	Call by reference	☐	Type reference (TYPE)	XSTRING			20080618
2	Importing	IR_COL_DESC_DATA	Call by reference	☑	Type reference (TYPE)	DATA			20111003
3	Importing	IR_TABLE_DATA	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20110201
4	Importing	IV_DOCUMENT_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20080618
5	Importing	IV_TECHNICAL_MODE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20110201

#	Exception	Resumable	Description	Created on
1	CX_FDT_EXCEL	☐		20080618

Method CREATE_EXCEL_FROM_DEC_TAB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_CONTENT	Call by reference	☐	Type reference (TYPE)	XSTRING			20110131
2	Importing	IV_DOCUMENT_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20110131
3	Importing	IV_ID	Call by reference	☐	Type reference (TYPE)	IF_FDT_TYPES=>ID			20110131
4	Importing	IV_TECHNICAL_MODE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20110201
5	Importing	IV_TIMESTAMP	Call by reference	☑	Type reference (TYPE)	IF_FDT_TYPES=>TIMESTAMP		Time Stamp (active version)	20110131

#	Exception	Resumable	Description	Created on
1	CX_FDT_EXCEL	☐		20110131

Method CREATE_SIMPLE_VALUE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ER_CONST_VALUE	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20090209
2	Exporting	ES_VALUE	Call by reference	☐	Type reference (TYPE)	CL_FDT_EXPR_SV=>S_VALUE		Simple Value	20100916
3	Exporting	ETS_RANGE	Call by reference	☐	Type reference (TYPE)	CL_FDT_EXPR_SV=>TS_RANGE		Range Table	20090209
4	Exporting	ET_MESSAGE	Call by reference	☐	Type reference (TYPE)	IF_FDT_TYPES=>T_MESSAGE		Error message for invalid data	20101206
5	Importing	IV_CELL_VALUE	Call by reference	☐	Type reference (TYPE)	STRING			20090209
6	Importing	IV_COLUMN_ID	Call by reference	☐	Type reference (TYPE)	IF_FDT_TYPES=>ID			20090209
7	Importing	IV_EXPR_TYPE	Call by reference	☐	Type reference (TYPE)	IF_FDT_TYPES=>ID			20090209

#	Exception	Resumable	Description	Created on
1	CX_FDT_EXCEL	☐		20090209

Method CREATE_TABLE_CELL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CTS_CONDITION	Call by reference	☐	Type reference (TYPE)	TS_COND_CELL			20111017
2	Changing	CTS_RESULT	Call by reference	☐	Type reference (TYPE)	TS_RESULT_CELL			20111017
3	Changing	CTS_TABLE_DATA	Call by reference	☐	Type reference (TYPE)	CL_FDT_DECISION_TABLE=>TS_TABLE_DATA			20111017
4	Importing	IS_CELL_DATA	Call by reference	☐	Type reference (TYPE)	CL_FDT_DECISION_TABLE=>S_TABLE_DATA		Original cell data	20111022
5	Importing	IS_COLUMN	Call by reference	☐	Type reference (TYPE)	IF_FDT_DECISION_TABLE=>S_COLUMN		Column of the decision table	20111017
6	Importing	IV_COL_NO	Call by reference	☐	Type reference (TYPE)	IF_FDT_DECISION_TABLE=>S_TABLE_DATA-COL_NO		Column no	20111017
7	Importing	IV_ROW_NO	Call by reference	☐	Type reference (TYPE)	IF_FDT_DECISION_TABLE=>S_TABLE_DATA-ROW_NO		Row no	20111017
8	Importing	IV_VALUE_STRING	Call by reference	☐	Type reference (TYPE)	STRING		Cell value from excel	20111017

Method CREATE_TABLE_CELL on class CL_FDT_DT_EXCEL has no exception.

Method FORMAT_EXCEL_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ETS_PACKED	Call by reference	☐	Type reference (TYPE)	CL_FDT_DECISION_TABLE=>TS_PACKED			20100916
2	Exporting	ETS_TABLE_DATA	Call by reference	☐	Type reference (TYPE)	CL_FDT_DECISION_TABLE=>TS_TABLE_DATA			20100916
3	Exporting	ET_COL_EXCEL_DATA	Call by reference	☐	Type reference (TYPE)	TH_COL_EXCEL_DATA			20121129
4	Exporting	EV_ROW_COUNT	Call by reference	☐	Type reference (TYPE)	I			20100921
5	Importing	IR_TABLE_DATA	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20110201
6	Importing	IT_COL_CONV_ROUT	Call by reference	☑	Type reference (TYPE)	TH_COL_CONV_ROUT			20120917

#	Exception	Resumable	Description	Created on
1	CX_FDT_EXCEL	☐		20090209

Method GET_ALIAS_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_COL_NAME	Call by reference	☐	Type reference (TYPE)	IF_FDT_TYPES=>NAME		Column of the decision table	20120630
2	Returning	RV_ALIAS_NAME	Value transfer	☐	Type reference (TYPE)	STRING		Alias Name	20120630

Method GET_ALIAS_NAME on class CL_FDT_DT_EXCEL has no exception.

Method GET_FORMATTED_DT_COL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RR_TABLE_DATA	Value transfer	☐	Object reference (TYPE REF TO)	DATA			20111215

#	Exception	Resumable	Description	Created on
1	CX_FDT_EXCEL	☐	FDT: Export/Import to Excel errors	20111215

Method GET_FORMATTED_DT_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RR_TABLE_DATA	Value transfer	☐	Object reference (TYPE REF TO)	DATA			20110201

#	Exception	Resumable	Description	Created on
1	CX_FDT_EXCEL	☐		20080618

Method MODIFY_DECTAB_FROM_EXCEL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_COL_EXCEL_DATA	Call by reference	☐	Type reference (TYPE)	TH_COL_EXCEL_DATA			20121129
2	Importing	IV_CONTENT	Call by reference	☐	Type reference (TYPE)	XSTRING			20100921
3	Importing	IV_FILE_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20100921

#	Exception	Resumable	Description	Created on
1	CX_FDT_EXCEL	☐		20100921

History

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