topic Re: difference between Select * and Select single ? in Application Development and Automation Discussions

difference between Select * and Select single ?

Former Member — Fri, 08 Dec 2006 12:53:43 GMT

difference between Select * and Select single ?

Re: difference between Select * and Select single ?

Former Member — Fri, 08 Dec 2006 12:55:21 GMT

Hi ,

Select * ....: It selects all the fields from the table and this statement requires an endselect.

Select single : It selects only one records and it does not required end seelct.

Regards

ARUN

Re: difference between Select * and Select single ?

Former Member — Fri, 08 Dec 2006 12:55:38 GMT

Select single will only pick up one record for the conditions specified

select * wll pick up all the records for that condition

Also check these links

https://forums.sdn.sap.com/click.jspa?searchID=342118&messageID=1710019

https://forums.sdn.sap.com/click.jspa?searchID=342118&messageID=647631

Re: difference between Select * and Select single ?

Former Member — Fri, 08 Dec 2006 12:55:45 GMT

Select single return one record corresponding to the key field you fill.( all the table key must be fill )

Select * return a range of record corresponding to the parameter you fill in the statement.

Hope this helps,

Erwan

Re: difference between Select * and Select single ?

Former Member — Fri, 08 Dec 2006 12:56:14 GMT

select * will get all the columns of the table. The number of records will be dependent upon the where clause.

select single * will get a single record with all the columns of a table.

select single field1 field2..will get one record with the fields field1 field2 ..

Re: difference between Select * and Select single ?

Former Member — Fri, 08 Dec 2006 12:59:56 GMT

Hi,

Select * means Selecting all the fields in the table.

Select single means Selecting single record from the table that matches the Where clause condition. In Select Single statement, Where clause must contain all the key fields of the table.

thanks,

sksingh

Re: difference between Select * and Select single ?

Former Member — Fri, 08 Dec 2006 13:03:32 GMT

HI,

DATA : IT TYPE TABLE OF MARA,

WA TYPE MARA.

Here it selects all the record and keeps in internal table it.

Select * from mara into corresponding fields of table it.

Here it slects only one record that to first record.

If you wnat any specific record then use where condition.

Select single * from mara into corresponding fields of wa.

Message was edited by:

Purshothaman P

Re: difference between Select * and Select single ?

Former Member — Fri, 08 Dec 2006 13:41:23 GMT

SELECT * READS ALL THE FIELDS OF A RECORD FROM THE DATABASE.

SELECT * FROM MARA INTO TABLE ITAB.

THE ABOVE STATEMENT SELECTS ALL THE FIELDS OF ALL THE RECORDS IN THE DATABASE AND GET INTO THE ITAB.

IT IS SAME AS:

SELECT * FROM MARA INTO ITAB.

APPEND ITAB.

ENDSELECT.

WHERE AS:

AELECT SINGLE * FROM MARA INTO TABLE ITAB WHERE <COND>----- READS ONLY ONE RECORD BASED ON THE CONDITION.

WE DONT NEED TO WRITE THE ENDSELECT ALSO.

CHEERS.

Re: difference between Select * and Select single ?

Former Member — Fri, 08 Dec 2006 13:41:37 GMT

hi...

SELECT * means u selecting all the fields from the table and putting it into the internal table of type <tablename>

eg: select * from mara into corresponding fields of it_mara.

the above statement means u selectings all the fields of the it_mara.

where as,

SELECT SINGLE implies that u r selecting just only one record or entry from that table and putting it into the work area.

ie,

select single * from mara into wa_mara.

hope now u got the difference..

all the best!!

Re: difference between Select * and Select single ?

Former Member — Sat, 09 Dec 2006 04:28:24 GMT

Hi,

Select * starts a loop so as to find the entries specified by where condition or else the complete list of records.It is concluded by endselect.

Select Single selects the first(single) occurrence of the record that satisfies the condition & does not move in a loop.Hence endselect not required in this case.

Also Select Single is more efiicient performance wise as compared to select * if required records has less ocuurence in the internal table.

Hope it helps.

Reward if helpful.

Regards,

Sipra