topic Re: Dynamic Select Query-Odata in Application Development and Automation Discussions

Dynamic Select Query-Odata

aditi_br — Wed, 15 Oct 2014 05:50:45 GMT

I would like to know which type of select statement to be used if the values(or the number of values) in the where clause is not fixed. I have three input fields, and from the UI( Fiori app) I might fill just two fields or I might fill up all the fields. Regarding this, my select statement should consider the values for filter and provide the result accordingly.

Thanks & Regards,

Aditi

Re: Dynamic Select Query-Odata

Former Member — Wed, 15 Oct 2014 06:18:03 GMT

Hi Aditi,

To build dynamic select quiery you can use FM RH_DYNAMIC_WHERE_BUILD

Re: Dynamic Select Query-Odata

Former Member — Wed, 15 Oct 2014 06:48:11 GMT

Hi Aditi,

you can check for the null values using IS NOT INITIAL and can combine it with IF-ELSE statement to provide the corresponding select statement.

for e.g.

SELECTION-SCREEN: BEGIN OF BLOCK SEL WITH FRAME TITLE TEXT-001.
PARAMETERS     : MAT   TYPE MARD-MATNR.
PARAMETERS     : PLANT TYPE MARD-WERKS.
PARAMETERS     : STLOC TYPE MARD-LGORT.
SELECTION-SCREEN: END OF BLOCK SEL.

START-OF-SELECTION.

IF STLOC IS NOT INITIAL.
SELECT * FROM MARD INTO TABLE ITAB WHERE MATNR = MAT AND WERKS = PLANT AND LGORT = STLOC.
ELSEIF PLANT IS NOT INITIAL.
SELECT * FROM MARD INTO TABLE ITAB WHERE MATNR = MAT AND WERKS = PLANT.
ELSEIF MAT IS NOT INITIAL.
SELECT * FROM MARD INTO TABLE ITAB WHERE MATNR = MAT.
ELSE.
SELECT * FROM MARD INTO TABLE ITAB.
ENDIF.

Re: Dynamic Select Query-Odata

vinodkumar_thangavel — Wed, 15 Oct 2014 06:53:21 GMT

Hi,

If the input is dynamic in that case better u shall go for range tables to be filled up with values and pass the same to select query.

Regards,

Vinodkumar.

Re: Dynamic Select Query-Odata

aditi_br — Wed, 15 Oct 2014 08:28:54 GMT

Thanks all