SAP Reports / Programs

Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

DYNSQL_GENERATE_WHERE_CLAUSE==FT SAP ABAP Report - DYNSQLGENERATEWHERECLAUSE==FT

SAP T-Codes / Example ABAP code
ABAP OO / SAP Function Modules
ABAP reports / SAP Error Messages
SAP Tables / SAP Video Training

DYNSQL_GENERATE_WHERE_CLAUSE== is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter DYNSQL_GENERATE_WHERE_CLAUSE== into the relevant SAP transactions such as SE38 or SE80

ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.

SUBMIT DYNSQL_GENERATE_WHERE_CLAUSE==FT. "Basic submit
SUBMIT DYNSQL_GENERATE_WHERE_CLAUSE==FT AND RETURN. "Return to original report after report execution complete
SUBMIT DYNSQL_GENERATE_WHERE_CLAUSE==FT VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement

INCLUDES used within this REPORT DYNSQL_GENERATE_WHERE_CLAUSE==FT

No INCLUDES are used within this REPORT code!

TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!

Function Modules used within report and the associated call statement:

DYNSQL_GENERATE_WHERE_CLAUSE CALL FUNCTION 'DYNSQL_GENERATE_WHERE_CLAUSE' EXPORTING FIELDNAME_KEY_1 = %_IFIELDNAME_KEY_1 FIELDNAME_KEY_2 = %_IFIELDNAME_KEY_2 FIELDNAME_VALUE = %_IFIELDNAME_VALUE OPERATOR = %_IOPERATOR PRIO_FELD = %_IPRIO_FELD TABLES WHERE_CLAUSE = %_OWHERE_CLAUSE CONTROL_TABLE = %_OCONTROL_TABLE ALL_VALUES_KEY_1 = %_OALL_VALUES_KEY_1 VALUES_KEY_1 = %_OVALUES_KEY_1 ALL_VALUES_KEY_2 = %_OALL_VALUES_KEY_2 VALUES_KEY_2 = %_OVALUES_KEY_2 CHANGING KEY_1_IS_IN_WHERE_CLAUSE = %_OKEY_1_IS_IN_WHERE_CLAUSE KEY_2_IS_IN_WHERE_CLAUSE = %_OKEY_2_IS_IN_WHERE_CLAUSE EXCEPTIONS DYNSQL_TOO_LARGE = 001 WRONG_ENTRY_IN_CONTROL_TABLE = 002 KEY_VALUES_INCONSISTENT = 003 NO_ENTRY_FOUND = 004 FUNCTION_ALREADY_CALLED = 005.

DYNSQL_GENERATE_WHERE_CLAUSE CALL FUNCTION 'DYNSQL_GENERATE_WHERE_CLAUSE' DESTINATION DESTI EXPORTING FIELDNAME_KEY_1 = %_IFIELDNAME_KEY_1 FIELDNAME_KEY_2 = %_IFIELDNAME_KEY_2 FIELDNAME_VALUE = %_IFIELDNAME_VALUE OPERATOR = %_IOPERATOR PRIO_FELD = %_IPRIO_FELD TABLES WHERE_CLAUSE = %_OWHERE_CLAUSE CONTROL_TABLE = %_OCONTROL_TABLE ALL_VALUES_KEY_1 = %_OALL_VALUES_KEY_1 VALUES_KEY_1 = %_OVALUES_KEY_1 ALL_VALUES_KEY_2 = %_OALL_VALUES_KEY_2 VALUES_KEY_2 = %_OVALUES_KEY_2 CHANGING KEY_1_IS_IN_WHERE_CLAUSE = %_OKEY_1_IS_IN_WHERE_CLAUSE KEY_2_IS_IN_WHERE_CLAUSE = %_OKEY_2_IS_IN_WHERE_CLAUSE EXCEPTIONS DYNSQL_TOO_LARGE = 001 WRONG_ENTRY_IN_CONTROL_TABLE = 002 KEY_VALUES_INCONSISTENT = 003 NO_ENTRY_FOUND = 004 FUNCTION_ALREADY_CALLED = 005.

RS_COMPLEX_OBJECT_EDIT CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT' EXPORTING OBJECT_NAME = 'FIELDNAME_KEY_1' MODE = P_MODE INSERT_TAB = 'X' UPPER_CASE = P_UPPER CHANGING OBJECT = %_IFIELDNAME_KEY_1.

RS_COMPLEX_OBJECT_EDIT CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT' EXPORTING OBJECT_NAME = 'FIELDNAME_KEY_2' MODE = P_MODE INSERT_TAB = 'X' UPPER_CASE = P_UPPER CHANGING OBJECT = %_IFIELDNAME_KEY_2.

