SAP ABAP Class CL_BSCL_SQL_STATEMENT (Basic functions for SQL generation)

Hierarchy

☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-CL (Application Component) Classification
     ⤷ BSCL_VIEW_KIT (Package) Classification: Tools for view generation

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_BSCL_DDL_VIEW_STATEMENT	SQL for views	20130118
2	Interface implementation (CLASS c. INTERFACES i_ref)	IF_BSCL_DML_SELECT_STATEMENT	SQL for views	20130118
3	Interface implementation (CLASS c. INTERFACES i_ref)	IF_BSCL_SQL_FUNCTION_UTILITY	Utility for SQL functions	20130121
4	Interface implementation (CLASS c. INTERFACES i_ref)	IF_BSCL_SQL_STATEMENT	General SQL behavior	20121112
5	Interface implementation (CLASS c. INTERFACES i_ref)	IF_BSCL_SQL_STATEMNT_CONSTANTS	General SQL behavior	20130125
6	Interface implementation (CLASS c. INTERFACES i_ref)	IF_BSCL_SQL_TYPES	Types for SQL generation	20121102

Properties

Class	CL_BSCL_SQL_STATEMENT
Short Description	Basic functions for SQL generation
Super Class
Instantiability of a Class	0	Private
Final	☑

General Data

Message Class
Program status
Category	0
Package	BSCL_VIEW_KIT	Classification: Tools for view generation
Created	20121102	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	IF_BSCL_SQL_TYPES	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_BSCL_DDL_VIEW_STATEMENT	☐	☐	SQL for views	20130118
2	IF_BSCL_DML_SELECT_STATEMENT	☐	☐	SQL for views	20130118
3	IF_BSCL_SQL_FUNCTION_UTILITY	☐	☐	Utility for SQL functions	20130121
4	IF_BSCL_SQL_STATEMENT	☐	☐	General SQL behavior	20121112
5	IF_BSCL_SQL_STATEMNT_CONSTANTS	☐	☐	General SQL behavior	20130125
6	IF_BSCL_SQL_TYPES	☐	☐	Types for SQL generation	20121102

Friends

