Archived discussions are read-only. Learn more about SAP Q&A

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

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

Not what you were looking for? View more on this topic or Ask a question