topic Re: Select Single in Application Development and Automation Discussions

Select Single

Former Member — Mon, 20 Oct 2008 04:58:24 GMT

Hi Experts,

I have to make a select single into an internal table.

Please suggest how to do it and tell the syntax

Thanks in advance!!!

Re: Select Single

Former Member — Mon, 20 Oct 2008 05:02:44 GMT

Select single <fieldname> from < tablename> into <a_variable> where <condition>.

http://www.sapdb.org/7.4/htmhelp/40/1311fd2fa511d3a98100a0c9449261/content.htm

Rgards,

Midhun Abraham

Edited by: Midhun Abraham on Oct 20, 2008 7:04 AM

Re: Select Single

Chandra-Bade — Mon, 20 Oct 2008 05:34:14 GMT

Hi ,

You cannot use internal table in select single.Insted use work area because select single at a time gets/fetches 1 record.

Syntax for using work area.....

REPORT zsample.

TYPES : BEGIN OF ty_vbak,

vbeln TYPE vbeln_va,

erdat TYPE erdat,

END OF ty_vbak.

DATA : it_vbak TYPE TABLE OF ty_vbak,

wa_vbak LIKE LINE OF it_vbak.

SELECT-OPTIONS : s_vbeln FOR wa_vbak-vbeln.

SELECT SINGLE vbeln erdat FROM vbak

INTO it_vbak

WHERE vbeln IN s_vbeln.

write:/ 'ssssss'.

Hope this helps you.

Re: Select Single

Former Member — Mon, 20 Oct 2008 05:39:08 GMT

Hi Midhuin,,

I need to implement Select single instead of the following Select *....

SELECT * INTO TABLE< itab> FROM <DB Table> WHERE key= <> AND

key = <>

Please Help.

Thanks and Regards,

Sahil

Re: Select Single

Former Member — Mon, 20 Oct 2008 05:48:02 GMT

Hi sahil,

To know the syntax of any command use the F1 help in abap editor..

-Goodluck,

Bhumika

Re: Select Single

Former Member — Mon, 20 Oct 2008 06:06:06 GMT

Hi Sahil,

For using select single, try this :

DATA: l_v_mtart TYPE mtart.

SELECT SINGLE mtart

FROM t134

INTO l_v_mtart

WHERE mtart IN s_mtart.

Hope it helped you.

Regrads,,

NIkita

Re: Select Single

asik_shameem — Mon, 20 Oct 2008 06:23:11 GMT

Use Addition UP TO 1 ROWS in SELECT.


DATA: itab TYPE TABLE OF mara.

SELECT MATNR FROM mara INTO TABLE itab UP TO 1 ROWS.

Re: Select Single

Former Member — Mon, 20 Oct 2008 06:35:13 GMT

SELECT SINGLE FIELDNAME FROM TABLENAME INTO VARIABLE where Fieldname = conditions

Re: Select Single

Former Member — Mon, 20 Oct 2008 06:36:55 GMT

Hi Experts,

Thanks a lot for your support.

Its Resolved.....

Best Regards,

Sahil

Edited by: Sahil Mehta on Oct 20, 2008 8:37 AM