Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?

Answer Posted / vijayaraghavan

Select Single * will pickup only one matching record from the database into the buffer, and returns the same to the internal table.

Select upto 1 rows will pickup all the records matching the condition into the buffer, but return the top record to the internal table.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you find the information on the current screen? : abap bdc

602


How do we handle multiple line items in BDC's.

6362


How to know if the value entered contains records or not?

544


What is the difference between data elements and domains? : abap data dictionary

577


What is payroll area

1808






What are the function modules used in a sap script driver program?

564


What are the types of bdc s?

579


i have cleared my technical round and manager round in cts but they told me u will get a call with in couple of days now i dont know about my status

8497


Does the external program run in the same sap luw as the caller, or in a separate one?

655


What is foreign key relationship? : abap hr

611


What are the different types of laws. What are they?

594


Explain what are standard layouts sets in the sap script?

933


Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul

3254


What is a data class? : abap data dictionary

625


the problem is that , while i am undergoing with my practice session, i am creating too many new programs.they are occupying much space in my hard-disk. how to delete un-necessary programs completely from my data- base........... plz help me with this .....

1564