Question Re: ATC Check error - The SELECT command is executed on the database (SELECT 694) in Technology Q&A

ATC Check error - The SELECT command is executed on the database (SELECT 694)

former_member839746 — Thu, 13 Jul 2023 12:53:28 GMT

Hello All,

I wrote a select statement over internal table, and when performed the ATC check, I got the error as 'The SELECT command is executed on the database.'(SELECT 694). Any inputs on why this error is coming up?

No pragma to suppress the error.

Following is the code that was written:

select a, count ( a )

as lv_count

from @lt_internaltable as lt

group by a

into table @data(lt_Tab2).

Thanks and Regards,

Naga

Re: ATC Check error - The SELECT command is executed on the database (SELECT 694)

shantraj6 — Thu, 13 Jul 2023 13:08:49 GMT

you can loop on internal table and then increment the lv_value on each iteration and fill other details as per further requirement in lt_tab2 internal table.

or put a select condition on DB table instead of internal table.

Re: ATC Check error - The SELECT command is executed on the database (SELECT 694)

BiberM — Thu, 13 Jul 2023 13:26:17 GMT

Hi.

Isn't that the desired behavior? You run a Select on an internal table. This is pushes to the database and executed with database Operations.

The question is: why is that an ATC error? Doesn't want your Company those means to be used?

Re: ATC Check error - The SELECT command is executed on the database (SELECT 694)

former_member839746 — Thu, 13 Jul 2023 13:28:24 GMT

I'm using SAP standard ATC checks, without any variants!!

Does those mean, SAP doesn't want this operation to be performed in such a way.

Re: ATC Check error - The SELECT command is executed on the database (SELECT 694)

axel_jebens — Fri, 14 Jul 2023 09:47:28 GMT

The message is a syntax warning which is independent from ATC. ATC displays syntax warnings. When you deal with internal data which is on the application server, it is probably better not to push it in the database first and then process it there. This is what's happening here. There are aggregation techniques in ABAP that can be used, e.g. LOOP AT ... GROUP BY..., SORT, ...
You have to decide whether you want to save development time and leave it like it is (then use the pragma ##ITAB_DB_SELECT or an ATC exemption) or rethink the code which may take some time. But maybe it is not critical at all for performance because it is executed only once.

Re: ATC Check error - The SELECT command is executed on the database (SELECT 694)

former_member839746 — Fri, 14 Jul 2023 10:24:49 GMT

Yes, we have the option to achieve the same using loop at, and sum, but I was looking to make the code look simpler:)

Wondering why the select on @itab was introduced, when the system throws a syntax check warning..

Re: ATC Check error - The SELECT command is executed on the database (SELECT 694)

axel_jebens — Fri, 14 Jul 2023 11:12:29 GMT

The SELECT on an internal table is very useful für JOIN statements, and it replaces the FOR ALL ENTRIES CLAUSE. It is in general faster and much more flexible. If a list is needed for data on the database, you have to push down the information. But if you don't, it is better to not use it, but of cause it depends on the individual case.

Code stability and simplicity are other criteria. From my personal perspective, there is never a general good or bad. You can suppress the warning, but in general it tells you that this can be optimized.

Re: ATC Check error - The SELECT command is executed on the database (SELECT 694)

philipp_degler — Fri, 14 Jul 2023 11:16:39 GMT

Hi Naga,

The message SELECT 694 gives a hint that the statement cannot be executed in the ABAP server, i. e. the statement is executed in the database. This hint is given as the execution time might be higher than expected.

Re: ATC Check error - The SELECT command is executed on the database (SELECT 694)

janewar — Wed, 24 Jul 2024 07:26:41 GMT

SELECT ##ITAB_DB_SELECT DI_CODE, COUNT( MATNR ) AS MATNR_COUNT FROM @LT_LIPS_MARA AS LIPS_MARA GROUP BY DI_CODE INTO TABLE @DATA(LT_SUMMARY).