SELECT-OPTIONS FOR LAGP-LGPLA and wildcard character

[Former Member]

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 ?

[Former Member]

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.

[Former Member]

Hello,

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

Regards

Varma

[jayanthi_jayaraman]

Hi,

You need to give single values as

7D*

7E*

7F*

7G*

[Former Member]

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

[SuhaSaha]

Hello Rob,

But i was wondering why would SAP behave this way? I did not find any reason for this.

Do you have any logical reason why this is happening ?

BR,

Suhas

[Former Member]

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

[Former Member]

Thanks all.

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