Select statement with offset?
<p>I'm trying to use this SELECT statement in ABAP:</p>

<pre><code>  SELECT DISTINCT * FROM  dbtab
     INTO CORRESPONDING FIELDS OF TABLE itab
     WHERE  field1+7(16)  IN s_field1
     AND    field2        IN s_field2.
</code></pre>

<p>but I can't use offset for a dbtab column.
How can I solve this problem?</p>

<p>I'm trying to avoid loop like</p>

<pre><code>  SELECT DISTINCT * FROM  dbtab
     WHERE  field2        IN s_field2.
       IF field1+7(16)  IN s_field1
           ...
       endif.
  endselect.
</code></pre>