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

issue with Select query

Former Member — Sat, 23 Dec 2017 19:34:05 GMT

Hi in the below query i need the match 'ableinh ' with one select option parameter..

in select option field iam passing '01' or '02' or '03' or etc..

the value of 'ableinh' is '0112' or '01345' or '0287' or '03455' or etc.

i know LIKE work for single value , here i need to fetch multiple records..

SELECT anlage bis tariftyp ableinh FROM eanlh
INTO TABLE lt_eanlh WHERE anlage IN s_instl
AND bis = '99991231'
AND tariftyp IN s_ortyp
AND ableinh = .

please help me.

Thanks

Re: issue with Select query

Former Member — Sat, 23 Dec 2017 23:25:24 GMT

Hi NK Reddy, Are you not getting the output if you write the query like below...?

SELECT anlage bis tariftyp ableinh FROM eanlh
INTO TABLE lt_eanlh WHERE anlage IN s_instl
AND bis = '99991231'
AND tariftyp IN s_ortyp
AND ( ableinh = c_0112 OR ableinh = c_01345 OR ableinh = c_0287 OR ableinh = c_03455 ).

Re: issue with Select query

Former Member — Sun, 24 Dec 2017 01:57:18 GMT

the field values are dynamically populated on selection screen , they are not fixed, so in runtime my query should compare first 2 characters of ableinh with SELECT-OPTION field value.

Thanks

Re: issue with Select query

Former Member — Sun, 24 Dec 2017 16:47:37 GMT

Hi NK Reddy,

Please write the select query as below and enter the select option field value on selection screen as 01* , 02*, 03*

(for the field 's_able'). It should work.

SELECT anlage bis tariftyp ableinh FROM eanlh
INTO TABLE lt_eanlh WHERE anlage IN s_instl
AND bis = '99991231'
AND tariftyp IN s_ortyp
AND ableinh IN s_able.

Re: issue with Select query

Former Member — Mon, 25 Dec 2017 00:11:49 GMT

I coded as below ,i but see different issue , on selection field iam passing range '01' to '03' , but it always fetching the records start with 01 , its considering the range ..even tried on on table SE11/SE16 , if you give range 01* to 03* , it only get the records start with '01'.

any idea.. cant really get range of values using pattern?

ls_data-option = 'BT'.
ls_data-sign = 'I'.
if not s_portn-low IS INITIAL.
CONCATENATE s_portn-low '%' INTO ls_data-low .
endif.
if not s_portn-high IS INITIAL.
CONCATENATE s_portn-high '%' INTO ls_data-high .
endif.
APPEND ls_data TO lt_data.

SELECT anlage bis tariftyp ableinh FROM eanlh
INTO TABLE lt_eanlh WHERE anlage IN s_instl
AND bis = '99991231'
AND tariftyp IN s_ortyp
AND ableinh IN lt_data .

Re: issue with Select query

former_member215439 — Wed, 27 Dec 2017 02:08:49 GMT

Hi,

Goodday!

Have you solved this concern?

As per checking my code above did not work but I suggest you to try this work around.

SELECT anlage bis tariftyp ableinh FROM eanlh
INTO TABLE lt_eanlh WHERE anlage IN s_instl
AND bis = '99991231'
AND tariftyp IN s_ortyp.

DELETE lt_eanlh WHERE ableinh(2) NOT IN s_ableinh.

If this concern already solved, please close this thread.

Re: issue with Select query

Jelena_Perfiljeva — Fri, 29 Dec 2017 22:40:36 GMT

Please don't use Answers to post additional information, use Comments instead.

Regarding the question - post the screenshots of the actual values you see in SE16. I don't see any conversion exits in this field in our system so I'm not sure what could be the problem. But with numeric values in CHAR 8 field it is most likely "owls are not what they seem".

P.S. Not sure why you're adding "%" in this code. Use selection variable as is, from the selection screen. No need to make it more complicated.

P.P.S. Just for the giggles why not try *03* pattern and see what happens.

Re: issue with Select query

Sandra_Rossi — Sat, 30 Dec 2017 00:09:15 GMT

If you want any value which starts with 01 or any value which starts with 02 or any value which starts with 03, then initialize your range table with those 3 entries:

SIGN  OPTION  LOW
I     CP      01*
I     CP      02*
I     CP      03*

EDIT: solution corrected as per Horst remark (thanks!)

Re: issue with Select query

matt — Sat, 30 Dec 2017 10:43:08 GMT

Converted to comment

Re: issue with Select query

retired_member — Sat, 30 Dec 2017 11:19:53 GMT

I'd say the OPTION must be CP instead of EQ and LOW must be '01*', ...

Re: issue with Select query

Sandra_Rossi — Sat, 30 Dec 2017 16:10:30 GMT

Thanks Horst 🙂

Re: issue with Select query

Former Member — Sat, 30 Dec 2017 23:08:29 GMT

solved my self.

thank you

Re: issue with Select query

iftah_peretz — Sun, 31 Dec 2017 11:04:39 GMT

Hi NK,

A lot of people took time and effort in order to help you reach the solution.

I would like to refer you to the rules of engagement section 5:

"5. Share expertise transparently. We are a community based site that encourages public knowledge sharing. Be open about your knowledge and how you obtained it."

Taking that into account, please share your solution and mark helpful/correct answers.

Iftah

SAP Community Moderator

Re: issue with Select query

Jelena_Perfiljeva — Tue, 02 Jan 2018 19:07:42 GMT

Hm, this seems to be very peculiar. I don't have the same exact data as OP but tested with T001 table. It looks like if the range is entered using from/to select options (which translates into BT option with LOW/HIGH) then the "to" part is not included in the result.

If I enter 002*, 003*, and 004* as 3 separate items then it correctly finds all items that start with those numbers. But if I enter selection criteria from 002* to 004* then it only includes 002* and 003*. If I change it as up to 005* then 004* shows up.

This is very odd because if I just specify the exact values, e.g. 0020 to 0049 then 0049 is included in the result set. What the deuce? Is there any reasonable explanation? No wonder OP got confused...

Re: issue with Select query

Former Member — Tue, 02 Jan 2018 21:02:16 GMT

When using BT the LOW and HIGH are not seen as patterns but just single entries. Since '*' comes before '0' in the ASCII table it will not select any 004 entries when you use HIGH as 004*.

Re: issue with Select query

Sandra_Rossi — Tue, 02 Jan 2018 22:44:33 GMT

+1 to Gerrit

Re: issue with Select query

Jelena_Perfiljeva — Wed, 03 Jan 2018 16:45:44 GMT

Thanks for a reply! So essentially there is no "BP" option, like BT one but for the pattern. Weird...

Re: issue with Select query

Former Member — Mon, 08 Jan 2018 18:13:24 GMT

The above issue resolved with different approach . I find the field

ableinh in another table te422 , so now I used inner join on tables

eanlh and te422 .

Thanks all for your inputs.

Re: issue with Select query

retired_member — Mon, 08 Jan 2018 18:30:53 GMT

Hmm, all this is neatly documented ...

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenlogexp_select_option.htm

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenlogexp_between.htm

Re: issue with Select query

Jelena_Perfiljeva — Mon, 08 Jan 2018 21:02:38 GMT

"The relational operator matches the content of the column seltab-option
and the content of the columns seltab-low and seltab-high is concatenated as the right operand."

I might be slow today but I'm honestly having trouble translating this into "CP with 001*-004* will not find 004* pattern". 🙂 Specific examples could be helpful.

Thank you!