SAP ISM_API_CQP_SELECT Function Module for Constant Service: Read Data









ISM_API_CQP_SELECT is a standard ism api cqp select SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Constant Service: Read Data processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for ism api cqp select FM, simply by entering the name ISM_API_CQP_SELECT into the relevant SAP transaction such as SE37 or SE38.

Function Group: JKSDCQP_API
Program Name: SAPLJKSDCQP_API
Main Program: SAPLJKSDCQP_API
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function ISM_API_CQP_SELECT pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'ISM_API_CQP_SELECT'"Constant Service: Read Data
  EXPORTING
*  IM_VBELN =  "Contract Number
*  IM_EBEDIENART =  "Service Type at Point of Sale
*  IM_EFREQUENZ =  "
*  IM_EUMSEINFL =  "External Sales Influence at POS (Primary)
*  IM_EUMSEINFL2 =  "External Sales Influence at POS (Primary)
*  IM_EUMSEINFL3 =  "External Sales Influence at POS (Primary)
*  IM_EVKFLAECHE =  "POS Area Key
*  IM_EVKSTART =  "POS Category
*  IM_EVKSTBEZ =  "POS Type
*  IM_ISMGEOKATEGORIE =  "Geography Category (Geographical Location) for Point of Sale
*  IM_IUMSEINFL =  "
*  IM_POSNR =  "Item Number
*  IM_IUMSEINFL2 =  "
*  IM_IUMSEINFL3 =  "
*  IM_PRESS_SALESCAT =  "Type of Press Products
*  IM_PRESS_SALESVOL =  "Weekly Press Sales
*  IM_SEASON =  "Season Indicator
*  IM_VKBUR =  "Sales Office
*  IM_VKGRP =  "Sales Group
*  IM_SERVICE_TYPE =  "Service Type
*  IM_APPEND = ' ' "Import Data (Select Appending)
*  IM_VALIDFROM = '19000101' "Start Date
*  IM_PRODUCT =  "Media Product
*  IM_VALIDTO = '99991231' "End Date
*  IM_EXPECTCQP = 'X' "
*  IM_PLANORG_TAB =  "Planning Organization
*  IM_PROTOCOL_CONTRACT_VALID = ABAP_FALSE "Log for Contract Validity
*  IM_EWKUN =  "Business Partners
*  IM_ATYPE =  "Assignment Category
*  IM_AUART =  "Contract Type
*  IM_PSTYV =  "Item category
*  IM_CHAINCHANNEL =  "Distribution Channel of Retail Chain to Which POS Belongs
*  IM_CHAINCODE =  "Retail Chain to Which POS Belongs

 IMPORTING
   EX_CONTRACT_TAB =  "Contract Index
   EX_SERVICE_TAB =  "Constant Service
   EX_QUAN_TAB =  "Constant Service Quantities
   EX_RETURN_TAB =  "
.



IMPORTING Parameters details for ISM_API_CQP_SELECT

IM_VBELN - Contract Number

Data type: RJKSD_VBELN_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_EBEDIENART - Service Type at Point of Sale

Data type: RJKSD_EBEDIENART_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_EFREQUENZ -

Data type: RJKSD_EFREQUENZ_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_EUMSEINFL - External Sales Influence at POS (Primary)

Data type: RJKSD_EUMSEINFL_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_EUMSEINFL2 - External Sales Influence at POS (Primary)

Data type: RJKSD_EUMSEINFL_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_EUMSEINFL3 - External Sales Influence at POS (Primary)

Data type: RJKSD_EUMSEINFL_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_EVKFLAECHE - POS Area Key

Data type: RJKSD_EVKFLAECHE_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_EVKSTART - POS Category

Data type: RJKSD_EVKSTART_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_EVKSTBEZ - POS Type

Data type: RJKSD_EVKSTBEZ_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_ISMGEOKATEGORIE - Geography Category (Geographical Location) for Point of Sale

Data type: RJKSD_ISMGEOKATEGORIE_RANGE_TA
Optional: Yes
Call by Reference: Yes

IM_IUMSEINFL -

Data type: RJKSD_IUMSEINFL_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_POSNR - Item Number

Data type: RJKSD_POSNR_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_IUMSEINFL2 -

Data type: RJKSD_IUMSEINFL_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_IUMSEINFL3 -

Data type: RJKSD_IUMSEINFL_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_PRESS_SALESCAT - Type of Press Products

Data type: RJKSD_PRESS_SALESCAT_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_PRESS_SALESVOL - Weekly Press Sales

Data type: RJKSD_PRESS_SALESVOL_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_SEASON - Season Indicator

