Skip to Content
author's profile photo Former Member
Former Member

SELECT-OPTIONS FOR LAGP-LGPLA and wildcard character

My code is

SELECT-OPTION S_BINS FOR LAGP-LGPLA.

I have 4 bins in LAGP .

I input 7D* to 7F* on the selection screen. The query fetches the 1st two bins of the following, but not 7F13C01 .

7D01E02

7E12D01

7F13C01

7G14D02

I tried 7D* to 7G* and this time I got all the bins but not the bin 7G14D02.

The problem seems to be that S_BINS-HIGH value is being excluded. All values upto and excluding S_BINS-HIGH are being retrieved.

Any answers ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 01:15 PM

    Hello,

    Check the type of startegy implemented for the storage bins with your functional consultant.

    Regards

    Varma

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 09, 2009 at 01:27 PM

    Hi,

    You need to give single values as

    7D*

    7E*

    7F*

    7G*

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 01:28 PM

    It doesn't make sense to use CP with ranges. Enter each wildcard selection individually (7D, 7E , 7F* and 7G*).

    Rob

    Edited by: Rob Burbank on Sep 9, 2009 9:29 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Suhas Saha

      All programming languages allow you to do things that don't really make sense. It gives the language flexibility. It's up to the programmer to understand the language and how to use it.

      It's why were so highly paid 😉

      rob

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 08:09 AM

    Set a break-point at the query. And the check the sign is 'I' if not then check for any initialization done previously.

    I think this can be done by using a parameter, because if you are using a select-option then what is usage of wild character search. select-option will work for a range seletion. so I think parameter is a batter option.

    And still if you want to use it and if the present querry is not working then yiou can use RANGES to get all the values.

    RANGES: R_TST FOR LAGP-LGPLA.

    READ TABLE <YOUR SELECT-OPTION> INDEX 1 .

    CHECK SY-SUBRC EQ 0 .

    R_TST-SIGN = 'I' .

    R_TST-SOPTION = 'BT' .

    R_TST-LOW = '<YOUR SELECT-OPTION>-LOW' .

    R_TST-HIGH = '<YOUR SELECT-OPTION>-HIGH' .

    APPEND R_TST.

    you can use this ranges in the querry.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 01:58 PM

    Thanks all.

    The business person agreed to go with 7D, 7E , 7F* on separate lines and it works fine as expected.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.