Skip to Content
0
Former Member
Jul 21, 2009 at 11:56 AM

how to use the SQL group by functionality on internal table.

321 Views

hi..

can any body explain me to how to use the SQL group by functionality on internal table.

i want to use the aggregate function on internal table using the different columns of the table.

like

in SQL we use

select werks matnr maktx extwg lgort umren meins sum(menge) sum(prd_wat)

from itab

group by werks matnr maktx extwg lgort umren meins

how this functionality will work on internal table ?

similarly if i want to use the max, min or average of internal table column.

i just give you the sql statement above.

also just give me the some different ways to do this work.....

Regards

Nitin Varshney