Selection optin range issue

[tarangini_katta]

Hi All,

I have a strange issue in selecting the data from bseg table.

I am retriving the data from table BSEG based tax code i.e. BSEG-MWSKZ.

I will have my tax codes like this.

3A 4A 5A upto 9A

1B 2B 3B upto 9B

1C 2C 3C upto 9C

1D 2D 3D upto 9D

1E 2E 3E upto 9E

1F 2F 3F upto 9F

1G 2G 3G upto 9G

1H 2H 3H upto 5H

I am giving all this values in my select-options of Range Values

when i retriving the data from BSRG i am geeting the records of MWSKZ with '7Z' but this value is not in the range which i specified.

The strange sitution if i selecting from table also i am geeting the same problem.

Can anybody please help me on thsi isuue

Thanks

Thanks

[Former Member]

Hi

Could you send the code of the ranges you have declared ?

[Former Member]

please post the code for selection range initialization what u have given and the select statement.. that will help knowing the problem.

in between:

just put a break point on your select statement and check what value is on your selection range.

[Former Member]

Hi

can you paste your SELECT statement.

[tarangini_katta]

Hi,

this is my select statement

select BELNR LIFNR BUKRS WRBTR HKONT SGTXT BUZEI KOART BUZID MWSKZ

from BSEG INTO TABLE IT_BSEG

for all entries in IT_BKPF

WHERE

MWSKZ IN S_MWSKZ .

Thanks,

[Former Member]

Hi

So r u filling S_MWSKZ manually or its comming from other table?

Check S_MWSKZ -option = 'BT'.

[Former Member]

What is the values ur passing to s_mwskz and where the 7z is gettg populated .

explain clearly

[tarangini_katta]

Hi kaushik,

I have declared the

S_mwskz type bseg-Mwskz.

After executing the report i am giving the values in selection screen.

I am not appending anything in the program.

I am geeting the wrong output.

Thanks,

[tarangini_katta]

Hi matrina,

I have given tax codes which i am giving in selection screen in the first post with in that range i dont have value of 7Z i am geeting the output of 7z alos.

Thanks,

[tarangini_katta]

Hi ,

when i check my S_MWSKZ in debug the values are following.

SIGN OPTION LOW HIGH

I |BT |3A |9A

I |BT |1B |9B

I |BT |1C |9C

I |BT |1D |9D

I |BT |1E |9E

I |BT |1F |9F

I |BT |1G |9G

I |BT |1H |5H

With in this range i dont have value '7Z' for mwskz.

But i am getting the 7Z as output.

Thanks

[Former Member]

Hi

Are you getting the same problem when selecting from the table independently ?

[tarangini_katta]

Hi,

I am getting the same problem when i am selecting from table also in SE11.

Thanks,

[naveen_inuganti2]

Are you sure about Number ranges...

Is it 1A 1B 1C.....?

Or 1A 2A 3A....?

What I meant is 7Z may be in your selection range!

--Naveen.I

[tarangini_katta]

Hi,

I have already specified my number ranges in my question first.

Number ranges of select options.

3A 4A 5A 6A 7A 8A 9A.

1B 2B 3B 4B 5B 6B 7B 8B 9B

1C 2C 3C 4C 5C 6C 7C 8C 9C

1D 2D 3D 4D 5D 6D 7D 8D 9D

1E 2E 3E 4E 5E 6E 7E 8E 9E

1F 2F 3F 4F 5F 6F 7F 8F 9F

1G 2G 3G 4G 5G 6G 7G 8G 9G

1H 2H 3H 4H 5H

Thanks

[naveen_inuganti2]

Ok,

Its clear right.

How can 8 sequence displays before 7Z?

If you selects

sign = i,

Option = BT,

Low = 3A,

High = 9A...

It picks..

3A, 3B, 3C.......3Z &

4A,4B,4C.......4Z...

....................

7A.......7Y,7Z...

...........8Z,9A

As debugger says...

I |BT |3A |9A <---having 7Z

I |BT |1B |9B <---having 7Z

I |BT |1C |9C <---having 7Z

I |BT |1D |9D <---having 7Z

I |BT |1E |9E <---having 7Z

I |BT |1F |9F <---having 7Z

I |BT |1G |9G <---having 7Z

I |BT |1H |5H <---Not having 7Z

To avoid this you need to pass the sign I Option EQ and Low as your req'contents.

--Naveen Inuganti.

[Former Member]

Hi Tarangini,

why don't u make use of select-options it self and make it to no-display.

then in PAI i.e at selection screen.

so_sel-low = '1A'.

so_sel-high= '7A'.

so_sel-sign = 'I'.

so-sel-option = 'EQ'.

append so_sel.

and use this in select stmt.

select * from ____ into ____ where name in so_sel.

i also have some issue like this . i solved it like this.

[Former Member]

Hi Tarangini,

Hope you got ur problem solved so plz close the post,

[Former Member]

Naveen Inuganti is correct..

check the other stuff also . it will also be there into ur internal table .

thanks

jowar