SAP ABAP Class CL_RSPLS_WS_SQL_SCRIPT_GEN (SQL Script generator for work status)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-PLA (Application Component) Planning
     ⤷ RSPLS (Package) Planning: General Services

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSPLS_WS_SQL_SCRIPT_GEN	SQL Script generator for work status	20130715

Properties

Class	CL_RSPLS_WS_SQL_SCRIPT_GEN
Short Description	SQL Script generator for work status
Super Class
Instantiability of a Class	0	Private
Final	☑

General Data

Message Class
Program status	P	SAP Standard Production Program
Category	0
Package	RSPLS	Planning: General Services
Created	20130711	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	IF_RSBPCW_WS_DEF	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
2	IF_RSPLS_DS_TYPES	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
3	IF_RSPLS_WS_SQL_SCRIPT_GEN	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
4	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_RSPLS_WS_SQL_SCRIPT_GEN	☐	☐	SQL Script generator for work status	20130715

Friends

Class CL_RSPLS_WS_SQL_SCRIPT_GEN has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	N_INV_SQL_PROC	Instance attribute	Private	☐	Attribute reference (LIKE)				20130723
2	N_SESSION_TABLE_TYPE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130802
3	N_SQL_PROC	Instance attribute	Private	☐	Attribute reference (LIKE)				20130723
4	N_TABLE_TYPE	Instance attribute	Private	☐	Attribute reference (LIKE)				20130723
5	P_C_SESSION_TABLE_TYPE	Constant	Private	☐	Type reference (TYPE)	TN_OBJECT_ID	'RSPLS_WS_RUNTIME_DS_TAB_TYPE_SES'	Constant for session table type	20131002
6	P_C_SQL_PROC	Constant	Private	☐	Type reference (TYPE)	TN_OBJECT_ID	'RSPLS_WS_RUNTIME_DS_SCRIPT'	Constant for SQL procedure	20130712
7	P_C_TABLE_TYPE	Constant	Private	☐	Type reference (TYPE)	TN_OBJECT_ID	'RSPLS_WS_RUNTIME_DS_TAB_TYPE'	Constant for table type	20130712
8	P_DEFAULT_STATE	Instance attribute	Private	☐	Type reference (TYPE)	RSBPCW_MODWS		BPC: Module Work Status	20130723
9	P_DRIVER_FIELD	Instance attribute	Private	☐	Type reference (TYPE)	FIELDNAME		Driver field	20130729
10	P_INFOPROV_FIELD	Instance attribute	Private	☐	Type reference (TYPE)	RSINFOPROV		InfoProvider	20130731
11	P_LINE	Instance attribute	Private	☐	Type reference (TYPE)	TP_SQL_LINE		Line of code	20130712
12	P_LOCK_TAB_NAME	Instance attribute	Private	☐	Type reference (TYPE)	TABNAME		Lock table	20130802
13	P_R_PE_ADAPTER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	IF_RSR_PE_ADAPTER		TREX Planning Engine Adapter	20130711
14	P_TS_FIELDS_MAP	Instance attribute	Private	☐	Type reference (TYPE)	IF_RSBPCW_WS_DEF=>TN_TS_FIELD		Tabelle: Merkmale einer Datenscheibe (interne Sicht)	20130711
15	P_TS_INSTANCE	Static Attribute	Private	☐	Type reference (TYPE)	TP_TS_INSTANCE		Table of instances	20130715
16	P_T_SQL_STATEMENT	Instance attribute	Private	☐	Type reference (TYPE)	TP_T_SQL_LINE		SQL Statement	20130712

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_FIELD_TYPES	Instance method	Private	Method	Get field types	20130717
2	CHECK_ATTRIBUTES	Instance method	Private	Method	Check whether an attribute has changed	20130830
3	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20130711
4	CREATE_INV_SQL_SCRIPT_PROC	Instance method	Private	Method	Create SQL script procedure for inverting logic	20130711
5	CREATE_SESSION_TABLE_TYPE	Instance method	Private	Method	Create table type like lock table	20130802
6	CREATE_SQL_SCRIPT_PROC	Instance method	Private	Method	Create SQL script procedure	20130712
7	CREATE_TABLE_TYPE	Instance method	Private	Method	Create table type	20130711
8	DROP_SQL_SCRIPT	Instance method	Private	Method		20130715
9	DROP_SQL_SCRIPT_PROC	Instance method	Private	Method	Drop SQL script procedure	20130715
10	DROP_TABLE_TYPE	Instance method	Private	Method	Drop table type	20130715
11	GET_FIELD_LIST	Instance method	Private	Method	Get field list	20130712
12	GET_INSTANCE	Static method	Public	Method	Factory method	20130712
13	GET_SQL_SCRIPT_BODY_ALL_LOCKED	Instance method	Private	Method	Get SQL script body for default state All or Locked	20130731
14	GET_SQL_SCRIPT_BODY_OWN_MAN	Instance method	Private	Method	Get SQL script body for default state Owner or Manager	20130730
15	GET_SQL_SCRIPT_SOURCE	Instance method	Private	Method	Get SQL script procedure source code	20130715
16	GET_STATEMENT	Instance method	Private	Method	Get statement as string	20130715
17	GET_WHERE_CLAUSE	Instance method	Private	Method	Get where clause	20130712
18	GET_WHERE_CLAUSE_DRIVER	Instance method	Private	Method	Get where clause for driver	20130730

