What is the difference between select single and select upto
1 rows?
Answers were Sorted based on User's Feedback
Answer / manu gowdru
select single:it selects the first record which matches the condition defined in WHERE clause.so if there many records which matches the criteria will be ignored,so its not unique
select upto 1 rows:it retrieves all the records which matches the condition mentioned in WHERE clause and puts aggregate,average and gives the result
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sumit0312
select single fetch the specified and matching data from the
table. and select up to 1 record directly select the first
record from the tabe.
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / nigesh
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 ? | 3 Yes | 4 No |
Answer / gagan
in select single , if multiple records are present matching
the where clause ( if stated ), then it returns the last
record among them.
While in select upto 1 rows , it returns the first
occurrence of the record.
Is This Answer Correct ? | 4 Yes | 10 No |
What is bdc? : abap bdc
What is view? Different types of view.
What are the check tables?
Some Realtime Objects on Bdc.
in session method sy-subrc is not returned whereas in call transaction method sy-subrc is returned . what does it mean?
i need the explanation for the following one . 1.BAPI 2.BADI 3.USEREXITS. 4.ALE,IDOCS,REPORT,SAPSCRIPTS,SMARTFORMS. And their uses,what is it process in realtime.
Explain what are standard layouts sets in the sap script?
Example of table cluster and cluster tables.
Explain what are lock objects?
Where do you create indexes in abap?
Hi To all ABAP Gurus Is there any other way to create data elements apart from se11 tocde as we dont use the se11 in real time generally this question is asked in enteg infotech
what is field string ? & where we are using field strings?