SAP ABAP Interface IF_SIW_DB_QUERIES (Read only queries for SIW)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-ESI-SIW (Application Component) Service Implementation Workbench
     ⤷ S_SIW_DB (Package) SIW: Database Layer

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	CL_SIW_DB_QUERIES	Read only queries	20101004

Properties

Interface	IF_SIW_DB_QUERIES
Short Description	Read only queries for SIW

General Data

Package	S_SIW_DB	SIW: Database Layer
Created	20101004	SAP
Last changed	20130531	SAP
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	IF_SIW_CONFIGURATION	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
3	IF_SIW_DB_IMPL_ACCESS	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
4	IF_SIW_DB_PROJECT_ACCESS	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
5	IF_SIW_DB_QUERIES	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...

Interfaces

Interface IF_SIW_DB_QUERIES has no interface.

Friends

Interface IF_SIW_DB_QUERIES has no friend.

Attributes

Interface IF_SIW_DB_QUERIES has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONFIGS_GET_BY_PATTERN	Instance method	Public	Method	Find configurations with pattern search	20101008
2	CONFIG_GET_BY_ID	Instance method	Public	Method	Return a specific configuration	20101007
3	GET_ALL_PROJECT_IDS	Instance method	Public	Method	returns project id and config	20121015
4	LANDSCAPES_GET	Instance method	Public	Method	Return landscapes	20101007
5	LANDSCAPES_GET_BY_PATTERN	Instance method	Public	Method	Find landscapes with pattern search	20110505
6	LANDSCAPE_GET_BY_ID	Instance method	Public	Method	Return a specific landscape	20101007
7	PIECE_SEARCH	Instance method	Public	Method	Search for implementation objects (pieces)	20101007
8	PROJECTS_GET	Instance method	Public	Method	Return all SIW projects	20101007
9	PROJECTS_GET_BY_PIECE	Instance method	Public	Method		20101021
10	PROJECTS_GET_BY_VAR	Instance method	Public	Method		20101021
11	PROJECT_COMPLEX_SEARCH	Instance method	Public	Method		20101021
12	PROJECT_EXISTS	Instance method	Public	Method	Returns 'X' when the project exists on database	20101005
13	PROJECT_FOR_CONFIG	Instance method	Public	Method	Check if a project for a configuration exists	20101005
14	PROJECT_SEARCH	Instance method	Public	Method	Search for projects	20101005

Events

Interface IF_SIW_DB_QUERIES has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	STR_CONFIG	Public	Type reference (TYPE)	VSIW_CONFIG	Generierte Tabelle zu einem View	20101005
2	STR_LANDSCAPE	Public	Type reference (TYPE)	VSIW_LANDSCAPE	VSIW_LANDSCAPE	20101005
3	ST_PROJ_IDS	Public	See coding			20121015	BEGIN OF st_proj_ids, project_id TYPE siw_dte_project_id, config_id TYPE siw_dte_config_id, END OF st_proj_ids
4	TAB_CONFIG	Public	See coding			20101005	tab_config TYPE STANDARD TABLE OF str_config WITH DEFAULT KEY
5	TAB_LANDSCAPE	Public	See coding			20101005	tab_landscape TYPE STANDARD TABLE OF vsiw_landscape WITH DEFAULT KEY
6	TAB_PROJ_IDS	Public	See coding			20121015	tab_proj_ids TYPE SORTED TABLE OF st_proj_ids WITH UNIQUE KEY project_id config_id

Method Signatures

Method CONFIGS_GET_BY_PATTERN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PATTERN	Call by reference	☐	Type reference (TYPE)	STRING	'*'		20101008
2	Returning	RT_CONFIGS	Value transfer	☐	Type reference (TYPE)	IF_SIW_DB_QUERIES=>TAB_CONFIG			20101008

Method CONFIGS_GET_BY_PATTERN on Interface IF_SIW_DB_QUERIES has no exception.

Method CONFIG_GET_BY_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CONFIG_ID	Call by reference	☐	Type reference (TYPE)	SIW_DTE_CONFIG_ID		Configuration ID	20101007
2	Importing	I_FLG_ONLY_AT_DB	Call by reference	☐	Type reference (TYPE)	SIW_DTE_FLG	ABAP_FALSE	General Flag	20110125
3	Returning	R_STR_CONFIG	Value transfer	☐	Type reference (TYPE)	IF_SIW_DB_QUERIES=>STR_CONFIG		Generierte Tabelle zu einem View	20101007

