SAP Function Modules

comments icon Comments

ISM_API_CQP_SELECT SAP Function module - Constant Service: Read Data







ISM_API_CQP_SELECT is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.

See here to view full function module documentation and code listing, simply by entering the name ISM_API_CQP_SELECT into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: JKSDCQP_API
Released Date: Not Released
Processing type: Normal fucntion module
Normal function module settings


Pattern for FM ISM_API_CQP_SELECT - ISM API CQP SELECT 





CALL FUNCTION 'ISM_API_CQP_SELECT' "Constant Service: Read Data
* EXPORTING
*   im_vbeln =                  " rjksd_vbeln_range_tab  Contract Number
*   im_posnr =                  " rjksd_posnr_range_tab  Item Number
*   im_product =                " rjksd_product_range_tab  Media Product
*   im_ewkun =                  " rjksd_bp_range_tab  Business Partners
*   im_atype =                  " rjksd_assitype_range_tab  Assignment Category
*   im_auart =                  " rjksd_auart_range_tab  Contract Type
*   im_pstyv =                  " rjksd_pstyv_range_tab  Item category
*   im_chainchannel =           " rjksd_chainchannel_range_tab  Distribution Channel of Retail Chain to Which POS Belongs
*   im_chaincode =              " rjksd_chaincode_range_tab  Retail Chain to Which POS Belongs
*   im_ebedienart =             " rjksd_ebedienart_range_tab  Service Type at Point of Sale
*   im_efrequenz =              " rjksd_efrequenz_range_tab
*   im_eumseinfl =              " rjksd_eumseinfl_range_tab  External Sales Influence at POS (Primary)
*   im_eumseinfl2 =             " rjksd_eumseinfl_range_tab  External Sales Influence at POS (Primary)
*   im_eumseinfl3 =             " rjksd_eumseinfl_range_tab  External Sales Influence at POS (Primary)
*   im_evkflaeche =             " rjksd_evkflaeche_range_tab  POS Area Key
*   im_evkstart =               " rjksd_evkstart_range_tab  POS Category
*   im_evkstbez =               " rjksd_evkstbez_range_tab  POS Type
*   im_ismgeokategorie =        " rjksd_ismgeokategorie_range_ta  Geography Category (Geographical Location) for Point of Sale
*   im_iumseinfl =              " rjksd_iumseinfl_range_tab
*   im_iumseinfl2 =             " rjksd_iumseinfl_range_tab
*   im_iumseinfl3 =             " rjksd_iumseinfl_range_tab
*   im_press_salescat =         " rjksd_press_salescat_range_tab  Type of Press Products
*   im_press_salesvol =         " rjksd_press_salesvol_range_tab  Weekly Press Sales
*   im_season =                 " rjksd_season_range_tab  Season Indicator
*   im_vkbur =                  " rjksd_vkbur_range_tab  Sales Office
*   im_vkgrp =                  " rjksd_vkgrp_range_tab  Sales Group
*   im_service_type =           " jservicetype_tab  Service Type
*   im_append = SPACE           " xfeld         Import Data (Select Appending)
*   im_validfrom = '19000101'   " sydatum       Start Date
*   im_validto = '99991231'     " sydatum       End Date
*   im_expectcqp = 'X'          " xfeld
*   im_planorg_tab =            " rjksd_planorg_range_tab  Planning Organization
*   im_protocol_contract_valid = ABAP_FALSE  " abap_bool  Log for Contract Validity
  IMPORTING
    ex_contract_tab =           " rjksecontrindex_tab  Contract Index
    ex_service_tab =            " rjksdcqpservice_db_tab  Constant Service
    ex_quan_tab =               " rjksdcqpquan_db_tab  Constant Service Quantities
    ex_return_tab =             " bapiret2tab
    .  "  ISM_API_CQP_SELECT

ABAP code example for Function Module ISM_API_CQP_SELECT





The ABAP code below is a full code listing to execute function module ISM_API_CQP_SELECT including all data declarations. The code uses the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the original method of declaring data variables up front. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8).

DATA:
ld_ex_contract_tab    TYPE RJKSECONTRINDEX_TAB
,
ld_ex_service_tab    TYPE RJKSDCQPSERVICE_DB_TAB
,
ld_ex_quan_tab    TYPE RJKSDCQPQUAN_DB_TAB
,
ld_ex_return_tab    TYPE BAPIRET2TAB
.




DATA(ld_im_vbeln) = 'Check type of data required'.

DATA(ld_im_posnr) = 'Check type of data required'.

DATA(ld_im_product) = 'Check type of data required'.

DATA(ld_im_ewkun) = 'Check type of data required'.

DATA(ld_im_atype) = 'Check type of data required'.

DATA(ld_im_auart) = 'Check type of data required'.

