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

           anln2

           typbz

       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.

      ENDIF.

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.

 

Thanks.

Actions