var FeedUrl = 'http://www.news-sap.com/feed/'; var MaxCount = 1; var showDate = 'none';

SUM or GROUP BY .. In internal Tables

ABAP SAP Consultant needs help regarding “SUM or GROUP BY .. In internal Tables “

Hello Experts,

I am fairly new to ABAP, but i have good understanding of ABAP as well as SAP, (I hold Mstr degree in SAP)

I often come to situation like to sum the currency field in an internal table, just like

SELECT FIELD1
              FIELD2
              FIELD3
              SUM( FIELD4 )
              FROM...
              WHERE <CONDITIONS...>
              GROUP BY FIELD1 FIELD2 FIELD3...

This would be easy to do, but what i have all the datas in an internal table,
i want to perform the same thing as above using internal table,

i tried using AT END OF…ENDAT but you cant use nested AT to get the sum..

Example…
i have field COMPANY CODE, GL NO , DOCUMENT NUMBER, DATE, AMOUNT.

in this case i want to amount to be grouoped by all before fields (i.e. CC, GL no, Doc no, Date)
*I only need to know how can do better using internal table.

ABAP Consultant, needs help regarding SUM or GROUP BY .. In internal Tables Help!





Browse more questions like this in module: Uncategorized


Question filed under SAP Module: Uncategorized Tags: Group, Internal, tables



Search for solution...


Related search terms:

Disqus this Question






sap forum