DATA(ld_im_pstyv) = 'Check type of data required'.

DATA(ld_im_chainchannel) = 'Check type of data required'.

DATA(ld_im_chaincode) = 'Check type of data required'.

DATA(ld_im_ebedienart) = 'Check type of data required'.

DATA(ld_im_efrequenz) = 'Check type of data required'.

DATA(ld_im_eumseinfl) = 'Check type of data required'.

DATA(ld_im_eumseinfl2) = 'Check type of data required'.

DATA(ld_im_eumseinfl3) = 'Check type of data required'.

DATA(ld_im_evkflaeche) = 'Check type of data required'.

DATA(ld_im_evkstart) = 'Check type of data required'.

DATA(ld_im_evkstbez) = 'Check type of data required'.

DATA(ld_im_ismgeokategorie) = 'Check type of data required'.

DATA(ld_im_iumseinfl) = 'Check type of data required'.

DATA(ld_im_iumseinfl2) = 'Check type of data required'.

DATA(ld_im_iumseinfl3) = 'Check type of data required'.

DATA(ld_im_press_salescat) = 'Check type of data required'.

DATA(ld_im_press_salesvol) = 'Check type of data required'.

DATA(ld_im_season) = 'Check type of data required'.

DATA(ld_im_vkbur) = 'Check type of data required'.

DATA(ld_im_vkgrp) = 'Check type of data required'.

DATA(ld_im_service_type) = 'Check type of data required'.

DATA(ld_im_append) = 'Check type of data required'.

DATA(ld_im_validfrom) = '20210129'.

DATA(ld_im_validto) = '20210129'.

DATA(ld_im_expectcqp) = '20210129'.

DATA(ld_im_planorg_tab) = '20210129'.

DATA(ld_im_protocol_contract_valid) = '20210129'.
.

CALL FUNCTION 'ISM_API_CQP_SELECT'
* EXPORTING
*   im_vbeln =                   ld_im_vbeln
*   im_posnr =                   ld_im_posnr
*   im_product =                 ld_im_product
*   im_ewkun =                   ld_im_ewkun
*   im_atype =                   ld_im_atype
*   im_auart =                   ld_im_auart
*   im_pstyv =                   ld_im_pstyv
*   im_chainchannel =            ld_im_chainchannel
*   im_chaincode =               ld_im_chaincode
*   im_ebedienart =              ld_im_ebedienart
*   im_efrequenz =               ld_im_efrequenz
*   im_eumseinfl =               ld_im_eumseinfl
*   im_eumseinfl2 =              ld_im_eumseinfl2
*   im_eumseinfl3 =              ld_im_eumseinfl3
*   im_evkflaeche =              ld_im_evkflaeche
*   im_evkstart =                ld_im_evkstart
*   im_evkstbez =                ld_im_evkstbez
*   im_ismgeokategorie =         ld_im_ismgeokategorie
*   im_iumseinfl =               ld_im_iumseinfl
*   im_iumseinfl2 =              ld_im_iumseinfl2
*   im_iumseinfl3 =              ld_im_iumseinfl3
*   im_press_salescat =          ld_im_press_salescat
*   im_press_salesvol =          ld_im_press_salesvol
*   im_season =                  ld_im_season
*   im_vkbur =                   ld_im_vkbur
*   im_vkgrp =                   ld_im_vkgrp
*   im_service_type =            ld_im_service_type
*   im_append =                  ld_im_append
*   im_validfrom =               ld_im_validfrom
*   im_validto =                 ld_im_validto
*   im_expectcqp =               ld_im_expectcqp
*   im_planorg_tab =             ld_im_planorg_tab
*   im_protocol_contract_valid =    ld_im_protocol_contract_valid
  IMPORTING
    ex_contract_tab =            ld_ex_contract_tab
    ex_service_tab =             ld_ex_service_tab
    ex_quan_tab =                ld_ex_quan_tab
    ex_return_tab =              ld_ex_return_tab
    .  "  ISM_API_CQP_SELECT

IF SY-SUBRC EQ 0.
  "All OK
ENDIF.







ABAP code to compare 7.40 inline data declaration with original syntax

The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.

DATA:


ld_ex_contract_tab  TYPE RJKSECONTRINDEX_TAB ,
ld_im_vbeln  TYPE RJKSD_VBELN_RANGE_TAB ,
ld_ex_service_tab  TYPE RJKSDCQPSERVICE_DB_TAB ,
ld_im_posnr  TYPE RJKSD_POSNR_RANGE_TAB ,
ld_ex_quan_tab  TYPE RJKSDCQPQUAN_DB_TAB ,
ld_im_product  TYPE RJKSD_PRODUCT_RANGE_TAB ,
ld_ex_return_tab  TYPE BAPIRET2TAB ,
ld_im_ewkun  TYPE RJKSD_BP_RANGE_TAB ,
ld_im_atype  TYPE RJKSD_ASSITYPE_RANGE_TAB ,
ld_im_auart  TYPE RJKSD_AUART_RANGE_TAB ,
ld_im_pstyv  TYPE RJKSD_PSTYV_RANGE_TAB ,
ld_im_chainchannel  TYPE RJKSD_CHAINCHANNEL_RANGE_TAB ,
ld_im_chaincode  TYPE RJKSD_CHAINCODE_RANGE_TAB ,
ld_im_ebedienart  TYPE RJKSD_EBEDIENART_RANGE_TAB ,
ld_im_efrequenz  TYPE RJKSD_EFREQUENZ_RANGE_TAB ,
ld_im_eumseinfl  TYPE RJKSD_EUMSEINFL_RANGE_TAB ,
ld_im_eumseinfl2  TYPE RJKSD_EUMSEINFL_RANGE_TAB ,
ld_im_eumseinfl3  TYPE RJKSD_EUMSEINFL_RANGE_TAB ,
ld_im_evkflaeche  TYPE RJKSD_EVKFLAECHE_RANGE_TAB ,
ld_im_evkstart  TYPE RJKSD_EVKSTART_RANGE_TAB ,
ld_im_evkstbez  TYPE RJKSD_EVKSTBEZ_RANGE_TAB ,
ld_im_ismgeokategorie  TYPE RJKSD_ISMGEOKATEGORIE_RANGE_TA ,
ld_im_iumseinfl  TYPE RJKSD_IUMSEINFL_RANGE_TAB ,
ld_im_iumseinfl2  TYPE RJKSD_IUMSEINFL_RANGE_TAB ,
ld_im_iumseinfl3  TYPE RJKSD_IUMSEINFL_RANGE_TAB ,
ld_im_press_salescat  TYPE RJKSD_PRESS_SALESCAT_RANGE_TAB ,
ld_im_press_salesvol  TYPE RJKSD_PRESS_SALESVOL_RANGE_TAB ,
ld_im_season  TYPE RJKSD_SEASON_RANGE_TAB ,
ld_im_vkbur  TYPE RJKSD_VKBUR_RANGE_TAB ,
ld_im_vkgrp  TYPE RJKSD_VKGRP_RANGE_TAB ,
ld_im_service_type  TYPE JSERVICETYPE_TAB ,
ld_im_append  TYPE XFELD ,
ld_im_validfrom  TYPE SYDATUM ,
ld_im_validto  TYPE SYDATUM ,
ld_im_expectcqp  TYPE XFELD ,
ld_im_planorg_tab  TYPE RJKSD_PLANORG_RANGE_TAB ,
ld_im_protocol_contract_valid  TYPE ABAP_BOOL .




ld_im_vbeln = '20210129'.
ld_im_posnr = '20210129'.
ld_im_product = '20210129'.
ld_im_ewkun = '20210129'.
ld_im_atype = '20210129'.
ld_im_auart = '20210129'.
ld_im_pstyv = '20210129'.
ld_im_chainchannel = '20210129'.
ld_im_chaincode = '20210129'.
ld_im_ebedienart = '20210129'.
ld_im_efrequenz = '20210129'.
ld_im_eumseinfl = '20210129'.
ld_im_eumseinfl2 = '20210129'.
ld_im_eumseinfl3 = '20210129'.
ld_im_evkflaeche = '20210129'.
ld_im_evkstart = '20210129'.
ld_im_evkstbez = '20210129'.
ld_im_ismgeokategorie = '20210129'.
ld_im_iumseinfl = '20210129'.
ld_im_iumseinfl2 = '20210129'.
ld_im_iumseinfl3 = '20210129'.
ld_im_press_salescat = '20210129'.
ld_im_press_salesvol = '20210129'.
ld_im_season = '20210129'.
ld_im_vkbur = '20210129'.
ld_im_vkgrp = '20210129'.
ld_im_service_type = '20210129'.
ld_im_append = '20210129'.
ld_im_validfrom = '20210129'.
ld_im_validto = '20210129'.
ld_im_expectcqp = '20210129'.
ld_im_planorg_tab = '20210129'.
ld_im_protocol_contract_valid = '20210129'.

Contribute (Add Comments)

Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name ISM_API_CQP_SELECT or its description.


   
 

ISM_API_CQP_SELECT - Constant Service: Read Data
ISM_API_CQP_RESTART_DEFAULT - Restart Default Service
ISM_API_CQP_POST - Constant Service: Save Data
ISM_API_CQP_INITIALIZE - Initialize Constant Services for Contracts
ISM_API_CQP_GET_DETAIL - Read Constant Services for a Contract Item
ISM_API_CQP_DEL_SERVICE - Delete Constant Service