Class CL_BSCL_SQL_STATEMENT has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	MC_AND	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
2	MC_APOSTROPHE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
3	MC_AS	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
4	MC_CASE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
5	MC_COLON	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
6	MC_COMMA	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
7	MC_CREATE_VIEW	Instance attribute	Private	☐	Attribute reference (LIKE)				20130118
8	MC_DROP_VIEW	Instance attribute	Private	☐	Attribute reference (LIKE)				20130118
9	MC_ELSE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130301
10	MC_ELSE_NULL	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
11	MC_END	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
12	MC_EQUALS	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
13	MC_FROM	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
14	MC_FULL_OUTER_JOIN	Instance attribute	Private	☐	Attribute reference (LIKE)				20130426
15	MC_FUNCTION_LPAD	Instance attribute	Private	☐	Attribute reference (LIKE)				20130219
16	MC_FUNCTION_TO_CHAR	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
17	MC_FUNCTION_TO_DECIMAL	Instance attribute	Private	☐	Attribute reference (LIKE)				20130219
18	MC_INNER_JOIN	Instance attribute	Private	☐	Attribute reference (LIKE)				20130426
19	MC_LEFT_OUTER_JOIN	Instance attribute	Private	☐	Attribute reference (LIKE)				20130426
20	MC_MINUS	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
21	MC_NULL	Instance attribute	Private	☐	Attribute reference (LIKE)				20130423
22	MC_ON	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
23	MC_OR	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
24	MC_PARENTHESIS_CLOSE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
25	MC_PARENTHESIS_OPEN	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
26	MC_PLUS	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
27	MC_POSITIVE_INDICATOR	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
28	MC_QUOTATION	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
29	MC_RIGHT_OUTER_JOIN	Instance attribute	Private	☐	Attribute reference (LIKE)				20130426
30	MC_SELECT_DISTINCT	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
31	MC_SEMICOLON	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
32	MC_SPACE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
33	MC_SQUARE_BRACKET_CLOSE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
34	MC_SQUARE_BRACKET_OPEN	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
35	MC_STATEMENT_TYPE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130118
36	MC_THEN	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
37	MC_TIMES	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
38	MC_UNDERSCORE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
39	MC_VALUES	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
40	MC_WHEN	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
41	MC_WHERE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130125
42	MS_ANCHOR	Instance attribute	Private	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES~TY_SUBJECT			20121109
43	MS_SUBJECT	Instance attribute	Private	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES~TY_SUBJECT		Name of table or view	20121109
44	MT_JOINS	Instance attribute	Private	☐	Type reference (TYPE)	TT_JOINS			20121102
45	MT_VIEW_COLUMNS	Instance attribute	Private	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES~TT_VIEW_COLUMNS			20121102
46	MT_WHERE_CONDITIONS	Instance attribute	Private	☐	Type reference (TYPE)	TT_FIELD_VALUES		Where conditions	20121102
47	MV_ANCHOR_ALIAS	Instance attribute	Private	☐	Type reference (TYPE)	STRING		Alias for main table	20121102
48	MV_BASE_STATEMENT	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20121102
49	MV_JOIN_SEGMENT	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20121102
50	MV_KEY_WORD	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20121102

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_COLUMNS	Instance method	Private	Method		20130118
2	ADD_JOINS	Instance method	Private	Method		20130118
3	ADD_WHERE_CONDITIONS	Instance method	Private	Method		20130118
4	APPLY_CONVERSION	Instance method	Private	Method	Apply conversion function to field	20121102
5	APPLY_CONVERSIONS	Instance method	Private	Method	Apply conversion functions to field	20130301
6	ASSEMBLE_CASE	Instance method	Private	Method		20121120
7	ASSEMBLE_COLUMN	Instance method	Private	Method	Assemble column snippet	20121120
8	ASSEMBLE_ELSE_SNIPPET	Instance method	Private	Method	Get list of cases as snippet	20130301
9	ASSEMBLE_FIELD_EQUALITY	Instance method	Private	Method	Assemble equality statement for equivalent fields	20121102
10	ASSEMBLE_JOIN	Instance method	Private	Method	Assmeble individual join snippet	20121102
11	ASSEMBLE_LIST	Instance method	Private	Method	Create a list separated by commas	20121102
12	ASSEMBLE_MAPPING_FROM	Instance method	Private	Method	Assemble case snippet	20130301
13	ASSEMBLE_MAPPING_TO	Instance method	Private	Method	Assemble case snippet	20130301
14	ASSEMBLE_PREDICATE	Instance method	Private	Method	Assemble predicate	20121114
15	ASSEMBLE_VALUE_COMPARISON	Instance method	Private	Method	Assemble equality statement wrt a given value	20130228
16	ASSEMBLE_WHEN_THEN_SNIPPET	Instance method	Private	Method	Get list of cases as snippet	20121120
17	AS_ALIAS	Instance method	Private	Method	Assemble "as" snippet	20121102
18	COMPOSE_DELIMITED_NAME	Instance method	Public	Method		20121112
19	COMPOSE_NAME	Instance method	Public	Method		20121112
20	CONSTRUCTOR	Instance method	Private	Constructor		20121102
21	CREATE_LITERAL	Instance method	Private	Method	Give a value create a literal for it	20121102
22	CREATE_ROW	Instance method	Private	Method	Given a list of values, create a row out of it	20121102
23	CREATE_STATEMENT	Static method	Public	Method	Create reference for a table statement	20130118
24	DELIMIT	Static method	Private	Method	Surround with delimiters	20130131
25	GET_ANCHOR_TABLE_NAME	Instance method	Private	Method	Get anchor table for join	20121102
26	GET_CREATE_VIEW_STATEMENT	Instance method	Private	Method	Assemble "create view" snippet	20130118
27	GET_DROP_VIEW_STATEMENT	Instance method	Private	Method	Assemble "drop view" statement	20130118
28	GET_INDEX_FOR_DECIMALS	Instance method	Public	Method		20130121
29	GET_INDEX_FOR_LENGTH	Instance method	Public	Method		20130121
30	GET_INDEX_FOR_PAD	Instance method	Public	Method		20130219
31	GET_JOINS_SNIPPET	Instance method	Private	Method	Assemble "left outer join" snippet	20121102
32	GET_RESERVED_WORDS	Static method	Private	Method	Get reserved characters	20121113
33	GET_SELECT_STATEMENT	Instance method	Private	Method	Assemble "create view" snippet	20130118
34	GET_SORTED_LIST_OF_ARGUMENTS	Instance method	Private	Method	Get sorted list of conversion arguments	20130121
35	GET_STATEMENT	Instance method	Private	Method		20121112
36	GET_VIEW_COLUMNS_SNIPPET	Instance method	Private	Method	Get view columns	20121102
37	GET_VIEW_NAME	Instance method	Private	Method		20130118
38	GET_WHERE_CONDITIONS_SNIPPET	Instance method	Private	Method	Assemble "where" snippet	20121102
39	REMOVE_RESERVED_WORDS	Static method	Private	Method	Remove reserved words reserved for SQL	20121113
40	SET_ANCHOR_TABLE	Instance method	Private	Method		20130118
41	SET_VIEW	Instance method	Private	Method		20130118

