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

Select query issue

Former Member — Thu, 29 Jan 2009 05:44:29 GMT

Hi,

i am having some trouble with select query.

lets say for example i have to select some customers for a given country, and the customer is entered using SELECT-OPTIONS . i have written this query -

SELECT *

FROM zmmknits

INTO TABLE it_final

WHERE vendor_name IN vndrname

AND country_v IN cntry

AND ( approved_cust1 IN cust OR

approved_cust2 IN cust OR

approved_cust3 IN cust OR

approved_cust4 IN cust OR

approved_cust5 IN cust OR

approved_cust6 IN cust OR

approved_cust7 IN cust OR

approved_cust8 IN cust OR

approved_cust9 IN cust OR

approved_cust10 IN cust ).

the problem i am facing is that say for example the customer entered is GEORGE and for the given country the customer is George Patro or George Wells, so according to my query its not pulling up these records which it should pull for my report.

kindly help

Re: Select query issue

Former Member — Thu, 29 Jan 2009 06:01:46 GMT

<<Copy and paste from SAP Help deleted and awarded points removed>>

Edited by: Matt on Jan 29, 2009 9:27 AM

Re: Select query issue

Former Member — Thu, 29 Jan 2009 06:02:31 GMT

This message was moderated.

Re: Select query issue

Former Member — Thu, 29 Jan 2009 06:12:44 GMT

thank you very much for your reply... however we should note that LIKE or NOT LIKE works with parameters... and my data is entered through SELECT-OPTIONS

Re: Select query issue

Former Member — Thu, 29 Jan 2009 06:15:05 GMT

SELECT-OPTIONs offer you to enter pattern like

*GEORGE*

on the screen field, and they work like LIKE clause with %GEORGE%

Re: Select query issue

Former Member — Thu, 29 Jan 2009 06:24:07 GMT

thanks again to you... but can you just elaborate your answer a little bit as to how can i make SELECT-OPTIONS enter the data as GEORGE