topic Re: string operation in Application Development and Automation Discussions

string operation

Former Member — Sat, 23 Aug 2008 05:15:19 GMT

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

Former Member — Sat, 23 Aug 2008 05:21:26 GMT

try with wild characters in where of select statement

Former Member — Sat, 23 Aug 2008 05:24:17 GMT

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 — Sat, 23 Aug 2008 05:26:58 GMT

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 — Sat, 23 Aug 2008 05:31:00 GMT

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