topic Re: Select Sql with Begin with value in Application Development and Automation Discussions

Select Sql with Begin with value

Former Member — Tue, 12 May 2009 09:05:30 GMT

Dear Friends

this is my small select statement for search healp


 SELECT DISTINCT VBELN
    FROM  LIKP
    INTO  TABLE IT_VBELN.

but i want to select only begins with 80 values

i tried with as follows


 SELECT DISTINCT VBELN
    FROM  LIKP
    INTO  TABLE IT_VBELN
    WHERE VBELN LIKE '80%'.

but its not working

let me please solve to this matter

Thanks in advanced

Hope my question is clear for you

Re: Select Sql with Begin with value

ThomasZloch — Tue, 12 May 2009 09:07:05 GMT

What is not working? Syntax error? Not returning the expected values?

You don't need DISTINCT, as VBELN is the unique key of LIKP, try to remove this first.

Thomas

Re: Select Sql with Begin with value

Former Member — Tue, 12 May 2009 09:11:38 GMT

Hi:

use like

SELECT VBELN

FROM LIKP

INTO corresponding fields of TABLE IT_VBELN

WHERE VBELN LIKE '80%'.

have a look

[Using Like |http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3a1f358411d1829f0000e829fbfe/content.htm]

Re: Select Sql with Begin with value

JozsefSzikszai — Tue, 12 May 2009 09:11:48 GMT

I guess it does not work because of the conversion exit on VBELN. Pls. check if the values in VBELN are shorter than 10 characters. If yes, it means there are leading zeros before the '80'

Re: Select Sql with Begin with value

ThomasZloch — Tue, 12 May 2009 09:13:39 GMT

<off-topic>Hi Eric, good to see you back around here ;)</off-topic>

Re: Select Sql with Begin with value

JozsefSzikszai — Tue, 12 May 2009 09:16:16 GMT

just jumped in but let me finish:

If the above is correct than you can try the following: if the VBELN numbers are always n character long, than there will be 10 - n zeros before the 80 (for example: 8 long VBELN will look like: 0080...). in this case you can use;

SELECT vbeln
FROM likp
WHERE vbeln LIKE '0080%'.

if the the VBELN numbers can have different lengths, than you have to mention each possibilitiy in the WHERE:

SELECT vbeln
FROM likp
WHERE vbeln LIKE '0080%'
OR vbeln LIKE '00080%'
OR vbeln LIKE '000080%'.

Re: Select Sql with Begin with value

Former Member — Tue, 12 May 2009 09:56:30 GMT

Hi Eric

Thanks I got solution