topic Re: Getting a string from a table using a SELECT statement in Application Development and Automation Discussions

Getting a string from a table using a SELECT statement

Former Member — Tue, 24 Sep 2013 14:19:49 GMT

Hi experts,

I am using this line of code when choosing from table LTDXT.

SELECT variant

FROM ltdxt

INTO CORRESPONDING FIELDS OF TABLE ts_variant

WHERE report EQ sy-repid

AND ( username EQ space

OR username EQ sy-uname )

AND ( variant LIKE '%_A%'

OR variant LIKE '%A_%' ).

What I want to appear inside the table should be variants that either contain "_A" or "A_" on the name. But when I check the table, even the variant name ABTEST is appearing on the table even if it does not contain A_ or _A.

Am I missing something? Thank you!

Re: Getting a string from a table using a SELECT statement

PeterJonker — Tue, 24 Sep 2013 14:39:37 GMT

it is expected. abap help on like:

"%" represents any character string, even an empty one, and "_" represents any character

if I read further in the ABAP help it says on wildcards:

Character that substitutes other content. In logical expressions with the
operators CP und NP, "*" usually stands for any character
string and "+" for any
individual character. In WHERE-conditions of Open SQL with the operator LIKE "%" stands for any character strings and "+" for individual characters. The special
functions of wildcard characters can be canceled using escape symbols

Re: Getting a string from a table using a SELECT statement

Former Member — Tue, 24 Sep 2013 14:43:14 GMT

In this case, underscore is interpreted as a meaning any single character. If you use an in instead of a like, you can test for underscore.

Neal

Re: Getting a string from a table using a SELECT statement

Former Member — Tue, 24 Sep 2013 14:51:12 GMT

As said problem with '_' and %.

So do one thing..

SELECT variant FROM ltdxt INTO CORRESPONDING FIELDS OF TABLE ts_variant

WHERE report EQ sy-repid AND

( username EQ space OR username EQ sy-uname ).

Now

loop at ts_variant into ls_variant where variant CS '_A' OR variant CS 'A_' .

append ls_variant into ts_var_copy.

endloop.

ChanS.

Re: Getting a string from a table using a SELECT statement

Former Member — Tue, 24 Sep 2013 14:57:11 GMT

Peter is correct. In your case, you can add escape characters as follows and your statement will perform correctly:

SELECT variant

FROM ltdxt

INTO CORRESPONDING FIELDS OF TABLE ts_variant

WHERE report EQ sy-repid

AND ( username EQ space

OR username EQ sy-uname )

AND ( variant LIKE '%\_A%' ESCAPE '\'

OR variant LIKE '%A\_%' ESCAPE '\' ).

Re: Getting a string from a table using a SELECT statement

Former Member — Tue, 24 Sep 2013 15:04:26 GMT

Hey I also tried for the same, Its working fine

Great Piece of code.. Thanks for Sharing ..

Re: Getting a string from a table using a SELECT statement

Former Member — Wed, 25 Sep 2013 05:02:05 GMT

Hii Dioso,

Either follow the post of

Eric Peterson

or u can do in another way.

select variant and store it into ts_variant then

filter this internal table according to ur requirement and store it into another internal table.

like,

SELECT variant

FROM ltdxt

INTO CORRESPONDING FIELDS OF TABLE ts_variant

WHERE report EQ sy-repid

AND ( username EQ space

OR username EQ sy-uname ).

if not ts_variant is initial.

loop at ts_variant into wa_variant where variant CO 'A_' or variant CO '_A'.

move wa_variant to wa_variant_final.

append wa_variant_final to ts_variant_final.

clear wa_variant_final.

endloop.

endif.

regards

Syed

Re: Getting a string from a table using a SELECT statement

Former Member — Wed, 25 Sep 2013 05:20:17 GMT

Yes, '%' and '_' have other meanings in ABAP. So in order to use them in our select query, we need to provide escape expression as rightly explained by Peter and Eric.

Check these links.

http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/content.htm

http://help.sap.com/abapdocu_702/en/abenwhere_logexp_like.htm