title: SUM totals by FOR ALL ENTRIES itab keys
body: <p>I want to execute a SELECT query on a database table that has 6 key fields, let's assume they are keyA, keyB, ..., keyF.</p>
  
  <p>As input parameters to my ABAP function module I do receive an internal table with exactly that structure of the key fields, each entry in that internal table therefore corresponds to one tuple in the database table. </p>
  
  <p>Thus I simply need to select all tuples from the database table that correspond to the entries in my internal table.
  Furthermore, I want to aggregate an amount column in that database table in exactly the same query.</p>
  
  <p>In pseudo SQL the query would look as follows:
  SELECT SUM(amount) FROM table WHERE (keyA, keyB, keyC, keyD, keyE, keyF) IN {internal table}.</p>
  
  <p>However, this representation is not possible in ABAP OpenSQL.</p>
  
  <p>Only one column (such as keyA) is allowed to state, not a composite key. Furthermore I can only use 'selection tables' (those with SIGN, OPTIOn, LOW, HIGH) after they keyword IN.
  Using FOR ALL ENTRIES seems feasible, however in this case I cannot use SUM since aggregation is not allowed in the same query.</p>
  
  <p>Any suggestions?</p>