Events

Class CL_BSCL_SQL_STATEMENT has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TT_CONVERSION_ARGUMENTS	Private	Attribute reference (LIKE)			20130121
2	TT_FIELD_PREDICATES	Private	Attribute reference (LIKE)			20121105
3	TT_FIELD_VALUES	Private	Attribute reference (LIKE)			20121102
4	TT_JOINS	Private	Attribute reference (LIKE)			20121102
5	TT_TABLE_COLUMNS	Private	Attribute reference (LIKE)			20121102
6	TT_TABLE_FIELDS	Private	Attribute reference (LIKE)			20121102
7	TT_VIEW_COLUMNS	Private	Attribute reference (LIKE)			20121102
8	TY_FIELD_PAIR	Private	Attribute reference (LIKE)			20121105
9	TY_FIELD_PREDICATE	Private	Attribute reference (LIKE)			20121105
10	TY_FIELD_VALUE	Private	Attribute reference (LIKE)			20121102
11	TY_JOIN	Private	Attribute reference (LIKE)			20121102
12	TY_SQL_FUNCTION	Private	Attribute reference (LIKE)			20121105
13	TY_TABLE_COLUMN	Private	Attribute reference (LIKE)			20121102
14	TY_TABLE_FIELD	Private	Attribute reference (LIKE)			20121102
15	TY_VIEW_COLUMN	Private	Attribute reference (LIKE)			20121102

Method Signatures

Method ADD_COLUMNS Signature

Method ADD_COLUMNS on class CL_BSCL_SQL_STATEMENT has no parameter.
Method ADD_COLUMNS on class CL_BSCL_SQL_STATEMENT has no exception.

Method ADD_JOINS Signature

Method ADD_JOINS on class CL_BSCL_SQL_STATEMENT has no parameter.
Method ADD_JOINS on class CL_BSCL_SQL_STATEMENT has no exception.

Method ADD_WHERE_CONDITIONS Signature

Method ADD_WHERE_CONDITIONS on class CL_BSCL_SQL_STATEMENT has no parameter.
Method ADD_WHERE_CONDITIONS on class CL_BSCL_SQL_STATEMENT has no exception.

Method APPLY_CONVERSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CONVERSION	Call by reference	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES=>TY_SQL_FUNCTION			20121102
2	Importing	IV_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20121102
3	Returning	RV_FIELD	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method APPLY_CONVERSION on class CL_BSCL_SQL_STATEMENT has no exception.

Method APPLY_CONVERSIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_CONVERSIONS	Call by reference	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES=>TT_SQL_FUNCTIONS			20130301
2	Importing	IV_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20130301
3	Returning	RV_FIELD	Value transfer	☐	Type reference (TYPE)	STRING			20130301

Method APPLY_CONVERSIONS on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_CASE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_MAPPED_VALUES	Call by reference	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES=>TT_VALUE_MAPPINGS			20121120
2	Importing	IV_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20121120
3	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121120

Method ASSEMBLE_CASE on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_COLUMN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_COLUMN	Call by reference	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES~TY_VIEW_COLUMN			20121120
2	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121120

Method ASSEMBLE_COLUMN on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_ELSE_SNIPPET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_MAPPED_VALUES	Call by reference	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES=>TT_VALUE_MAPPINGS			20130301
2	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20130301

