topic Re: record between to values in Application Development and Automation Discussions

record between to values

former_member630092 — Sat, 29 Aug 2009 07:19:08 GMT

in my report i have selectio-screen fiels s_lifnr.

I want to display only records betweeb two values.

ex. it should disply records between 100 and 300 including both limits.

here 100 and 300 are not fixed.may vary

but it is displaying all records.(i.e. starting from 100 upto 900 )

i wrote like this.

Initialization.

clear So_lifnr.

so_lifnr-SIGN = 'I'.

so_lifnr-OPTION = 'BT'.

APPEND so_lifnr.

thanks

Re: record between to values

Former Member — Sat, 29 Aug 2009 07:26:22 GMT

Hello Ravi,

can u tell me wat exact code you have written...

your code should be like...

so_lifnr-high = '0000000100'

so_lifnr-low = '0000000300'

so_lifnr-SIGN = 'I'.

so_lifnr-OPTION = 'BT'.

append so_lifnr.

it will surely work

Note: if you are using select option thn no need for this code.. it is only required if u are using range and not select option.

Re: record between to values

Former Member — Sat, 29 Aug 2009 07:30:34 GMT

nothing to change in code.

no initialization needed.

select option by default comes with BT facility.

why do you need a code for this?

its just

select-options s_lifnr for abcd-lifnr.

Re: record between to values

Former Member — Sat, 29 Aug 2009 08:24:39 GMT

Ravi,

If u r using select-options by default it will fetch all the values between low and high value no need to initiliaze this.,.,.,

If u r going for ranges it may be useful..

Thanks and REgards,

Thirukumaran. R

Re: record between to values

Former Member — Sat, 29 Aug 2009 09:22:33 GMT

Hi Ravi ,

You need not to do anything with select option.

Provide selection screen validation on the field and restrict the entries between 100 and 300.Display an error message if a user enters some other value.

Also, you an set default value if required.

Hope it helps you.

Re: record between to values

former_member203501 — Sat, 29 Aug 2009 10:46:51 GMT

Hi,

As per my understanding you need a select-option with the defaults between two intervals. you need to get the values in the f4 function with the limits entered on the selection. if so write the coding for at selection-screen on field s_lifnr.

Regards,

Venkat.

Re: record between to values

former_member630092 — Mon, 31 Aug 2009 06:09:45 GMT

Answered