string operation

[Former Member]

I want to select MATNR which starts with 'd' or 'g' or 'b' or 'y' into an internal table......how?

[Former Member]

try with wild characters in where of select statement

[Former Member]

TRYING WITH WILD CARD IN WHERE CLAUSE DOESNT GIVE SUCESSFUL SELECTION..MEANS SY-SUBRC = 4 IN THAT CASE... SO SUGGEST SOME WHAT DIFFERENT....

[Former Member]

Try

SELECT * FROM mara INTO CORRESPONDING FIELDS OF TABLE lt WHERE matnr = 'P%' OR matnr like 'G%' OR matnr like 'B%' OR matnr like 'Y%'.

Regards

Tamil

[Former Member]

hi mathew

First select all records database table and put it into Internal table

Then use relational operator Like CP (Contain patten) and then filter the data

Regards

Deva