4 Replies Latest reply: Mar 24, 2009 2:47 PM by Kuntal Nandi RSS

Contains pattern in select

lakkireddy sarala
Currently Being Moderated

Hi All,


  I have a requirment in select statement as below.



SELECT anln1



       FROM anla

       INTO TABLE it_anla

       FOR ALL ENTRIES IN it_asset

       WHERE typbz = it_asset-purch.  "Contains pattern

      IF sy-subrc EQ 0.

      SORT it_anla BY typbz anln1 anln2.


i need to select the ANLA table entries  which contains the pattern IT_ASSET-purch which is not constant. like it_asset-purch* .


but its giving error if i write like this.


can any one suggest me good way of doing this.