ABAP Plug in: Building SQL Query

[nsm]

All,

I am using ABAP Plug in to download the data from SAP based on a selction criteria.

In my selection criteria what i have to do is compare part of the field and get the rest of the data, can somebody let me know how to do that?

ex:

Select Kna1-CusName where Left(kna1-CusNo,10)="9999999999"

Thanks
nsm.

[pnchowdary]

As far as I know ABAP plugin supports only basic conditions like IN, LIKE, BETWEEN etc. I dont think Build Sql Query option has features like substring or left etc.

You need to manually edit the ABAP program generated by the plugin to include any extra logic required by you.

[Sainath.Srinivasan]

Try
LIKE '9999999999%'

[PilotBaha]

I 'd recommend highly against changing the ABAP query. Some time, or two consultants down the road that will get lost completely. On the other hand LIKE works just fine..