Events

Class CL_RSPLS_WS_SQL_SCRIPT_GEN has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TN_OBJECT_ID	Private	Attribute reference (LIKE)			20130715
2	TN_S_SQLSCRIPT_OBJECTS	Private	Attribute reference (LIKE)			20130715
3	TP_SQL_LINE	Private	Type reference (TYPE)	STRING	SQL statement line	20130712
4	TP_S_INSTANCE	Private	See coding			20130715	BEGIN OF tp_s_instance, bpc_env TYPE rsbpc_appset_id, bpc_model TYPE rsbpc_appl_id, r_instance TYPE REF TO if_rspls_ws_sql_script_gen, END OF tp_s_instance
5	TP_TS_INSTANCE	Private	See coding			20130715	tp_ts_instance TYPE SORTED TABLE OF tp_s_instance WITH UNIQUE KEY bpc_env bpc_model
6	TP_T_SQL_LINE	Private	See coding		SQL Statement	20130712	tp_t_sql_line TYPE STANDARD TABLE OF tp_sql_line

Method Signatures

Method ADD_FIELD_TYPES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_INCL_IPROV	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Include INFOPROV Field	20130717

#	Exception	Resumable	Description	Created on
1	CX_RSPLS_SQL_SCRIPT_GEN_ERROR	☐	SQL Script Generation Error	20130718

Method CHECK_ATTRIBUTES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DEFAULT_STATE	Call by reference	☐	Type reference (TYPE)	RSBPCW_MODWS		BPC: Module Work Status	20130830
2	Importing	I_LOCK_TAB_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130830
3	Importing	I_TS_FIELDS_MAP	Call by reference	☐	Type reference (TYPE)	IF_RSPLS_DS_TYPES=>TN_TS_FIELD		Tabelle: Merkmale einer Datenscheibe (interne Sicht)	20130830
4	Returning	R_CHANGED	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Attributes have changed	20130830

Method CHECK_ATTRIBUTES on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_BPC_ENV	Call by reference	☐	Type reference (TYPE)	RSBPC_APPSET_ID		BPC: AppSet ID	20130711
2	Importing	I_BPC_MODEL	Call by reference	☐	Type reference (TYPE)	RSBPC_APPL_ID		BPC: Application ID	20130711
3	Importing	I_DEFAULT_STATE	Call by reference	☐	Type reference (TYPE)	RSBPCW_MODWS		BPC: Module Work Status	20130723
4	Importing	I_LOCK_TAB_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130723
5	Importing	I_TS_FIELDS_MAP	Call by reference	☐	Type reference (TYPE)	IF_RSPLS_DS_TYPES=>TN_TS_FIELD		Tabelle: Merkmale einer Datenscheibe (interne Sicht)	20130723

#	Exception	Resumable	Description	Created on
1	CX_RSPLS_SQL_SCRIPT_GEN_ERROR	☐	SQL Script Generation Error	20130802

Method CREATE_INV_SQL_SCRIPT_PROC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_INV_SQL_PROC	Value transfer	☐	Type reference (TYPE)	TN_OBJECT_ID		HANA object IDs needed for Work Status	20130715

#	Exception	Resumable	Description	Created on
1	CX_RSPLS_SQL_SCRIPT_GEN_ERROR	☐	SQL Script Generation Error	20130715

Method CREATE_SESSION_TABLE_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_SESSION_TABLE_TYPE	Value transfer	☐	Type reference (TYPE)	TN_OBJECT_ID		HANA object IDs needed for Work Status	20131002

#	Exception	Resumable	Description	Created on
1	CX_RSPLS_SQL_SCRIPT_GEN_ERROR	☐	SQL Script Generation Error	20130802

Method CREATE_SQL_SCRIPT_PROC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_SQL_PROC	Value transfer	☐	Type reference (TYPE)	TN_OBJECT_ID		HANA object IDs needed for Work Status	20130715

#	Exception	Resumable	Description	Created on
1	CX_RSPLS_SQL_SCRIPT_GEN_ERROR	☐	SQL Script Generation Error	20130715

Method CREATE_TABLE_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_TABLE_TYPE	Value transfer	☐	Type reference (TYPE)	TN_OBJECT_ID		HANA object IDs needed for Work Status	20130715

#	Exception	Resumable	Description	Created on
1	CX_RSPLS_SQL_SCRIPT_GEN_ERROR	☐	SQL Script Generation Error	20130715

Method DROP_SQL_SCRIPT Signature

Method DROP_SQL_SCRIPT on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no parameter.
Method DROP_SQL_SCRIPT on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method DROP_SQL_SCRIPT_PROC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SQL_PROC	Call by reference	☐	Type reference (TYPE)	TN_OBJECT_ID		HANA object IDs needed for Work Status	20130715

