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 |
IN SCRIPTS IF WE HAVE EMPTY SECOND LAYOUT AND IF WE HAVE MENTIONED ABOUT IT IN NEXT PAGE ATTRIBUTE THEN IN OUTPUT HOW WE GET THE SECOND PAGE OUTPUT.
Can you print decimals in type n?
Can we download master data using LSMW method?
In one of our zflash against collections report is not matching with the actual collections i.e invoice valuse of 200000 and payment had received for entire invoice and as per accounts of the particular customer this invoice is cleared but when we had tken z flash for collections which had developed my ABAP tem it's not matching.it's happened for many invoices how to get right report as per the payment details?
What is an “on input filed” statements?
any 1 having notes on SAP-ABAP certification, or even if any 1 could provide the url for getting notes on SAP-ABAP certification, would be appreciated.
What are different data types in ABAP?
How many types of views are there ?
how many blocks can create in a ALV BLOCK LIST in ABAP?
In select-options, how to get the default values as current month first date and last date by default? Eg: 1/10/2006 and 31/10/2006
2) What is the difference between TYPE and DATA?
how we can do transfer data from oracle/access to our sap R/3 system by using call transaction(recording) or session method. pls reply on my id: zaheer_guts@yahoo.co.in