topic Re: Selection optin range issue in Application Development and Automation Discussions

Selection optin range issue

tarangini_katta — Thu, 26 Feb 2009 10:09:15 GMT

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

Re: Selection optin range issue

Former Member — Thu, 26 Feb 2009 10:11:38 GMT

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

Re: Selection optin range issue

Former Member — Thu, 26 Feb 2009 10:15:19 GMT

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.

Re: Selection optin range issue

Former Member — Thu, 26 Feb 2009 10:15:48 GMT

can you paste your SELECT statement.

Re: Selection optin range issue

tarangini_katta — Thu, 26 Feb 2009 10:20:41 GMT

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,

Re: Selection optin range issue

Former Member — Thu, 26 Feb 2009 10:32:26 GMT

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

Check S_MWSKZ -option = 'BT'.

Re: Selection optin range issue

Former Member — Thu, 26 Feb 2009 10:34:43 GMT

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

explain clearly

Re: Selection optin range issue

tarangini_katta — Thu, 26 Feb 2009 10:35:59 GMT

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,

Re: Selection optin range issue

tarangini_katta — Thu, 26 Feb 2009 10:37:18 GMT

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,

Re: Selection optin range issue

tarangini_katta — Thu, 26 Feb 2009 10:47:23 GMT

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

Re: Selection optin range issue

Former Member — Thu, 26 Feb 2009 10:54:45 GMT

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

Re: Selection optin range issue

tarangini_katta — Thu, 26 Feb 2009 11:27:14 GMT

Hi,

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

Thanks,

Re: Selection optin range issue

naveen_inuganti2 — Thu, 26 Feb 2009 11:36:11 GMT

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

Re: Selection optin range issue

tarangini_katta — Thu, 26 Feb 2009 11:45:19 GMT

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

Re: Selection optin range issue

naveen_inuganti2 — Thu, 26 Feb 2009 11:59:14 GMT

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.

Re: Selection optin range issue

Former Member — Thu, 26 Feb 2009 12:04:19 GMT

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.

Re: Selection optin range issue

Former Member — Thu, 26 Feb 2009 12:42:00 GMT

Hi Tarangini,

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

Re: Selection optin range issue

Former Member — Thu, 26 Feb 2009 12:47:39 GMT

Naveen Inuganti is correct..

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

thanks

jowar