topic Pragma/Pseudo Code to suppress Select * in Application Development and Automation Discussions

Pragma/Pseudo Code to suppress Select *

manuel_horn3 — Thu, 20 Jul 2017 18:42:32 GMT

Hi Experts,

is there a Pragma/Pseudo Code to suppress Select * e.g. if more fields are selected than used in the coding? I tried #EC * but that doesn't work.

Is there another Pragma/Pseudo Code to supress Errors of the Code inspector?

Thanks and regards!

Re: Pragma/Pseudo Code to suppress Select *

retired_member — Thu, 20 Jul 2017 20:13:52 GMT

CI messages cannot be suppressed by pragmas but by pseudo comments only. As a rule, a CI message should inform you about the corresponding pseudo comment.

https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abenpseudo_comment_ci.htm

Re: Pragma/Pseudo Code to suppress Select *

larshp — Fri, 21 Jul 2017 06:04:55 GMT

Hi,

In case you are referring to the code inspector check "Search problematic SELECT * statements", and the error message is "Select-Statement can be transformed. &1% of fields used" then CI_ALL_FIELDS_NEEDED should work.

Sometimes the code inspector check does not inform about the pseudo comment, in this case the comment is documented in the code eg CONSTRUCTOR of class CL_CI_TEST_ANALYZE_SELECT_HANA

Re: Pragma/Pseudo Code to suppress Select *

manuel_horn3 — Tue, 25 Jul 2017 10:48:44 GMT

Hi,

Thanks a lot for your help! I will test your input. Lars you are right, that is the check that I mean. Is there also a common pseudo comment where I can ignore all errors? I thout #CI * is this general comment. But it doesn't work.

Thanks and regards!