Question Re: Problem Select sum with group by. in Technology Q&A

Problem Select sum with group by.

former_member635273 — Sat, 08 Feb 2020 03:30:49 GMT

SELECT SUM( menge ) brpme FROM zmtc_item INTO CORRESPONDING FIELDS OF TABLE it_tot
  WHERE ebeln = p_ebeln  GROUP BY brpme.

the problem is value return 0 in smartforms and UoM (M and ***) it should be (M and PC). like pic sap2.jpg

This is when i debug.

and this is in smartforms

Re: Problem Select sum with group by.

michael_piesche — Sat, 08 Feb 2020 04:08:43 GMT

You have two problems:

When using „into corresponding fields“, the column names need to be identical. This is not the case for „sum( menge )“, as it is a dynamic column that will be named by the dbms or ABAP as probably „SUMMENGE“, or not get a name assigned at all
=> rename in your select statement this column: „sum( menge) as menge“
Or use a table type that matches your selection fields in order and type, and don’t use into corresponding fields
I assume the translation for PC is missing, since this is only a problem on the printout

Re: Problem Select sum with group by.

former_member635273 — Sat, 08 Feb 2020 05:33:39 GMT

I rename sum( menge ) as sum.still not work. So,I use table type.and it's work.

and second problem, you are right. when I insert UoM => PC, it's not appears in printout. when i insert UoM => ST. in smartform appears PC.

Re: Problem Select sum with group by.

michael_piesche — Sat, 08 Feb 2020 07:02:34 GMT

Sorry for that mistake of mine, of course I meant to write „sum( menge) as menge“, after all you want the column to have the same name so that the „into corresponding fields“ statement works. Sorry for the confusion.