topic Re: Select query problem in Application Development and Automation Discussions

Select query problem

Former Member — Tue, 20 Sep 2011 03:44:28 GMT

Hi guys,

In my select query, i want to select data where BSID-ZUONR field starts with '137'. can anyone tell me how can i select like that in my select query?

here is my select query

SELECT KUNNR ZUONR BUDAT UMSKZ GJAHR XBLNR BELNR BLART DMBTR SHKZG

FROM BSID INTO TABLE IT_BSID_ONE

WHERE BUKRS IN S_BUKRS

AND UMSKZ IN ('' , 'A')

AND BUDAT =< P_BUDAT.

Thanks.

sjeevan — Tue, 20 Sep 2011 03:48:06 GMT

AND ZUONR like '137%'

Former Member — Tue, 20 Sep 2011 03:54:11 GMT

Thanks alot man

Former Member — Tue, 20 Sep 2011 04:22:51 GMT

HI,

Make sure you use the primary keys / indexes carefully as this is a very large table.

Danish.