Method ASSEMBLE_ELSE_SNIPPET on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_FIELD_EQUALITY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_FIELD_PAIR	Call by reference	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES=>TY_FIELD_PAIR			20121102
2	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method ASSEMBLE_FIELD_EQUALITY on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_JOIN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_JOIN	Call by reference	☐	Type reference (TYPE)	TY_JOIN			20121102
2	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method ASSEMBLE_JOIN on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_ITEMS	Call by reference	☐	Type reference (TYPE)	STRINGTAB		Table with Strings	20121102
2	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method ASSEMBLE_LIST on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_MAPPING_FROM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_REFERENCE_VALUES	Call by reference	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES=>TT_REFERENCE_VALUES			20130301
2	Importing	IV_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20130301
3	Importing	IV_REFERENCE_VALUES_CONJ	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20130423
4	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20130301

Method ASSEMBLE_MAPPING_FROM on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_MAPPING_TO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_NEW_VALUE	Call by reference	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES=>TY_VALUE_ADJUSTMENT			20130301
2	Importing	IV_FIELD	Call by reference	☑	Type reference (TYPE)	STRING			20130301
3	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20130301

Method ASSEMBLE_MAPPING_TO on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_PREDICATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_PREDICATE	Call by reference	☐	Type reference (TYPE)	TY_FIELD_PREDICATE			20121114
2	Importing	IV_REF_TABLE	Call by reference	☐	Type reference (TYPE)	STRING			20121114
3	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121114

Method ASSEMBLE_PREDICATE on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_VALUE_COMPARISON Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_FIELD	Call by reference	☐	Type reference (TYPE)	TY_FIELD_VALUE			20130228
2	Importing	IV_COMPARATOR	Call by reference	☐	Type reference (TYPE)	STRING	MC_EQUALS		20130228
3	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20130228

Method ASSEMBLE_VALUE_COMPARISON on class CL_BSCL_SQL_STATEMENT has no exception.

Method ASSEMBLE_WHEN_THEN_SNIPPET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_MAPPED_VALUES	Call by reference	☐	Type reference (TYPE)	IF_BSCL_SQL_TYPES=>TT_VALUE_MAPPINGS			20121120
2	Importing	IV_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20121120
3	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121120

Method ASSEMBLE_WHEN_THEN_SNIPPET on class CL_BSCL_SQL_STATEMENT has no exception.

Method AS_ALIAS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_ALIAS	Call by reference	☐	Type reference (TYPE)	STRING			20121102
2	Importing	IV_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20121102
3	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method AS_ALIAS on class CL_BSCL_SQL_STATEMENT has no exception.

Method COMPOSE_DELIMITED_NAME Signature

Method COMPOSE_DELIMITED_NAME on class CL_BSCL_SQL_STATEMENT has no parameter.
Method COMPOSE_DELIMITED_NAME on class CL_BSCL_SQL_STATEMENT has no exception.

Method COMPOSE_NAME Signature

Method COMPOSE_NAME on class CL_BSCL_SQL_STATEMENT has no parameter.
Method COMPOSE_NAME on class CL_BSCL_SQL_STATEMENT has no exception.

Method CONSTRUCTOR Signature

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

Method CONSTRUCTOR on class CL_BSCL_SQL_STATEMENT has no exception.

Method CREATE_LITERAL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_VALUE	Call by reference	☐	Type reference (TYPE)	STRING			20121102
2	Returning	RV_LITERAL	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method CREATE_LITERAL on class CL_BSCL_SQL_STATEMENT has no exception.

Method CREATE_ROW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_VALUES	Call by reference	☐	Type reference (TYPE)	STRINGTAB		Table with Strings	20121102
2	Returning	RV_ROW	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method CREATE_ROW on class CL_BSCL_SQL_STATEMENT has no exception.

Method CREATE_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_KEY_WORD	Call by reference	☐	Type reference (TYPE)	STRING			20130118
2	Returning	RO_STATEMENT	Value transfer	☐	Object reference (TYPE REF TO)	OBJECT		SQL for tables	20130118

Method CREATE_STATEMENT on class CL_BSCL_SQL_STATEMENT has no exception.

Method DELIMIT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_TEXT	Call by reference	☐	Type reference (TYPE)	STRING			20130131
2	Returning	RV_RESULT	Value transfer	☐	Type reference (TYPE)	STRING			20130131

