abapOpenChecks - Installation - Checks - Utilities - Links

CHECK_38 - Avoid use of SELECT-ENDSELECT

Improve this page
RFC enabled
CODE
SELECT * FROM db1 INTO struc1.
...
ENDSELECT.

Should be changed to

SELECT * FROM db1 INTO TABLE itab1.

Exception: SELECT UP TO n ROWS

SELECT * FROM db1 UP TO 1 ROWS INTO struc1
  WHERE key2 = value2.
ENDSELECT.  

Make sure to check the relevant development guidelines, SELECT SINGLE is in some cases easier to read and understand than UP TO 1 ROWS + ENDSELECT

See http://wiki.scn.sap.com/wiki/display/Community/ABAP+Performance+tips

Configuration

Configuration