Method DROP_SQL_SCRIPT_PROC on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method DROP_TABLE_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TABLE_TYPE	Call by reference	☐	Type reference (TYPE)	TN_OBJECT_ID		HANA object IDs needed for Work Status	20130715

Method DROP_TABLE_TYPE on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method GET_FIELD_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_INCL_IPROV	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Include Infoprovider	20130717
2	Importing	I_PREFIX	Call by reference	☑	Type reference (TYPE)	STRING		Prefix used before each field	20130712
3	Returning	R_FIELD_LIST	Value transfer	☐	Type reference (TYPE)	STRING		Field list	20130712

Method GET_FIELD_LIST on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method GET_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_BPC_ENV	Call by reference	☐	Type reference (TYPE)	RSBPC_APPSET_ID		BPC: AppSet ID	20130712
2	Importing	I_BPC_MODEL	Call by reference	☐	Type reference (TYPE)	RSBPC_APPL_ID		BPC: Application ID	20130712
3	Importing	I_DEFAULT_STATE	Call by reference	☐	Type reference (TYPE)	RSBPCW_MODWS		BPC: Module Work Status	20130723
4	Importing	I_LOCK_TAB_NAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20130723
5	Importing	I_TS_FIELDS_MAP	Call by reference	☐	Type reference (TYPE)	IF_RSPLS_DS_TYPES=>TN_TS_FIELD		Tabelle: Merkmale einer Datenscheibe (interne Sicht)	20130723
6	Returning	R_R_WS_SQL_SCRIPT_GEN	Value transfer	☐	Object reference (TYPE REF TO)	IF_RSPLS_WS_SQL_SCRIPT_GEN		SQL Script generator for work status	20130712

#	Exception	Resumable	Description	Created on
1	CX_RSPLS_SQL_SCRIPT_GEN_ERROR	☐	SQL Script Generation Error	20130712

Method GET_SQL_SCRIPT_BODY_ALL_LOCKED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_SQL_SCRIPT_BODY	Value transfer	☐	Type reference (TYPE)	STRING		Body of SQL script procedure	20130731

Method GET_SQL_SCRIPT_BODY_ALL_LOCKED on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method GET_SQL_SCRIPT_BODY_OWN_MAN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_SQL_SCRIPT_BODY	Value transfer	☐	Type reference (TYPE)	STRING		SQL Script body	20130730

Method GET_SQL_SCRIPT_BODY_OWN_MAN on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method GET_SQL_SCRIPT_SOURCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_T_SOURCE_CODE	Call by reference	☐	Type reference (TYPE)	TP_T_SQL_LINE		SQL script source code	20130715
2	Importing	I_BODY	Call by reference	☐	Type reference (TYPE)	STRING		SQL script procedure body	20130715
3	Importing	I_IN_PARAMETERS	Call by reference	☑	Type reference (TYPE)	STRING		SQL script procedure input parameters	20130715
4	Importing	I_LANGUAGE	Call by reference	☐	Type reference (TYPE)	STRING		SQL script procedure language	20130715
5	Importing	I_NAME	Call by reference	☐	Type reference (TYPE)	TN_OBJECT_ID		SQL script procedure name	20130715
6	Importing	I_OUT_PARAMETERS	Call by reference	☑	Type reference (TYPE)	STRING		SQL script procedure output parameters	20130715

Method GET_SQL_SCRIPT_SOURCE on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method GET_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_SQL_STATEMENT	Call by reference	☐	Type reference (TYPE)	TP_T_SQL_LINE		SQL Statement	20130715
2	Returning	R_SQL_STATEMENT	Value transfer	☐	Type reference (TYPE)	STRING		SQL statement line	20130715

Method GET_STATEMENT on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method GET_WHERE_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ADD_IPROV	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Boolean	20130731
2	Importing	I_INCL_IPROV	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Boolean	20130729
3	Importing	I_PREFIX_LEFT	Call by reference	☑	Type reference (TYPE)	STRING		Prefix on the left hand side	20130712
4	Importing	I_PREFIX_RIGHT	Call by reference	☑	Type reference (TYPE)	STRING		Prefix on the right hand side	20130712
5	Returning	R_WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	STRING		Field list	20130712

Method GET_WHERE_CLAUSE on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

Method GET_WHERE_CLAUSE_DRIVER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_INCL_IPROV	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Boolean	20130730
2	Importing	I_PREFIX_LEFT	Call by reference	☑	Type reference (TYPE)	STRING		Prefix on the left hand side	20130730
3	Importing	I_PREFIX_RIGHT	Call by reference	☑	Type reference (TYPE)	STRING		Prefix on the right hand side	20130730
4	Returning	R_WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	STRING		Field list	20130730

Method GET_WHERE_CLAUSE_DRIVER on class CL_RSPLS_WS_SQL_SCRIPT_GEN has no exception.

History

Last changed by/on	SAP	20140121
SAP Release Created in	740