RuntimeError CX_SY_DYNAMIC_OSQL_SEMANTICS

Code: Alles auswählen.

Runtime Errors         SAPSQL_GROUP_BY_ILL_TABLE_TYPE
Except.                CX_SY_DYNAMIC_OSQL_SEMANTICS
Date and Time          03.05.2011 14:52:09



 Short text
     GROUP BY on pool or cluster table.



 What happened?
     Error in the ABAP Application Program

     The current ABAP program "Z_GET_TABLES" had to be terminated because it has
     come across a statement that unfortunately cannot be executed.



 What can you do?
     Note down which actions and inputs caused the error.


     To process the problem further, contact you SAP system
     administrator.

     Using Transaction ST22 for ABAP Dump Analysis, you can look
     at and manage termination messages, and you can also
     keep them for a long time.



 Error analysis
     An exception occurred that is explained in detail below.
     The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS', was
      not caught and
     therefore caused a runtime error.
     The reason for the exception is:
     A SELECT statement was to be executed in which the result set is to be
     grouped with GROUP BY.The column 'SPRAS ' according to which the grouping
     should be carried out, is a column of the pool or cluster table 'INDEXDT '.

     However, in Open SQL, it is only allowed to group according to columns
     of transparent tables or columns of database views or projection views
     on transparent tables.

Code: Alles auswählen.

loop at lt_itab ASSIGNING <z1>.


  Select spras from (<z1>-tabname) into CORRESPONDING FIELDS OF TABLE lt_spras GROUP BY spras.


 loop at lt_spras ASSIGNING <z2>.

   <z2>-tabname =  <z1>-tabname .


  endloop.

APPEND LINES OF lt_spras to lt_spras2.
clear lt_spras.


endloop.