Method DELIMIT on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_ANCHOR_TABLE_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_NAME	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method GET_ANCHOR_TABLE_NAME on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_CREATE_VIEW_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COLUMNS_SNIPPET	Call by reference	☐	Type reference (TYPE)	STRING		Table with Strings	20130118
2	Importing	IV_JOINS_SNIPPET	Call by reference	☑	Type reference (TYPE)	STRING		Table with Strings	20130118
3	Importing	IV_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20130118
4	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20130118
5	Importing	IV_WHERE_SNIPPET	Call by reference	☑	Type reference (TYPE)	STRING		Table with Strings	20130118
6	Returning	RV_STATEMENT	Value transfer	☐	Type reference (TYPE)	STRING			20130118

Method GET_CREATE_VIEW_STATEMENT on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_DROP_VIEW_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20130118
2	Returning	RV_STATEMENT	Value transfer	☐	Type reference (TYPE)	STRING			20130118

Method GET_DROP_VIEW_STATEMENT on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_INDEX_FOR_DECIMALS Signature

Method GET_INDEX_FOR_DECIMALS on class CL_BSCL_SQL_STATEMENT has no parameter.
Method GET_INDEX_FOR_DECIMALS on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_INDEX_FOR_LENGTH Signature

Method GET_INDEX_FOR_LENGTH on class CL_BSCL_SQL_STATEMENT has no parameter.
Method GET_INDEX_FOR_LENGTH on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_INDEX_FOR_PAD Signature

Method GET_INDEX_FOR_PAD on class CL_BSCL_SQL_STATEMENT has no parameter.
Method GET_INDEX_FOR_PAD on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_JOINS_SNIPPET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method GET_JOINS_SNIPPET on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_RESERVED_WORDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RT_RESERVED_CHARACTERS	Value transfer	☐	Type reference (TYPE)	STRINGTAB		Table with Strings	20121113

Method GET_RESERVED_WORDS on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_SELECT_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_COLUMNS_SNIPPET	Call by reference	☐	Type reference (TYPE)	STRING		Table with Strings	20130118
2	Importing	IV_JOINS_SNIPPET	Call by reference	☑	Type reference (TYPE)	STRING		Table with Strings	20130118
3	Importing	IV_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20130118
4	Importing	IV_WHERE_SNIPPET	Call by reference	☑	Type reference (TYPE)	STRING		Table with Strings	20130118
5	Returning	RV_STATEMENT	Value transfer	☐	Type reference (TYPE)	STRING			20130118

Method GET_SELECT_STATEMENT on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_SORTED_LIST_OF_ARGUMENTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_ARGUMENTS	Call by reference	☐	Type reference (TYPE)	TT_CONVERSION_ARGUMENTS		Table with Strings	20130121
2	Returning	RT_SORTED	Value transfer	☐	Type reference (TYPE)	STRINGTAB		Table with Strings	20130121

Method GET_SORTED_LIST_OF_ARGUMENTS on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_STATEMENT Signature

Method GET_STATEMENT on class CL_BSCL_SQL_STATEMENT has no parameter.
Method GET_STATEMENT on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_VIEW_COLUMNS_SNIPPET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method GET_VIEW_COLUMNS_SNIPPET on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_VIEW_NAME Signature

Method GET_VIEW_NAME on class CL_BSCL_SQL_STATEMENT has no parameter.
Method GET_VIEW_NAME on class CL_BSCL_SQL_STATEMENT has no exception.

Method GET_WHERE_CONDITIONS_SNIPPET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121102

Method GET_WHERE_CONDITIONS_SNIPPET on class CL_BSCL_SQL_STATEMENT has no exception.

Method REMOVE_RESERVED_WORDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SNIPPET	Call by reference	☐	Type reference (TYPE)	STRING			20121113
2	Returning	RV_SNIPPET	Value transfer	☐	Type reference (TYPE)	STRING			20121113

Method REMOVE_RESERVED_WORDS on class CL_BSCL_SQL_STATEMENT has no exception.

Method SET_ANCHOR_TABLE Signature

Method SET_ANCHOR_TABLE on class CL_BSCL_SQL_STATEMENT has no parameter.
Method SET_ANCHOR_TABLE on class CL_BSCL_SQL_STATEMENT has no exception.

Method SET_VIEW Signature

Method SET_VIEW on class CL_BSCL_SQL_STATEMENT has no parameter.
Method SET_VIEW on class CL_BSCL_SQL_STATEMENT has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in