topic Re: No Where Codition in Code Inspector in Application Development and Automation Discussions

No Where Codition in Code Inspector

pranay25 — Tue, 28 Mar 2023 11:35:31 GMT

Dear SAPians,

I'm getting one code inspector error in the program 'No Where Condition'.

The Issue is coming from this query.

When I check documentation for MAX or MIN function for the Select Query, It's showing the same code that I have used in my Program. In the documentation there are no where condition as you can see in below screenshot.

Is there any solutions for this issue?

Regards,

Pranay Maity

Re: No Where Codition in Code Inspector

matt — Tue, 28 Mar 2023 16:19:43 GMT

The code inspector is telling you that you are counting how many entries there are in the entire table. If this is what you intend, then you need to take the action appropriate for where you work. E.g. apply for exemption, or ignore. DO NOT PUT SOME SILLY CODE IN JUST TO GET AROUND THE CODE INSPECTOR.

Usual, when people use COUNT, they're counting how many records meet a specific condition, hence code inspector raises it as a possible issue.