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

​​What is view proxy in abap?

797


What is a fall back class?

1020


What is meant by hot spots? : abap data dictionary

642


What are the fields in the memory table ‘screen’?

592


What should be the approach for writing a bdc program? : abap bdc

583






What is tcode se16?

606


What is transparent table?

602


if while coding power goes off , how to retrieve the codes?

1628


What is an Open Item in SAP? How will you find an Open Item in SAP?

630


What is the process to enhance the Infotype

2892


What is the difference between synchronous and asynchronous update? : abap bdc

647


Explain the data types of internal tables?

635


What is the transaction for recording bdc ? : abap bdc

607


How to combine multiple billing into one RV document ( Step by Step)?

1545


What are the payroll related infotypes? : abap hr

579