SAP RSSDK_DATA_REMOTE_QRY_EXEC Function Module for Execute Query in the remote system and receive result (sync)

Search SAP Function Modules

RSSDK_DATA_REMOTE_QRY_EXEC is a standard rssdk data remote qry exec SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Execute Query in the remote system and receive result (sync) 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 rssdk data remote qry exec FM, simply by entering the name RSSDK_DATA_REMOTE_QRY_EXEC into the relevant SAP transaction such as SE37 or SE38.

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

Function RSSDK_DATA_REMOTE_QRY_EXEC 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 'RSSDK_DATA_REMOTE_QRY_EXEC'"Execute Query in the remote system and receive result (sync)
  EXPORTING
   I_QSYSTEMNAME =  "Source System
   I_DATASOURCE =  "Data Type That Maps the Name of BI SDK DataSources
   I_RFCDEST =  "DataSource
*  I_READ_PACK = RS_C_FALSE "Boolean
*  I_STRUCTNAME = '' "
*  I_MAXSIZE = 0 "Maximum number of table entries in extraction API interface
*  I_CACHE_KEY_IN = 0 "Key fo this round
*  I_JAVA_PACKSIZE = 6000 "Default package size for Java fetch

 IMPORTING
   E_LAST_PACK =  "Boolean
   E_CACHE_KEY_OUT =  "for next round

TABLES
*  I_T_FIE =  "Structure for SDK DataSource Fields
*  I_T_SELVALUES =  "
*  E_T_MESSAGES =  "Notification Transfer
*  E_T_DATA =  "Result buffer (dynamic)
*  I_T_MAP =  "UDC Table for UDC DS According to BW Assignment
*  E_T_DATA_B =  "

EXCEPTIONS
   UNKNOWN_SDK_METADATA = 1    UNKNOWN_SDK_SYSTEM = 2    COMP_NUM_MISMATCH = 3    COMP_NAM_MISMATCH = 4 

.

IMPORTING Parameters details for RSSDK_DATA_REMOTE_QRY_EXEC

I_QSYSTEMNAME - Source System

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

I_DATASOURCE - Data Type That Maps the Name of BI SDK DataSources

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

I_RFCDEST - DataSource

Data type: RFCDES-RFCDEST
Optional: No
Call by Reference: Yes

I_READ_PACK - Boolean

Data type: RS_BOOL
Default: RS_C_FALSE
Optional: Yes
Call by Reference: Yes

I_STRUCTNAME -

Data type: ABAP_ABSTYPENAME
Default: ''
Optional: Yes
Call by Reference: Yes

I_MAXSIZE - Maximum number of table entries in extraction API interface

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

I_CACHE_KEY_IN - Key fo this round

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

I_JAVA_PACKSIZE - Default package size for Java fetch

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

EXPORTING Parameters details for RSSDK_DATA_REMOTE_QRY_EXEC

E_LAST_PACK - Boolean

Data type: RS_BOOL
Optional: No
Call by Reference: No ( called with pass by value option)

E_CACHE_KEY_OUT - for next round

Data type: I
Optional: No
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for RSSDK_DATA_REMOTE_QRY_EXEC

I_T_FIE - Structure for SDK DataSource Fields

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

I_T_SELVALUES -

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

E_T_MESSAGES - Notification Transfer

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

E_T_DATA - Result buffer (dynamic)

Data type: STANDARD TABLE
Optional: Yes
Call by Reference: Yes

I_T_MAP - UDC Table for UDC DS According to BW Assignment

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

E_T_DATA_B -

Data type: STANDARD TABLE
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

UNKNOWN_SDK_METADATA -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

UNKNOWN_SDK_SYSTEM -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

COMP_NUM_MISMATCH -

Data type:
Optional: No
Call by Reference: Yes

COMP_NAM_MISMATCH -

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for RSSDK_DATA_REMOTE_QRY_EXEC 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.

ABAP code using 7.40 inline data declarations to call FM RSSDK_DATA_REMOTE_QRY_EXEC

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.

Search for further information about these or an SAP related objects