Skip to Content
1
Former Member
Aug 08, 2007 at 11:01 AM

Dynamic Where Clause

17 Views

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