Best practices
Thou shalt not SELECT *
2014-09-04

Always try to select only the fields you’ll need. Selecting others is a waste of resources.
Exception made for the use of FM *_SINGLE_READ because, even though these do select all fields, since they cache the data, they are still faster when used multiple times for the same key.
If you just want to check if a record exists, select just one field, if possible the one you’re using as criteria to avoid declaring an extra variable. Example: SELECT KUNNR INTO V_KUNNR FROM KNA1 WHERE KUNNR = V_KUNNR.
https://abapinho.com/2010/11/select-todos-os-campos/ (portuguese)
15 de September de 2015 às 08:21 PM
SAP site with a difference. Really like your page.
Regards,
Raju
29 de September de 2015 às 11:32 PM
Thanks! Glad you like it :)