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

[shantraj6]

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

[shantraj6]

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.

[janewar]

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).

[BiberM]

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?

[former_member839746]

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.