#	Exception	Resumable	Description	Created on
1	CX_SIW_NOT_FOUND	☐	Not Existing Object or Information	20101215

Method GET_ALL_PROJECT_IDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	PROJ_IDS	Value transfer	☐	Type reference (TYPE)	TAB_PROJ_IDS		SIW Project IDS	20121015

Method GET_ALL_PROJECT_IDS on Interface IF_SIW_DB_QUERIES has no exception.

Method LANDSCAPES_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_TAB_LANDSCAPES	Value transfer	☐	Type reference (TYPE)	IF_SIW_DB_QUERIES=>TAB_LANDSCAPE			20101007

Method LANDSCAPES_GET on Interface IF_SIW_DB_QUERIES has no exception.

Method LANDSCAPES_GET_BY_PATTERN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PATTERN	Call by reference	☐	Type reference (TYPE)	STRING	'*'		20110505
2	Returning	RT_LANDSCAPES	Value transfer	☐	Type reference (TYPE)	IF_SIW_DB_QUERIES=>TAB_LANDSCAPE			20110505

Method LANDSCAPES_GET_BY_PATTERN on Interface IF_SIW_DB_QUERIES has no exception.

Method LANDSCAPE_GET_BY_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_LANDSCAPE_ID	Call by reference	☐	Type reference (TYPE)	SIW_DTE_LANDSCAPE_ID		Landscape ID	20101007
2	Returning	R_STR_LANDSCAPE	Value transfer	☐	Type reference (TYPE)	IF_SIW_DB_QUERIES=>STR_LANDSCAPE		VSIW_LANDSCAPE	20101007

Method LANDSCAPE_GET_BY_ID on Interface IF_SIW_DB_QUERIES has no exception.

Method PIECE_SEARCH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FLG_ONLY_DB	Call by reference	☐	Type reference (TYPE)	SIW_DTE_FLG	ABAP_FALSE	General Flag	20101029
2	Importing	I_PIECE_NAME	Call by reference	☐	Type reference (TYPE)	STRING	'*'	Object Name	20101007
3	Importing	I_PIECE_OPERATOR	Call by reference	☐	Type reference (TYPE)	STRING	'EQ'		20101007
4	Importing	I_PROJECT_ID	Call by reference	☐	Type reference (TYPE)	SIW_DTE_PROJECT_ID	'*'	SIW Project ID	20101007
5	Importing	I_PROJECT_OPERATOR	Call by reference	☐	Type reference (TYPE)	STRING	'EQ'		20101007
6	Returning	RT_PIECES	Value transfer	☐	Type reference (TYPE)	IF_SIW_DB_IMPL_ACCESS=>TTY_TSIW_IMPL_PIECE		Table type for TSIW_IMPL_PIECE	20101007

Method PIECE_SEARCH on Interface IF_SIW_DB_QUERIES has no exception.

Method PROJECTS_GET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FLG_ONLY_AT_DB	Call by reference	☐	Type reference (TYPE)	SIW_DTE_FLG	ABAP_FALSE		20101014
2	Returning	RT_PROJECT	Value transfer	☐	Type reference (TYPE)	IF_SIW_DB_PROJECT_ACCESS=>TTY_PROJECT		Table type for tsiw_proj	20101007

Method PROJECTS_GET on Interface IF_SIW_DB_QUERIES has no exception.

Method PROJECTS_GET_BY_PIECE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FILTER	Call by reference	☐	Type reference (TYPE)	SIW_TAB_RNG_PROJECT_ID			20101021
2	Importing	I_RNG_PIECE_ID	Call by reference	☐	Type reference (TYPE)	SIW_TAB_RNG_PIECE_ID			20101021
3	Importing	I_RNG_PIECE_NAME	Call by reference	☐	Type reference (TYPE)	SIW_TAB_RNG_PIECE_NAME			20101021
4	Returning	R_TAB_PROJECT_ID	Value transfer	☐	Type reference (TYPE)	SIW_TAB_PROJECT_ID		table of project ids	20101021

Method PROJECTS_GET_BY_PIECE on Interface IF_SIW_DB_QUERIES has no exception.

