topic Re: defining range in Application Development and Automation Discussions

defining range

Former Member — Fri, 05 Jan 2007 15:32:14 GMT

Dear experts,

I need to display the range of vendor no in my report,

could anyone pls give me the code to define range and select vendor accordingly

thanks in advance

kar

Re: defining range

ferry_lianto — Fri, 05 Jan 2007 15:36:37 GMT

Hi,

Try this.


TABLES: LFA1.
SELECT-OPTIONS: S_LIFNR FOR LFA1-LIFNR.
                                                                        
SELECT LIFNR
INTO TABLE I_LFA1
FROM LFA1
WHERE LIFNR IN S_LIFNR.

Regards,

Ferry Lianto

Re: defining range

Former Member — Fri, 05 Jan 2007 15:36:38 GMT

data : begin of it_ranges occurs 0,
               sign(1),
               option(2),
               low like lfa1-lifnr,
               high like lfa1-lifnr,
          end of it_ranges.

select lifnr into table it_lifnr from lfa1 where lifnr in it_ranges.

Re: defining range

Former Member — Fri, 05 Jan 2007 15:42:49 GMT

You define ranges like this:

ranges: s_lifnr for lfa1-lifnr.

Thanks,

Santosh

Re: defining range

Former Member — Fri, 05 Jan 2007 15:45:33 GMT

Dear Chandrasekar

Can i declar like below

SELECT-OPTIONS: S_LIFNR FOR LFA1-LIFNR.

what is the difference with the above code and your code.

data : begin of it_ranges occurs 0,

sign(1),

option(2),

low like lfa1-lifnr,

high like lfa1-lifnr,

end of it_ranges.

select lifnr into table it_lifnr from lfa1 where lifnr in

it_ranges.

pls explain

Re: defining range

Former Member — Fri, 05 Jan 2007 15:49:55 GMT

with the first case  

SELECT-OPTIONS: S_LIFNR FOR LFA1-LIFNR

user has to give input 

In my case there is no need for user to give input , u can build your own LIFNRs like this

it_ranges-sign = 'I'.
it_ranges-option = 'BT'.
it_ranges-low = '00001234'.
it_ranges-high = '  '.
append it_ranges.
clear it_ranges.

it_ranges-sign = 'I'.
it_ranges-option = 'BT'.
it_ranges-low = '0005678'.
it_ranges-high = '  '.
append it_ranges.
clear it_ranges.

Re: defining range

ferry_lianto — Fri, 05 Jan 2007 15:50:45 GMT

Hi Karthik,

Yes, you can declare below code for your selection screen report to get range of vendor.

SELECT-OPTIONS: S_LIFNR FOR LFA1-LIFNR.

if you do not want to display in your selection screen then you can use RANGE statement.

No need to declare an internal table like above code.

RANGES: R_LIFNR FOR LFA1-LIFNR.

Hope this will help.

Regards,

Ferry Lianto