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
Explain the uses of the simple maintenance interface? : sap abap hr
Explain what is the difference between primary key and unique key?
what is call back in alv?
How to maintain lists?
I have 3 transactions,where the output of one transaction is input of another and output of 2nd transaction is input of 3rd transaction.i have one flat file with all data for the 3 transaction.if the 3rd transaction failed can we rollback the remaining 2 transactions or not.Is this possible in BDC,How/
Do you know any other patterns if yes.. explain
how can you display data say "your name"in sap script without print program or driver program??
what is the t-code to link technical and functional operation?
What is difference between dependent and independent data?
Suppose the client wants me the vacancy to be displayed on a website as well as ess. How should I do it? : sap abap hr
How do you document ABAP programs? Do you use program documentation menu option?
what is friend class
What is the difference between Classic badi and Kernal badi ?
Is it possible to pass data to and from include programs explicitly? : abap modularization
What are the sequences of event block?