topic Re: Select SINGLE vs READ statements in Application Development and Automation Discussions

Select SINGLE vs READ statements

former_member577909 — Mon, 04 Dec 2006 05:25:56 GMT

how does the Select SINGLE statement works and How does the READ Statement works .. and please give the examples of each

Thankyou

Re: Select SINGLE vs READ statements

jayanthi_jayaraman — Mon, 04 Dec 2006 05:27:25 GMT

Hi,

Select single is used to fetch a single record from database table.Read is used to fetch a single record from internal table.

Re: Select SINGLE vs READ statements

Former Member — Mon, 04 Dec 2006 05:28:05 GMT

Hello Bhaskar,

SELECT SINGLE statement is used to read one record from a database table.

The READ statement is used to read a record from an internal table.

Regards,

Anand Mandalika.

Re: Select SINGLE vs READ statements

Former Member — Mon, 04 Dec 2006 05:29:41 GMT

For READ have a look at below link.

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb35f8358411d1829f0000e829fbfe/content.htm

SELECT SINGLE is a construct designed to read database records with primary key. SELECT SINGLE returns the first matching row for the given condition and it may not be unique, if there are more matching rows for the given condition.

SELECT SINGLE field

INTO w_field

FROM table.

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: Select SINGLE vs READ statements

anversha_s — Mon, 04 Dec 2006 05:30:32 GMT

hi,

This situation occurs mostly inside the loops.

suppose an internal table. ITAB.

1. Never use select statements inside loops.

2. always use READ.

eg:

<i>select single.</i>

ex code

***********
Report Z_Difference 
Message-id 38 
Line-Size 80 
Line-Count 0 
No Standard Page Heading. 
* 
Start-Of-Selection. 
 
Data: w_Single type Posnr, 

* 
Select single Posnr 
from zDifference 
into w_Single. 
* 
Select Posnr 
into table t_Rows 
from zDifference 
up to 1 rows 
order by Posnr descending. 
* 
Write :/ 'Select single:', w_Single.

Reading records with keys

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb35f8358411d1829f0000e829fbfe/content.htm

Reading lines with Index

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3730358411d1829f0000e829fbfe/content.htm

rgds

Anver

Re: Select SINGLE vs READ statements

former_member69765 — Mon, 04 Dec 2006 05:31:21 GMT

Select single starts searching from the row 1 and picks the 1st record that matches ur selection criteria.

e.g . Select single * from bkpf where bukrs = '0001'.

If there are 100 docs in BKPF table .. it will select the 1st record.

Read (I assume u are referring to read from Internal table) statement also reads the 1st record from ur internal table that matches the key specified in ur read statement.

read table itab into wa with key bukrs = '0001'.

same as explained.

Cheers. If there is something else.. feel free to come

Re: Select SINGLE vs READ statements

Former Member — Mon, 04 Dec 2006 05:34:09 GMT

Select single - is used for extacting one record form SAP-Data base table .

Read is used only for extracting single record from internal table with in ABAP program.

Ex:-

tables : T001w.

Select single * from T001W where WERKS = 'A008'.

write 😕 t001w-werks.

Ex read :-

data : int_plants like t001w occurs 0 with header line.

Select * from T001W into table int_plants .

read table int_plants with key werks = 'A008'.

If Sy-subrc eq 0 .

write 😕 int_plants-werks.

endif.

Ramvelu

Re: Select SINGLE vs READ statements

Former Member — Mon, 04 Dec 2006 05:34:15 GMT

Hi Bhaskar

Both statements are used for reading one record.

SELECT SINGLE -> DB Table

READ -> Internal Table

Eg:

SELECT SINGLE <FLD1> <FLD2> INTO (<WA>-FLD1, <WA>-FLD2)
              FROM (DBTABLE)
              WHERE <COND>.

READ <ITAB> INTO <WA> WITH KEY <FLD1> = ....
                                                          <FLD2> = ....

One more major difference is we can not use comparision operator other than EQUAL and NOT EQUAL with READ statements, whereas we can use the same with SELECT SINGLE.

Hope this helps.

Kind Regards

Eswar

Re: Select SINGLE vs READ statements

Former Member — Mon, 04 Dec 2006 05:40:47 GMT

The SELECT SINGLE statement is used for accessing matching records (wen a conditon is specified) from the underlying database tables, one record at once...

Whereas , the read statement is used to reference a record from an internal table.. Any specific record can be fetched using the INDEX addition AND/OR a matching codition ..

The select single statement is more efficient than the select statement..and it fetches records (one by one) in sequence from the DB table...

Regards

Pankaj