BUILD_WHERE_CLAUSE SAP Method Build WHERE clause for query select statement









Below is documentation, parameters and attributes of ABAP Method BUILD_WHERE_CLAUSE within SAP class /SCMTMS/CL_Q_SUPERCLASS. There is also a number of example ABAP code snipts to help you use the functionality of this method.

This method is available within SAP systems depending on your version and release level, you can view further information by entering the class name /SCMTMS/CL_Q_SUPERCLASS into the relevant SAP transactions such as SE24 or SE80, and then selecting the method you are interested in.


Method Type - Instance

This is an Instance Method so needs to be instantiated first before you can access any of the methods. I.e. you need to create a local variable of TYPE ref to the class.

The following technical details of method BUILD_WHERE_CLAUSE can also be found below:

  • Importing parameters
  • Exporting parameters
  • Changing parameters
  • Returning parameters
  • Exceptions
  • Coding Examples


Parameters of Method BUILD_WHERE_CLAUSE

.

NameTypeData TypeDescriptionDefault Value
IS_CTXImportingTYPE
/BOBF/S_FRW_CTX_QUERY		Context Information for Queries
IS_QUERY_OPTIONSImportingTYPE
/BOBF/S_FRW_QUERY_OPTIONS		Query Options
IT_FILTER_KEYImportingTYPE
/BOBF/T_FRW_KEY		Key Table
IT_QUERY_ENHANCEImportingTYPE
/SCMTMS/T_QUERY_ENHANCE		Query enhancement table type
IT_RESULT_ENHANCEImportingTYPE
/SCMTMS/T_QDB_ATTR_ENHANCE		Generic result query attributes enhancement table
IT_SELECTION_PARAMETERSImportingTYPE
/BOBF/T_FRW_QUERY_SELPARAM		Query Selection Parameters
IV_DB_TABLE_ALIASImportingTYPE
STRING		DB table alias for SELECT statement like 'A' of 'A~DB_KEY'
IV_DB_TABLE_KEY_ATTRImportingTYPE
FIELDNAME		DB table key attribute name like 'DB_KEY'
ES_RANGESExportingTYPE REF TO
DATA		Structure with Range Tables
ET_ORDERBYExportingTYPE
/SCMTMS/T_STRING		Table of Strings
ET_SUBQ_ENHExportingTYPE
TT_SUBQUERY_ENH		EXISTS Subquery Definitions
ET_WHEREExportingTYPE
/SCMTMS/T_STRING		Table of Strings



Exceptions of Method BUILD_WHERE_CLAUSE

/BOBF/CX_DAC - Error Messages of the data access

Example ABAP coding


DATA: lo_class TYPE REF TO /SCMTMS/CL_Q_SUPERCLASS.
DATA: lv_ES_RANGES TYPE DATA,
lv_ET_ORDERBY TYPE /SCMTMS/T_STRING,
lv_ET_SUBQ_ENH TYPE TT_SUBQUERY_ENH,
lv_ET_WHERE TYPE /SCMTMS/T_STRING,
lv_IS_CTX TYPE /BOBF/S_FRW_CTX_QUERY,
lv_IS_QUERY_OPTIONS TYPE /BOBF/S_FRW_QUERY_OPTIONS,
lv_IT_FILTER_KEY TYPE /BOBF/T_FRW_KEY,
lv_IT_QUERY_ENHANCE TYPE /SCMTMS/T_QUERY_ENHANCE,
lv_IT_RESULT_ENHANCE TYPE /SCMTMS/T_QDB_ATTR_ENHANCE,
lv_IT_SELECTION_PARAMETERS TYPE /BOBF/T_FRW_QUERY_SELPARAM,
lv_IV_DB_TABLE_ALIAS TYPE STRING,
lv_IV_DB_TABLE_KEY_ATTR TYPE FIELDNAME,
lv_other TYPE c.

CALL METHOD lo_class=>BUILD_WHERE_CLAUSE(
EXPORTING
IS_CTX = lv_IS_CTX
IS_QUERY_OPTIONS = lv_IS_QUERY_OPTIONS
IT_FILTER_KEY = lv_IT_FILTER_KEY
IT_QUERY_ENHANCE = lv_IT_QUERY_ENHANCE
IT_RESULT_ENHANCE = lv_IT_RESULT_ENHANCE
IT_SELECTION_PARAMETERS = lv_IT_SELECTION_PARAMETERS
IV_DB_TABLE_ALIAS = lv_IV_DB_TABLE_ALIAS
IV_DB_TABLE_KEY_ATTR = lv_IV_DB_TABLE_KEY_ATTR
IMPORTING
ES_RANGES = lv_ES_RANGES
ET_ORDERBY = lv_ET_ORDERBY
ET_SUBQ_ENH = lv_ET_SUBQ_ENH
ET_WHERE = lv_ET_WHERE ).

Links to Related Class(s)

/SCMTMS/...
Full list of available SAP object classes

Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!