group by - ABAP: SUM up a NUMC field -

I need a table group with the sum of NUMC-column, which unfortunately does not seem possible with ABAP / Open SQL it happens .

My code looks like this:

  select z ~ anln1 to zzanla in AS table by gt_ group z ~ anln1 z ~ anln2 heaving yoga (z ~ percent) & Lt; & Gt; 100% Unfortunately one NUMC - & gt; Summary is not possible  

What will be the best / easiest methods here because I can not change the table myself

Unfortunately the NUMC type is described as numeric text, in the end it is defined as the land in the database as VARCHAR and for this reason Function like SUM or AVG can not be used

It all depends on how large your table is if it is not small, you can get value for the values ​​in the group's field and an internal table, and then explain it using the statement And ultimately remove those rows for which the amount is 100%.