However, it does not take into account that there may be other field combinations which might also be a unique index, nor that you may simply be doing an existence check, or that you the fields you are interested may remain constant over the where clause specified.
I think SELECT SINGLE is more readable, and therefore better. Others think that it is ambiguous, so SELECT UP TO 1 ROWS is better.
Dig Deeper on SAP ABAP
Related Q&A from Matthew Billingham
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading
An SAP user needs information on how to change the password on several SAP user accounts from a central location. Continue Reading