topic Re: Select-options in Application Development and Automation Discussions

Select-options

Former Member — Wed, 30 Apr 2008 04:34:15 GMT

Hi All,

I have to create a report where I have to use SELECT-OPTIONS for vendor number. If user does not enter the vendor number (vendor-low and vendor-high are blanks) then I have to select records for all vendors. If user enters a range or individual vendor numbers and I have to select only the entered vendor numbers. How I can do this?

Re: Select-options

Former Member — Wed, 30 Apr 2008 04:35:01 GMT

just use select-options : s_lifnr for lfa1-lifnr.

and in your selection query, use

where

lifnr in S_lifnr.

the system will automatically take care of the rest. ..that means, the system will pick only those vendors, if something is specified in s_lifnr, else, it will pick for all vendors..

SAP is intelligent, right ??

Re: Select-options

Former Member — Wed, 30 Apr 2008 04:38:03 GMT

hi,

do this way ..

select * from lfa1 into table it_lfa1 where lifnr in s_lifnr.

Regards,

Santosh

Re: Select-options

Former Member — Wed, 30 Apr 2008 04:40:14 GMT

Hi,

Just try this.


    select *
    into table <internal table>
    from <DB table>
     where lfa1 in s_vendor.

regards

raam

Re: Select-options

Former Member — Wed, 30 Apr 2008 05:41:29 GMT

Hi,

Use like this,

Select-options : vendor for lfa1-lifnr.

data : itab like lfa1 occurs 0 with header line.

in select Query,

Select * from lfa1 into itab where lifnr in vendor.