SAP Function Modules

comments icon Comments

RSDS_ACCESS_DB_SELECT_DYNAMIC SAP Function module - Prepare SQL Statement as per the selection criteria







RSDS_ACCESS_DB_SELECT_DYNAMIC 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 RSDS_ACCESS_DB_SELECT_DYNAMIC into the relevant SAP transaction such as SE37 or SE80.

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


Pattern for FM RSDS_ACCESS_DB_SELECT_DYNAMIC - RSDS ACCESS DB SELECT DYNAMIC 





CALL FUNCTION 'RSDS_ACCESS_DB_SELECT_DYNAMIC' "Prepare SQL Statement as per the selection criteria
  EXPORTING
    i_t_field =                 " rsds_t_fields  Table of Fields
    i_t_select =                " rs_t_rscedst  Transfer structure
    i_r_attr =                  " object        Storage class for DB Connect
  IMPORTING
    e_t_condition =             " rsds_t_string  Table of condition string
  EXCEPTIONS
    INVALID_SELECTION_CRITERIA = 1  "
    .  "  RSDS_ACCESS_DB_SELECT_DYNAMIC

ABAP code example for Function Module RSDS_ACCESS_DB_SELECT_DYNAMIC





The ABAP code below is a full code listing to execute function module RSDS_ACCESS_DB_SELECT_DYNAMIC 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_e_t_condition    TYPE RSDS_T_STRING
.




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

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

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

CALL FUNCTION 'RSDS_ACCESS_DB_SELECT_DYNAMIC'
  EXPORTING
    i_t_field =                  ld_i_t_field
    i_t_select =                 ld_i_t_select
    i_r_attr =                   ld_i_r_attr
  IMPORTING
    e_t_condition =              ld_e_t_condition
  EXCEPTIONS
    INVALID_SELECTION_CRITERIA =    1
    .  "  RSDS_ACCESS_DB_SELECT_DYNAMIC

IF SY-SUBRC EQ 0.
  "All OK
ELSEIF SY-SUBRC EQ 1. "Exception
  "Add code for exception here
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_e_t_condition  TYPE RSDS_T_STRING ,
ld_i_t_field  TYPE RSDS_T_FIELDS ,
ld_i_t_select  TYPE RS_T_RSCEDST ,
ld_i_r_attr  TYPE OBJECT .




ld_i_t_field = 'Check type of data required'.
ld_i_t_select = 'Check type of data required'.
ld_i_r_attr = 'Check type of data required'.

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 RSDS_ACCESS_DB_SELECT_DYNAMIC or its description.


   
 

RSDS_ACCESS_DB_SELECT_DYNAMIC - Prepare SQL Statement as per the selection criteria
RSDS_ACCESS_DB_FIELDS_GET - Liefert die Beschreibung der Felder einer DB-Tabelle für BW
RSDS_ACCESS_DB_DATA_UPLOAD_2 - Upload Data from DB
RSDS_ACCESS_DB_DATA_UPLOAD - Upload Data from DB
RSDS_ACCESS_DBEXTRACT_SETGET - Set and Get DB-Extract gloabl fields
RSDS_ACCESS_CLOSE_EXCEL - Excel schliessen