RS_COMPLEX_OBJECT_EDIT CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT' EXPORTING OBJECT_NAME = 'FIELDNAME_VALUE' MODE = P_MODE INSERT_TAB = 'X' UPPER_CASE = P_UPPER CHANGING OBJECT = %_IFIELDNAME_VALUE.

RS_COMPLEX_OBJECT_EDIT CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT' EXPORTING OBJECT_NAME = 'OPERATOR' MODE = P_MODE INSERT_TAB = 'X' UPPER_CASE = P_UPPER CHANGING OBJECT = %_IOPERATOR.

RS_COMPLEX_OBJECT_EDIT CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT' EXPORTING OBJECT_NAME = 'PRIO_FELD' MODE = P_MODE INSERT_TAB = 'X' UPPER_CASE = P_UPPER CHANGING OBJECT = %_IPRIO_FELD.

RS_COMPLEX_OBJECT_EDIT CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT' EXPORTING OBJECT_NAME = 'KEY_1_IS_IN_WHERE_CLAUSE' MODE = P_MODE INSERT_TAB = 'X' UPPER_CASE = P_UPPER CHANGING OBJECT = %_IKEY_1_IS_IN_WHERE_CLAUSE.

RS_COMPLEX_OBJECT_EDIT CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT' EXPORTING OBJECT_NAME = 'KEY_2_IS_IN_WHERE_CLAUSE' MODE = P_MODE INSERT_TAB = 'X' UPPER_CASE = P_UPPER CHANGING OBJECT = %_IKEY_2_IS_IN_WHERE_CLAUSE.

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'WHERE_CLAUSE'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_IWHERE_CLAUSE[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'WHERE_CLAUSE'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_OWHERE_CLAUSE[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'WHERE_CLAUSE'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_VWHERE_CLAUSE[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'CONTROL_TABLE'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_ICONTROL_TABLE[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'CONTROL_TABLE'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_OCONTROL_TABLE[].

RS_COMPLEX_OBJECT_EDIT














    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'CONTROL_TABLE'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_VCONTROL_TABLE[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'ALL_VALUES_KEY_1'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_IALL_VALUES_KEY_1[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'ALL_VALUES_KEY_1'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_OALL_VALUES_KEY_1[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'ALL_VALUES_KEY_1'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_VALL_VALUES_KEY_1[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'VALUES_KEY_1'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_IVALUES_KEY_1[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'VALUES_KEY_1'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_OVALUES_KEY_1[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'VALUES_KEY_1'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_VVALUES_KEY_1[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'ALL_VALUES_KEY_2'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_IALL_VALUES_KEY_2[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'ALL_VALUES_KEY_2'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_OALL_VALUES_KEY_2[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'ALL_VALUES_KEY_2'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_VALL_VALUES_KEY_2[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'VALUES_KEY_2'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_IVALUES_KEY_2[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'VALUES_KEY_2'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_OVALUES_KEY_2[].

RS_COMPLEX_OBJECT_EDIT
    CALL FUNCTION 'RS_COMPLEX_OBJECT_EDIT'
         EXPORTING
OBJECT_NAME = 'VALUES_KEY_2'
MODE = P_MODE
INSERT_TAB = 'X'
UPPER_CASE = P_UPPER
         CHANGING
OBJECT = %_VVALUES_KEY_2[].

SWC_ELEMENT_SET CALL FUNCTION 'SWC_ELEMENT_SET' EXPORTING ELEMENT = NAME FIELD = %_IFIELDNAME_KEY_1 TABLES CONTAINER = LCONT.

SWC_ELEMENT_GET CALL FUNCTION 'SWC_ELEMENT_GET' EXPORTING ELEMENT = NAME IMPORTING FIELD = %_IFIELDNAME_KEY_1 TABLES CONTAINER = LCONT.

SWC_ELEMENT_SET CALL FUNCTION 'SWC_ELEMENT_SET' EXPORTING ELEMENT = NAME FIELD = %_IFIELDNAME_KEY_2 TABLES CONTAINER = LCONT.

SWC_ELEMENT_GET CALL FUNCTION 'SWC_ELEMENT_GET' EXPORTING ELEMENT = NAME IMPORTING FIELD = %_IFIELDNAME_KEY_2 TABLES CONTAINER = LCONT.

SWC_ELEMENT_SET CALL FUNCTION 'SWC_ELEMENT_SET' EXPORTING ELEMENT = NAME FIELD = %_IFIELDNAME_VALUE TABLES CONTAINER = LCONT.

SWC_ELEMENT_GET CALL FUNCTION 'SWC_ELEMENT_GET' EXPORTING ELEMENT = NAME IMPORTING FIELD = %_IFIELDNAME_VALUE TABLES CONTAINER = LCONT.

SWC_ELEMENT_SET CALL FUNCTION 'SWC_ELEMENT_SET' EXPORTING ELEMENT = NAME FIELD = %_IOPERATOR TABLES CONTAINER = LCONT.

SWC_ELEMENT_GET CALL FUNCTION 'SWC_ELEMENT_GET' EXPORTING ELEMENT = NAME IMPORTING FIELD = %_IOPERATOR TABLES CONTAINER = LCONT.

SWC_ELEMENT_SET CALL FUNCTION 'SWC_ELEMENT_SET' EXPORTING ELEMENT = NAME FIELD = %_IPRIO_FELD TABLES CONTAINER = LCONT.

SWC_ELEMENT_GET CALL FUNCTION 'SWC_ELEMENT_GET' EXPORTING ELEMENT = NAME IMPORTING FIELD = %_IPRIO_FELD TABLES CONTAINER = LCONT.

SWC_ELEMENT_SET CALL FUNCTION 'SWC_ELEMENT_SET' EXPORTING ELEMENT = NAME FIELD = %_IKEY_1_IS_IN_WHERE_CLAUSE TABLES CONTAINER = LCONT.

SWC_ELEMENT_GET CALL FUNCTION 'SWC_ELEMENT_GET' EXPORTING ELEMENT = NAME IMPORTING FIELD = %_IKEY_1_IS_IN_WHERE_CLAUSE TABLES CONTAINER = LCONT.

SWC_ELEMENT_SET CALL FUNCTION 'SWC_ELEMENT_SET' EXPORTING ELEMENT = NAME FIELD = %_IKEY_2_IS_IN_WHERE_CLAUSE TABLES CONTAINER = LCONT.

SWC_ELEMENT_GET CALL FUNCTION 'SWC_ELEMENT_GET' EXPORTING ELEMENT = NAME IMPORTING FIELD = %_IKEY_2_IS_IN_WHERE_CLAUSE TABLES CONTAINER = LCONT.

SWC_ELEMENT_SET CALL FUNCTION 'SWC_ELEMENT_SET' EXPORTING ELEMENT = NAME FIELD = %_OKEY_1_IS_IN_WHERE_CLAUSE TABLES CONTAINER = LCONT.

SWC_ELEMENT_GET CALL FUNCTION 'SWC_ELEMENT_GET' EXPORTING ELEMENT = NAME IMPORTING FIELD = %_OKEY_1_IS_IN_WHERE_CLAUSE TABLES CONTAINER = LCONT.

SWC_ELEMENT_SET CALL FUNCTION 'SWC_ELEMENT_SET' EXPORTING ELEMENT = NAME FIELD = %_OKEY_2_IS_IN_WHERE_CLAUSE TABLES CONTAINER = LCONT.

SWC_ELEMENT_GET CALL FUNCTION 'SWC_ELEMENT_GET' EXPORTING ELEMENT = NAME IMPORTING FIELD = %_OKEY_2_IS_IN_WHERE_CLAUSE TABLES CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IWHERE_CLAUSE CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IWHERE_CLAUSE CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_ICONTROL_TABLE CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_ICONTROL_TABLE CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IALL_VALUES_KEY_1 CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IALL_VALUES_KEY_1 CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IVALUES_KEY_1 CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IVALUES_KEY_1 CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IALL_VALUES_KEY_2 CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IALL_VALUES_KEY_2 CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IVALUES_KEY_2 CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_IVALUES_KEY_2 CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OWHERE_CLAUSE CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OWHERE_CLAUSE CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OCONTROL_TABLE CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OCONTROL_TABLE CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OALL_VALUES_KEY_1 CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OALL_VALUES_KEY_1 CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OVALUES_KEY_1 CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OVALUES_KEY_1 CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OALL_VALUES_KEY_2 CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OALL_VALUES_KEY_2 CONTAINER = LCONT.

SWC_TABLE_SET CALL FUNCTION 'SWC_TABLE_SET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OVALUES_KEY_2 CONTAINER = LCONT.

SWC_TABLE_GET CALL FUNCTION 'SWC_TABLE_GET' EXPORTING ELEMENT = NAME TABLES TABLE = %_OVALUES_KEY_2 CONTAINER = LCONT.

Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name DYNSQL_GENERATE_WHERE_CLAUSE== or its description.

DYNSQL_GENERATE_WHERE_CLAUSE==FT - DYNSQLGENERATEWHERECLAUSE==FT
DX_DOC_BDS - Demonstration for Using BDS In Office Integration
DX_DOC_BDS - Demonstration for Using BDS In Office Integration
DXTOOLSTOP - documentation and ABAP source code
DXTOOLSSUB_OTHER - DXTOOLSSUBOTHER
DXTOOLSPBO - documentation and ABAP source code