Data type: RJKSD_SEASON_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_VKBUR - Sales Office

Data type: RJKSD_VKBUR_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_VKGRP - Sales Group

Data type: RJKSD_VKGRP_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_SERVICE_TYPE - Service Type

Data type: JSERVICETYPE_TAB
Optional: Yes
Call by Reference: Yes

IM_APPEND - Import Data (Select Appending)

Data type: XFELD
Default: SPACE
Optional: Yes
Call by Reference: No ( called with pass by value option)

IM_VALIDFROM - Start Date

Data type: SYDATUM
Default: '19000101'
Optional: Yes
Call by Reference: No ( called with pass by value option)

IM_PRODUCT - Media Product

Data type: RJKSD_PRODUCT_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_VALIDTO - End Date

Data type: SYDATUM
Default: '99991231'
Optional: Yes
Call by Reference: No ( called with pass by value option)

IM_EXPECTCQP -

Data type: XFELD
Default: 'X'
Optional: Yes
Call by Reference: No ( called with pass by value option)

IM_PLANORG_TAB - Planning Organization

Data type: RJKSD_PLANORG_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_PROTOCOL_CONTRACT_VALID - Log for Contract Validity

Data type: ABAP_BOOL
Default: ABAP_FALSE
Optional: Yes
Call by Reference: Yes

IM_EWKUN - Business Partners

Data type: RJKSD_BP_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_ATYPE - Assignment Category

Data type: RJKSD_ASSITYPE_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_AUART - Contract Type

Data type: RJKSD_AUART_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_PSTYV - Item category

Data type: RJKSD_PSTYV_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_CHAINCHANNEL - Distribution Channel of Retail Chain to Which POS Belongs

Data type: RJKSD_CHAINCHANNEL_RANGE_TAB
Optional: Yes
Call by Reference: Yes

IM_CHAINCODE - Retail Chain to Which POS Belongs

Data type: RJKSD_CHAINCODE_RANGE_TAB
Optional: Yes
Call by Reference: Yes

EXPORTING Parameters details for ISM_API_CQP_SELECT

EX_CONTRACT_TAB - Contract Index

Data type: RJKSECONTRINDEX_TAB
Optional: No
Call by Reference: Yes

EX_SERVICE_TAB - Constant Service

Data type: RJKSDCQPSERVICE_DB_TAB
Optional: No
Call by Reference: Yes

EX_QUAN_TAB - Constant Service Quantities

Data type: RJKSDCQPQUAN_DB_TAB
Optional: No
Call by Reference: Yes

EX_RETURN_TAB -

Data type: BAPIRET2TAB
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for ISM_API_CQP_SELECT Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than 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 newer method of declaring data variables on the fly. 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), which i why i have stuck to the origianl for this example.

