topic Re: Abap ...select-option in Application Development and Automation Discussions

Abap ...select-option

Former Member — Fri, 21 Dec 2007 16:19:37 GMT

Hi,

Any one please help to ??

I Want to Know how we can fetch the

LOW_VAl and HIGH_VAL

SELECT-OPTION

I want to use those values for comparsion in SELECT statement.

Thanks

Re: Abap ...select-option

former_member156446 — Fri, 21 Dec 2007 16:21:42 GMT

select-option : so_vbeln for vbak-vbeln

use only low value.

select * from vbak

into itab

where vbeln eq so_vbeln-low.

use only high value

select * from vbak

into itab

where vbeln eq so_vbeln-high.

use the whole range.

select * from vbak

into itab

where vbeln in so_vbeln.

award points if useful

Re: Abap ...select-option

former_member194669 — Fri, 21 Dec 2007 16:24:28 GMT



report  zars no standard page heading
        line-size 170
        line-count 65(4).

data : xvbeln    type line of tt_vbeln.

select-options : vbeln for xvbeln.

start-of-selection.
break-point.
loop at vbeln.
  write : / vbeln-low.
  write : / vbeln-high.
endloop.

a®

Re: Abap ...select-option

Former Member — Fri, 21 Dec 2007 16:24:32 GMT

You can use the Select option directly in Select query to fetch data.

Select * from <TABLE> into ITAB where <field> IN <Select-Option>.

Example:

TABLES: pa0001.

data: it_pa0001 type standard table of PA0001.

SELECT-OPTIONS: s_pernr FOR pa0001-pernr.

Select * from PA0001 into table lt_pa0001 where

pernr IN s_pernr.

This select query will retrieve all the employees from PA0001 based on the select option values.

Lokesh

Re: Abap ...select-option

RoySayak — Fri, 21 Dec 2007 16:28:44 GMT

use the function mdule DYNP_VALUES_READ to read the values from screen.

i think u wanted to know it.

Thanks

Sayak

Re: Abap ...select-option

Former Member — Sat, 22 Dec 2007 13:40:24 GMT

Hi,

http://help.sap.com/saphelp_nw04/helpdata/en/9f/dbaac935c111d1829f0000e829fbfe/content.htm

The above link has important information on DYNP_VALUES_READ that would be of good help to ya.

Regards,

Satish.....

Re: Abap ...select-option

Former Member — Sat, 22 Dec 2007 14:54:54 GMT

Hi,

loop at so_vbeln.

write : so_vbeln-low, so_vbeln-high

endloop.

If you want to use in select statement as where field in so_vbeln- low for low value or for high so_vbeln-high.

Thanks,

Sriram Ponna.

Re: Abap ...select-option

former_member156446 — Sat, 22 Dec 2007 14:57:12 GMT

what is Chakradhar looking for still..?

if answered, award points and close thread.

else ask for what more needed.