01-07-2008 5:26 AM
hi all,
I am new to ABAP give me one example for
select options and give me meterial for this. I tried
for this but it get systax error in the please give me
suggation.
Thanks in advance.
01-07-2008 5:51 AM
Hi,
See this example code,
tables spfli.
select-oiptions : s_carrid for spfli-carrid.
data t_spfli type table of spfli with header line.
select * from spfli into table t_spfli where carrid in s_carrid.
See this link.
http://help.sap.com/saphelp_nw04/helpdata/en/2b/d922384b8a11d1894c0000e8323c4f/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/39/cca1df576911d1896f0000e829fbbd/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/9f/dba78735c111d1829f0000e829fbfe/frameset.htm
Plzz Reward if it is useful,
Mahi.
01-07-2008 5:28 AM
tables : vbak.
select-options : so_vbeln for vbak-vbeln.
write this and jst press F8(execute).
Also use the F1 help
Regards
Gopi
01-07-2008 5:28 AM
01-07-2008 5:29 AM
Hi,
see this link
http://help.sap.com/saphelp_nw70/helpdata/en/9f/dba74635c111d1829f0000e829fbfe/content.htm
rgds,
bharat.
01-07-2008 5:35 AM
Hi.
SELECT-OPTIONS : so_vbeln FOR vbrk-vbeln.
SELECT * FROM vbrk INTO TABLE it_vbrk
WHERE vbeln = so_vbeln.
here, it vil take all records from vbrk table which matches ur vbeln condition, which vil be given by u in the sel scr....
Reward , if it helps
01-07-2008 5:39 AM
Hi,
Try this code
tables : mara.
data i_mara typr mara with header line occurs 0.
select-options : s_matnr for mara-matnr.
if s_matnr[] not initial.
select * from mara into table i_mara where matnr in s_matnr.
if sy-subrc = 0.
loop at i_mara.
write i_mara-matnr.
endloop.
endif.
endif.
Regards,
Pankaj
01-07-2008 5:49 AM
Hi
Select options will give u a option for defining a selelction range in the selection screen.
The example for select-options is
select-options: vbeln for vbak-vbeln.
if u use this query it will create a internal table like low high sign option.
the value which u are entering in the select option screen will get filled in the internal table which mentioned above.
In the selection query if u use a slect optoin in the where clause u have to use like this
Select *
from vbak
into itab_vbak
where vbeln in vbeln.
Thanks
arun
01-07-2008 5:51 AM
Hi,
See this example code,
tables spfli.
select-oiptions : s_carrid for spfli-carrid.
data t_spfli type table of spfli with header line.
select * from spfli into table t_spfli where carrid in s_carrid.
See this link.
http://help.sap.com/saphelp_nw04/helpdata/en/2b/d922384b8a11d1894c0000e8323c4f/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/39/cca1df576911d1896f0000e829fbbd/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/9f/dba78735c111d1829f0000e829fbfe/frameset.htm
Plzz Reward if it is useful,
Mahi.
01-07-2008 6:12 AM
Hi,
select-options is used for creating a selection screen for entering input
values as user wants to see the output.
here if you code as selecti-options : s_lifnr for lfa1-lifnr.
it will display input from range to to range.
means we can able to give input as lower limit to upper limit.
Regards,
swami