about Dynamic Conditions

[Former Member]

hello,

if i want to use Dynamic Conditions in select,how can i do? Dynamic Conditions 'where'.

[Former Member]

hello,

if i want to use Dynamic Conditions in select,how can i do? Dynamic Conditions 'where'.

[Former Member]

Hi.

PARAMETERS: airline(2) TYPE C,

date TYPE D.

DATA: where_clause TYPE STRING,

connid TYPE sflight-connid.

CONCATENATE 'carrid = ''' airline ''''

' AND fldate = ''' date '''' INTO where_clause.

SELECT connid FROM sflight INTO connid

WHERE (where_clause).

WRITE: / date, airline, connid.

ENDSELECT.

[uwe_schieferstein]

Hello Hong

You can also use function module <b>RH_DYNAMIC_WHERE_BUILD</b> to automatically generate WHERE clauses consisting of AND conditions. The itab containing the WHERE clauses can, of course, be modified and adjusted.

Regards

Uwe

[Former Member]

Hi,

TABLES: VBAK.

SELECT-OPTIONS S_VBELN FOR VBAK-VBELN.

DATA: lV_STR1(20) TYPE C VALUE 'VBELN IN S_VBELN.'.

DATA: GI_WHERE(72) OCCURS 0 WITH HEADER LINE.

GI_WHERE = LV_STR1.

APPEND GI_WHERE.

DATA GI_VBAK LIKE VBAK OCCURS 0 WITH HEADER LINE.

SELECT VBELN

INTO TABLE GI_VBAK

FROM VBAK

WHERE (gi_where).

Regards

amole

[seshatalpasai_madala]

Hi,

You can build a string of the where clause using the concatenate and then pass that string to select as follows.

SELECT FROM table into table itab where (where_string).

Regards,

Sesh