DATA:
lv_im_vbeln  TYPE RJKSD_VBELN_RANGE_TAB, "   
lv_ex_contract_tab  TYPE RJKSECONTRINDEX_TAB, "   
lv_im_ebedienart  TYPE RJKSD_EBEDIENART_RANGE_TAB, "   
lv_im_efrequenz  TYPE RJKSD_EFREQUENZ_RANGE_TAB, "   
lv_im_eumseinfl  TYPE RJKSD_EUMSEINFL_RANGE_TAB, "   
lv_im_eumseinfl2  TYPE RJKSD_EUMSEINFL_RANGE_TAB, "   
lv_im_eumseinfl3  TYPE RJKSD_EUMSEINFL_RANGE_TAB, "   
lv_im_evkflaeche  TYPE RJKSD_EVKFLAECHE_RANGE_TAB, "   
lv_im_evkstart  TYPE RJKSD_EVKSTART_RANGE_TAB, "   
lv_im_evkstbez  TYPE RJKSD_EVKSTBEZ_RANGE_TAB, "   
lv_im_ismgeokategorie  TYPE RJKSD_ISMGEOKATEGORIE_RANGE_TA, "   
lv_im_iumseinfl  TYPE RJKSD_IUMSEINFL_RANGE_TAB, "   
lv_im_posnr  TYPE RJKSD_POSNR_RANGE_TAB, "   
lv_ex_service_tab  TYPE RJKSDCQPSERVICE_DB_TAB, "   
lv_im_iumseinfl2  TYPE RJKSD_IUMSEINFL_RANGE_TAB, "   
lv_im_iumseinfl3  TYPE RJKSD_IUMSEINFL_RANGE_TAB, "   
lv_im_press_salescat  TYPE RJKSD_PRESS_SALESCAT_RANGE_TAB, "   
lv_im_press_salesvol  TYPE RJKSD_PRESS_SALESVOL_RANGE_TAB, "   
lv_im_season  TYPE RJKSD_SEASON_RANGE_TAB, "   
lv_im_vkbur  TYPE RJKSD_VKBUR_RANGE_TAB, "   
lv_im_vkgrp  TYPE RJKSD_VKGRP_RANGE_TAB, "   
lv_im_service_type  TYPE JSERVICETYPE_TAB, "   
lv_im_append  TYPE XFELD, "   SPACE
lv_im_validfrom  TYPE SYDATUM, "   '19000101'
lv_im_product  TYPE RJKSD_PRODUCT_RANGE_TAB, "   
lv_ex_quan_tab  TYPE RJKSDCQPQUAN_DB_TAB, "   
lv_im_validto  TYPE SYDATUM, "   '99991231'
lv_im_expectcqp  TYPE XFELD, "   'X'
lv_im_planorg_tab  TYPE RJKSD_PLANORG_RANGE_TAB, "   
lv_im_protocol_contract_valid  TYPE ABAP_BOOL, "   ABAP_FALSE
lv_im_ewkun  TYPE RJKSD_BP_RANGE_TAB, "   
lv_ex_return_tab  TYPE BAPIRET2TAB, "   
lv_im_atype  TYPE RJKSD_ASSITYPE_RANGE_TAB, "   
lv_im_auart  TYPE RJKSD_AUART_RANGE_TAB, "   
lv_im_pstyv  TYPE RJKSD_PSTYV_RANGE_TAB, "   
lv_im_chainchannel  TYPE RJKSD_CHAINCHANNEL_RANGE_TAB, "   
lv_im_chaincode  TYPE RJKSD_CHAINCODE_RANGE_TAB. "   

  CALL FUNCTION 'ISM_API_CQP_SELECT'  "Constant Service: Read Data
    EXPORTING
         IM_VBELN = lv_im_vbeln
         IM_EBEDIENART = lv_im_ebedienart
         IM_EFREQUENZ = lv_im_efrequenz
         IM_EUMSEINFL = lv_im_eumseinfl
         IM_EUMSEINFL2 = lv_im_eumseinfl2
         IM_EUMSEINFL3 = lv_im_eumseinfl3
         IM_EVKFLAECHE = lv_im_evkflaeche
         IM_EVKSTART = lv_im_evkstart
         IM_EVKSTBEZ = lv_im_evkstbez
         IM_ISMGEOKATEGORIE = lv_im_ismgeokategorie
         IM_IUMSEINFL = lv_im_iumseinfl
         IM_POSNR = lv_im_posnr
         IM_IUMSEINFL2 = lv_im_iumseinfl2
         IM_IUMSEINFL3 = lv_im_iumseinfl3
         IM_PRESS_SALESCAT = lv_im_press_salescat
         IM_PRESS_SALESVOL = lv_im_press_salesvol
         IM_SEASON = lv_im_season
         IM_VKBUR = lv_im_vkbur
         IM_VKGRP = lv_im_vkgrp
         IM_SERVICE_TYPE = lv_im_service_type
         IM_APPEND = lv_im_append
         IM_VALIDFROM = lv_im_validfrom
         IM_PRODUCT = lv_im_product
         IM_VALIDTO = lv_im_validto
         IM_EXPECTCQP = lv_im_expectcqp
         IM_PLANORG_TAB = lv_im_planorg_tab
         IM_PROTOCOL_CONTRACT_VALID = lv_im_protocol_contract_valid
         IM_EWKUN = lv_im_ewkun
         IM_ATYPE = lv_im_atype
         IM_AUART = lv_im_auart
         IM_PSTYV = lv_im_pstyv
         IM_CHAINCHANNEL = lv_im_chainchannel
         IM_CHAINCODE = lv_im_chaincode
    IMPORTING
         EX_CONTRACT_TAB = lv_ex_contract_tab
         EX_SERVICE_TAB = lv_ex_service_tab
         EX_QUAN_TAB = lv_ex_quan_tab
         EX_RETURN_TAB = lv_ex_return_tab
. " ISM_API_CQP_SELECT




ABAP code using 7.40 inline data declarations to call FM ISM_API_CQP_SELECT

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
DATA(ld_im_append) = ' '.
 
DATA(ld_im_validfrom) = '19000101'.
 
 
 
DATA(ld_im_validto) = '99991231'.
 
DATA(ld_im_expectcqp) = 'X'.
 
 
DATA(ld_im_protocol_contract_valid) = ABAP_FALSE.
 
 
 
 
 
 
 
 


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!