MASS_QUERY SAP Method Material: Query









Below is documentation, parameters and attributes of ABAP Method MASS_QUERY within SAP class /SCMB/CL_PDM_PRD. 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 /SCMB/CL_PDM_PRD into the relevant SAP transactions such as SE24 or SE80, and then selecting the method you are interested in.


Method Type - Static

This is a Static Method so you can call it directly

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

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


Parameters of Method MASS_QUERY

.

NameTypeData TypeDescriptionDefault Value
IT_SEL_BY_DESCRIPTIONImportingTYPE
/SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE
IT_SEL_BY_MATERIAL_IDImportingTYPE
/SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE
IT_SEL_BY_MATERIAL_INTERNAL_IDImportingTYPE
/SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE
IT_SEL_BY_MAT_PROPERTY_1ImportingTYPE
/SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE
IT_SEL_BY_MAT_PROPERTY_2ImportingTYPE
/SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE
IT_SEL_BY_MAT_PROPERTY_3ImportingTYPE
/SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE
IT_SEL_BY_MAT_PROPERTY_4ImportingTYPE
/SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE
IT_SEL_BY_MAT_PROPERTY_5ImportingTYPE
/SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE
IT_SEL_BY_SPA_IDImportingTYPE
/SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE
IV_LANGUAGEImportingTYPE
SPRAS
Language Key
IV_LOGICAL_SYSTEMImportingTYPE
BAPISCMBLOGSYS
Logical System
IV_MAXIMUM_NUMBER_VALUEImportingTYPE
I
IV_NO_SORTImportingTYPE
XFELD
Checkbox
IV_PRODUCT_CATEGORYImportingTYPE
/SAPAPO/PRDHA
Product Hierarchy
IV_READ_SNPImportingTYPE
ABAP_BOOL
ET_BOD_ASSIGNMENTExportingTYPE
/SAPAPO/MATBOD_TAB
List of BODs
ET_DESCRIPTIONExportingTYPE
/SCMB/MATTXT_OUT_TAB
External Output Structure for MATTXT
ET_MATERIALExportingTYPE
/SCMB/MATKEY_OUT_TAB
External Output Structure for MATKEY
ET_MATPRIO_OUTExportingTYPE
MATPRIO_OUT_TAB
Ext. Output Structure for Time-Dependent LocProd. Priorities
ET_PLANNING_VERSIONExportingTYPE
/SCMB/MATLOC_OUT_TAB
External Output Structure for MATLOC
ET_QUANTITY_UNITExportingTYPE
/SCMB/MARM_OUT_TAB
External Output Structure für MARM
ET_SUPPLY_PLANNING_AREAExportingTYPE
/SCMB/MATLOC_OUT_TAB
External Output Structure for MATLOC
EV_LAST_PROVIDED_MATNRExportingTYPE
/SAPAPO/MATNR
Product Identifier
EV_MORE_RECORDS_AVAILABLEExportingTYPE
ABAP_BOOL
EV_NUMBER_VALUEExportingTYPE
I
CT_RETURNChangingTYPE
BAPIRET2_T
Return parameter table



Exceptions of Method MASS_QUERY

This method does not have any exceptions

Example ABAP coding


