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
How will you link form with the event driven in sap scripts?
What is repository info. Systems?
What is exception class and test class. How to use it?
What do you do when the system crashes in the middle of a BDC batch session?
Example of table cluster and cluster tables.
Explain how to Handle the internal tables in ABAP?
Can you define a field without a data element?
What is a 'z' report?
If i wont like to change the standard print program where i copied standard script to customer namespace,in this case is it possible to retreive the data if u connect the script with standard program.if yes how?if no why? Is it possible to print the logo in first page only,where the form consists of 10 pages.How can u do this? How can u set a table format where it cosists of fields like cust no, custname, amount ...in a script? How do u know that the particular BADI is suitable for the existed report.How do u findout this?When do u opt for BADI OR USEREXIT?did functional people tell u to adopt BADI or USEREXIT? What is the difference between SY-INDEX & SY-TABIX ? I have a report with fields Status,time & date. the contents it consists are Status Time Date AAA 01:20:15 05-06-10 AAA 11:02:32 O3-06-10 AAA 23:11:00 05-06-10 AAA 09:14:46 05-06-10 HOW DO U WRITE A CODE TO DISLAY A ROW WHICH WAS RECENTLY EXECUTED?( for this question it should display AAA 23:11:00 05-06-10 AS Output)
Reports: Event functionality.
How do you find number of records present in internal table?
Have you processed BDCs ?
I need some information regarding Vcentric Test pattern ? with questions.
What is the difference between commit-work and rollback-work tasks?
What are client dependent objects in abap/sap?