DO_SELECT_2_SUBQUERY_NEW SAP Method Do SELECT with 2 sub queries new SQL syntax









Below is documentation, parameters and attributes of ABAP Method DO_SELECT_2_SUBQUERY_NEW 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 is a private Method so can only be executed from within the class itself. I.e. You could access it from another method of the class.

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 DO_SELECT_2_SUBQUERY_NEW can also be found below:

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


Parameters of Method DO_SELECT_2_SUBQUERY_NEW

.

NameTypeData TypeDescriptionDefault Value
IR_RANGESImportingTYPE REF TO
DATA		Structure with range tables for WHERE clause
IS_CTXImportingTYPE
/BOBF/S_FRW_CTX_QUERY		Context Information for Queries
IS_QUERY_OPTIONSImportingTYPE
/BOBF/S_FRW_QUERY_OPTIONS		Query Options
IT_ATTRImportingTYPE
/SCMTMS/T_STRING		List of SELECT attributes
IT_ATTR_OTHERSImportingTYPE
/SCMTMS/T_STRING		List of SELECT attributes (subclass specific handling)
IT_EXISTS_SELECT_CLAUSEImportingTYPE
TT_SUBQ_SELECT_CLAUSE		Subquery SELECT clauses
IT_FILTER_KEYImportingTYPE
/BOBF/T_FRW_KEY		Filter key table
IT_FROMImportingTYPE
/SCMTMS/T_STRING		SELECT FROM Statement
IT_QUERY_ENHANCEImportingTYPE
/SCMTMS/T_QUERY_ENHANCE		Query enhancement table type
IT_REQUESTED_ATTRIBUTESImportingTYPE
/BOBF/T_FRW_NAME		Requested result attributes
IT_RESULT_ENHANCEImportingTYPE
/SCMTMS/T_QDB_ATTR_ENHANCE		Generic result query attributes enhancement table
IT_RESULT_MULTIVALUEImportingTYPE
/SCMTMS/T_QDB_ATTR_ENHANCE		Multi value attributes of result list
IT_RESULT_SORTINGImportingTYPE
/SCMTMS/T_QDB_ATTR_ENHANCE		Result list mapping for sorting
IT_SELECTION_PARAMETERSImportingTYPE
/BOBF/T_FRW_QUERY_SELPARAM		Query Selection Parameters
IT_SELECTION_PARAMETERS_EXTImportingTYPE
/BOBF/T_FRW_QUERY_SELPARAM		Query Selection Parameters (subclass specific handling)
IT_WHEREImportingTYPE
/SCMTMS/T_STRING		SELECT WHERE Statement
IV_MAXIMUM_ROWSImportingTYPE
INT4		Requested lines
IV_NO_DATAImportingTYPE
BOOLE_D		Only select instance keys
IV_PACKSIZEImportingTYPE
INT4		Size of one SELECT package
ET_DATAExportingTYPE
INDEX TABLE		Result data table
ET_KEYExportingTYPE
/BOBF/T_FRW_KEY		Result key table
EV_NUM_BEFORE_ACExportingTYPE
INT4		Number of documents selected (before AC)
CT_DATA_PChangingTYPE
INDEX TABLE		Package data table (keys or result data)



Exceptions of Method DO_SELECT_2_SUBQUERY_NEW

/BOBF/CX_DAC - Error Messages of the data access

Example ABAP coding

This is a private Method so the below code can only be executed from within the class itself. I.e. from another method of the class.

DATA: lo_class TYPE REF TO /SCMTMS/CL_Q_SUPERCLASS.
DATA: lv_CT_DATA_P TYPE INDEX TABLE,
lv_ET_DATA TYPE INDEX TABLE,
lv_ET_KEY TYPE /BOBF/T_FRW_KEY,
lv_EV_NUM_BEFORE_AC TYPE INT4,
lv_IR_RANGES TYPE DATA,
lv_IS_CTX TYPE /BOBF/S_FRW_CTX_QUERY,
lv_IS_QUERY_OPTIONS TYPE /BOBF/S_FRW_QUERY_OPTIONS,
lv_IT_ATTR TYPE /SCMTMS/T_STRING,
lv_IT_ATTR_OTHERS TYPE /SCMTMS/T_STRING,
lv_IT_EXISTS_SELECT_CLAUSE TYPE TT_SUBQ_SELECT_CLAUSE,
lv_IT_FILTER_KEY TYPE /BOBF/T_FRW_KEY,
lv_IT_FROM TYPE /SCMTMS/T_STRING,
lv_IT_QUERY_ENHANCE TYPE /SCMTMS/T_QUERY_ENHANCE,
lv_IT_REQUESTED_ATTRIBUTES TYPE /BOBF/T_FRW_NAME,
lv_IT_RESULT_ENHANCE TYPE /SCMTMS/T_QDB_ATTR_ENHANCE,
lv_IT_RESULT_MULTIVALUE TYPE /SCMTMS/T_QDB_ATTR_ENHANCE,
lv_IT_RESULT_SORTING TYPE /SCMTMS/T_QDB_ATTR_ENHANCE,
lv_IT_SELECTION_PARAMETERS TYPE /BOBF/T_FRW_QUERY_SELPARAM,
lv_IT_SELECTION_PARAMETERS_EXT TYPE /BOBF/T_FRW_QUERY_SELPARAM,
lv_IT_WHERE TYPE /SCMTMS/T_STRING,
lv_IV_MAXIMUM_ROWS TYPE INT4,
lv_IV_NO_DATA TYPE BOOLE_D,
lv_IV_PACKSIZE TYPE INT4,
lv_other TYPE c.

CALL METHOD lo_class=>DO_SELECT_2_SUBQUERY_NEW(
EXPORTING
IR_RANGES = lv_IR_RANGES
IS_CTX = lv_IS_CTX
IS_QUERY_OPTIONS = lv_IS_QUERY_OPTIONS
IT_ATTR = lv_IT_ATTR
IT_ATTR_OTHERS = lv_IT_ATTR_OTHERS
IT_EXISTS_SELECT_CLAUSE = lv_IT_EXISTS_SELECT_CLAUSE
IT_FILTER_KEY = lv_IT_FILTER_KEY
IT_FROM = lv_IT_FROM
IT_QUERY_ENHANCE = lv_IT_QUERY_ENHANCE
IT_REQUESTED_ATTRIBUTES = lv_IT_REQUESTED_ATTRIBUTES
IT_RESULT_ENHANCE = lv_IT_RESULT_ENHANCE
IT_RESULT_MULTIVALUE = lv_IT_RESULT_MULTIVALUE
IT_RESULT_SORTING = lv_IT_RESULT_SORTING
IT_SELECTION_PARAMETERS = lv_IT_SELECTION_PARAMETERS
IT_SELECTION_PARAMETERS_EXT = lv_IT_SELECTION_PARAMETERS_EXT
IT_WHERE = lv_IT_WHERE
IV_MAXIMUM_ROWS = lv_IV_MAXIMUM_ROWS
IV_NO_DATA = lv_IV_NO_DATA
IV_PACKSIZE = lv_IV_PACKSIZE
IMPORTING
ET_DATA = lv_ET_DATA
ET_KEY = lv_ET_KEY
EV_NUM_BEFORE_AC = lv_EV_NUM_BEFORE_AC
CHANGING
CT_DATA_P = lv_CT_DATA_P ).

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!