Select Single

[Former Member]

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!!!

[Former Member]

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

[Chandra-Bade]

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.

[Former Member]

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

[Former Member]

Hi sahil,

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

-Goodluck,

Bhumika

[Former Member]

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

[asik_shameem]

Hi

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.

[Former Member]

SELECT SINGLE FIELDNAME FROM TABLENAME INTO VARIABLE where Fieldname = conditions

[Former Member]

Hi Experts,

Thanks a lot for your support.

Its Resolved.....

Best Regards,

Sahil

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