what is the difference between [select single xxx from ...]
and [select * from ... up to one row]?
Answer Posted / harsha
upto one row is faster than select * from
select single xxx from xxx into wa xx = xxx-xx means it will check all the fields and finally gives a first possible record in the selected group of record
select * from xxx in wa where xx-xxx upto one row means it retrieves only first possible record of table satisfying th condition.
please revert me if any issues with this answer. i dunno weather its ryt r rong.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the uses of table pool or table cluster.
What are the difference between pool tables and transparent tables?
What are the different types of the sap abap data dictionary objects?
A function module can be called from a transaction screen outside an abap/4 program. State true or false. : abap modularization
What are the events used in abap in the order of execution?
Different types of luws. What are they?
What is the significance of the memory table ‘screen’?
What is the difference between native sql & open sql? : abap data dictionary
hi experts,,, what is meant by documentation? test casr preparation? documentation and preparation and Tcode for this? quality and releasing? test case scenario?
What are the advantages and disadvantages of using views in abap programming ?
Explain the inside concept in select-options?
What is generic buffering?
If A is the super class of B. And both the classes have constructor. We create an object of class B. Then which constructor will be called? If both then in which order?
What is modularization and its benefits?
What is a view in sap? : abap data dictionary