topic Re: Dynamic Where Clause in Application Development and Automation Discussions

Dynamic Where Clause

Former Member — Wed, 08 Aug 2007 11:01:47 GMT

Hi,

Iam getting a Runtime Error when iam execuating the below select statement.iam calling IT_WHERE dynamically.

  DATA : IT_WHERE like RFC_DB_OPT OCCURS 0 WITH HEADER LINE.
SELECT SINGLE KNUMH INTO <FS4>-KNUMH FROM (GLOBAL-KOTABNR)
                          WHERE KSCHL = <FS4>-KSCHL
                               AND KAPPL = 'V '
                               AND ( DATBI GE SY-DATUM
                               AND   DATAB LE SY-DATUM )
                            <b>AND (IT_WHERE).</b>

Thanks

Vikranth Khimavath

Re: Dynamic Where Clause

Former Member — Wed, 08 Aug 2007 11:12:09 GMT

Hi.

in the IT_WHERE you need to write the correct conditions, like

IT_WHERE-FIELD1 = 'DATE1 = Sy-DATUM and'.

Append IT_WHERE.

IT_WHERE-FIELD1 = 'DATE2 = Sy-DATUM'.

Append IT_WHERE.

Regards

Sudheer

Re: Dynamic Where Clause

Former Member — Wed, 08 Aug 2007 11:15:55 GMT

Hi Vikranth

You cannot give a individual field as the dynamic where clause. You have to append all the records into that internal table "IT_WHERE" and then pass that. I mean the first 4 lines of your Where clause. SO finally your where clause should look like Where (IT_WHERE).

~Ranganath