DATA: lv_CT_RETURN TYPE BAPIRET2_T,
lv_ET_BOD_ASSIGNMENT TYPE /SAPAPO/MATBOD_TAB,
lv_ET_DESCRIPTION TYPE /SCMB/MATTXT_OUT_TAB,
lv_ET_MATERIAL TYPE /SCMB/MATKEY_OUT_TAB,
lv_ET_MATPRIO_OUT TYPE MATPRIO_OUT_TAB,
lv_ET_PLANNING_VERSION TYPE /SCMB/MATLOC_OUT_TAB,
lv_ET_QUANTITY_UNIT TYPE /SCMB/MARM_OUT_TAB,
lv_ET_SUPPLY_PLANNING_AREA TYPE /SCMB/MATLOC_OUT_TAB,
lv_EV_LAST_PROVIDED_MATNR TYPE /SAPAPO/MATNR,
lv_EV_MORE_RECORDS_AVAILABLE TYPE ABAP_BOOL,
lv_EV_NUMBER_VALUE TYPE I,
lv_IT_SEL_BY_DESCRIPTION TYPE /SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE,
lv_IT_SEL_BY_MATERIAL_ID TYPE /SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE,
lv_IT_SEL_BY_MATERIAL_INTERNAL_ID TYPE /SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE,
lv_IT_SEL_BY_MAT_PROPERTY_1 TYPE /SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE,
lv_IT_SEL_BY_MAT_PROPERTY_2 TYPE /SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE,
lv_IT_SEL_BY_MAT_PROPERTY_3 TYPE /SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE,
lv_IT_SEL_BY_MAT_PROPERTY_4 TYPE /SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE,
lv_IT_SEL_BY_MAT_PROPERTY_5 TYPE /SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE,
lv_IT_SEL_BY_SPA_ID TYPE /SCMB/CL_SE_RANGE_CONVERSION=>TY_MT_RANGE,
lv_IV_LANGUAGE TYPE SPRAS,
lv_IV_LOGICAL_SYSTEM TYPE BAPISCMBLOGSYS,
lv_IV_MAXIMUM_NUMBER_VALUE TYPE I,
lv_IV_NO_SORT TYPE XFELD,
lv_IV_PRODUCT_CATEGORY TYPE /SAPAPO/PRDHA,
lv_IV_READ_SNP TYPE ABAP_BOOL,
lv_other TYPE c.

CALL METHOD /SCMB/CL_PDM_PRD=>MASS_QUERY(
EXPORTING
IT_SEL_BY_DESCRIPTION = lv_IT_SEL_BY_DESCRIPTION
IT_SEL_BY_MATERIAL_ID = lv_IT_SEL_BY_MATERIAL_ID
IT_SEL_BY_MATERIAL_INTERNAL_ID = lv_IT_SEL_BY_MATERIAL_INTERNAL_ID
IT_SEL_BY_MAT_PROPERTY_1 = lv_IT_SEL_BY_MAT_PROPERTY_1
IT_SEL_BY_MAT_PROPERTY_2 = lv_IT_SEL_BY_MAT_PROPERTY_2
IT_SEL_BY_MAT_PROPERTY_3 = lv_IT_SEL_BY_MAT_PROPERTY_3
IT_SEL_BY_MAT_PROPERTY_4 = lv_IT_SEL_BY_MAT_PROPERTY_4
IT_SEL_BY_MAT_PROPERTY_5 = lv_IT_SEL_BY_MAT_PROPERTY_5
IT_SEL_BY_SPA_ID = lv_IT_SEL_BY_SPA_ID
IV_LANGUAGE = lv_IV_LANGUAGE
IV_LOGICAL_SYSTEM = lv_IV_LOGICAL_SYSTEM
IV_MAXIMUM_NUMBER_VALUE = lv_IV_MAXIMUM_NUMBER_VALUE
IV_NO_SORT = lv_IV_NO_SORT
IV_PRODUCT_CATEGORY = lv_IV_PRODUCT_CATEGORY
IV_READ_SNP = lv_IV_READ_SNP
IMPORTING
ET_BOD_ASSIGNMENT = lv_ET_BOD_ASSIGNMENT
ET_DESCRIPTION = lv_ET_DESCRIPTION
ET_MATERIAL = lv_ET_MATERIAL
ET_MATPRIO_OUT = lv_ET_MATPRIO_OUT
ET_PLANNING_VERSION = lv_ET_PLANNING_VERSION
ET_QUANTITY_UNIT = lv_ET_QUANTITY_UNIT
ET_SUPPLY_PLANNING_AREA = lv_ET_SUPPLY_PLANNING_AREA
EV_LAST_PROVIDED_MATNR = lv_EV_LAST_PROVIDED_MATNR
EV_MORE_RECORDS_AVAILABLE = lv_EV_MORE_RECORDS_AVAILABLE
EV_NUMBER_VALUE = lv_EV_NUMBER_VALUE
CHANGING
CT_RETURN = lv_CT_RETURN ).

Links to Related Class(s)

/SCMB/CL...
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!