Method PROJECTS_GET_BY_VAR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FILTER	Call by reference	☐	Type reference (TYPE)	SIW_TAB_RNG_PROJECT_ID		table of project ids	20101021
2	Importing	I_RNG_VAR_ID	Call by reference	☐	Type reference (TYPE)	SIW_TAB_RNG_VAR_ID		range of piece ids	20101021
3	Importing	I_RNG_VAR_VALUE	Call by reference	☐	Type reference (TYPE)	SIW_TAB_RNG_VAR_VALUE		range of piece ids	20101021
4	Returning	R_TAB_PROJECT_ID	Value transfer	☐	Type reference (TYPE)	SIW_TAB_PROJECT_ID		table of project ids	20101021

Method PROJECTS_GET_BY_VAR on Interface IF_SIW_DB_QUERIES has no exception.

Method PROJECT_COMPLEX_SEARCH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_TAB_PROJECT_HEADER	Call by reference	☐	Type reference (TYPE)	SIW_TAB_PROJECT_HEADER		project headers	20101021
2	Exporting	E_TAB_PROJECT_ID	Call by reference	☐	Type reference (TYPE)	SIW_TAB_PROJECT_ID		table of project ids	20101021
3	Importing	I_RNG_CONFIG_ID	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_CONFIG_ID			20101021
4	Importing	I_RNG_NAMESPACE	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_NAMESPACE			20101021
5	Importing	I_RNG_OPERATION	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_OPERATION			20101021
6	Importing	I_RNG_PIECE_ID	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_PIECE_ID			20101021
7	Importing	I_RNG_PIECE_NAME	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_PIECE_NAME			20101021
8	Importing	I_RNG_PROJECT_ID	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_PROJECT_ID			20101021
9	Importing	I_RNG_SERVICE	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_SERVICE_INTERFACE			20101021
10	Importing	I_RNG_SERVICE_LEVEL	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_SERVICE_LEVEL			20101021
11	Importing	I_RNG_VAR_ID_1	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_VAR_ID			20101021
12	Importing	I_RNG_VAR_ID_2	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_VAR_ID			20101021
13	Importing	I_RNG_VAR_ID_3	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_VAR_ID			20101021
14	Importing	I_RNG_VAR_VALUE_1	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_VAR_VALUE			20101021
15	Importing	I_RNG_VAR_VALUE_2	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_VAR_VALUE			20101021
16	Importing	I_RNG_VAR_VALUE_3	Call by reference	☑	Type reference (TYPE)	SIW_TAB_RNG_VAR_VALUE			20101021

Method PROJECT_COMPLEX_SEARCH on Interface IF_SIW_DB_QUERIES has no exception.

Method PROJECT_EXISTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FLG_ONLY_AT_DB	Call by reference	☐	Type reference (TYPE)	SIW_DTE_FLG	ABAP_FALSE		20101014
2	Importing	I_PROJECT_ID	Call by reference	☐	Type reference (TYPE)	SIW_DTE_PROJECT_ID		SIW: Projekt ID	20101005
3	Returning	R_RESULT	Value transfer	☐	Type reference (TYPE)	XFELD		Ergebnis der Prüfung	20101005

Method PROJECT_EXISTS on Interface IF_SIW_DB_QUERIES has no exception.

Method PROJECT_FOR_CONFIG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CONFIG_ID	Call by reference	☐	Type reference (TYPE)	SIW_DTE_CONFIG_ID		Configuration ID	20101005
2	Returning	R_RESULT	Value transfer	☐	Type reference (TYPE)	XFELD		Checkbox	20101005

Method PROJECT_FOR_CONFIG on Interface IF_SIW_DB_QUERIES has no exception.

Method PROJECT_SEARCH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CONFIG	Call by reference	☐	Type reference (TYPE)	STRING	'*'		20101005
2	Importing	I_ID	Call by reference	☐	Type reference (TYPE)	STRING	'*'		20101005
3	Importing	I_PRX_PACKAGE	Call by reference	☑	Type reference (TYPE)	STRING		Proxy package	20101111
4	Importing	I_STR_ESR_KEYS	Call by reference	☑	Type reference (TYPE)	SIW_STR_ESR_KEYS		SIW: key elements of web services in ES Repository	20101005
5	Returning	R_TAB_PROJECTS	Value transfer	☐	Type reference (TYPE)	IF_SIW_DB_PROJECT_ACCESS=>TTY_PROJECT		Tabelle von Projekten	20101005

Method PROJECT_SEARCH on Interface IF_SIW_DB_QUERIES has no exception.

History

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