Question: what is the difference between select single and upto 1 row in abap?
Answer: Here is the difference: SELECT SINGLE returns the first matching row for the given condition and it may not be unique, if there are more matching rows for the given condition. SELECT ... UP TO 1 ROWS retrieves all the matching records and applies aggregation and ordering and returns the first record.