topic Re: using aggregation in ABAP code for internal table in Application Development and Automation Discussions

using aggregation in ABAP code for internal table

Former Member — Mon, 07 Mar 2011 05:23:29 GMT

I have written following code to get cumulative amount on a date but i have to hit database for each record.

Can't I use some function similar to SUM for doing the same thing on internal table??It would increase my performance.

code is:

SELECT SUM( DEB_CRE_LC ) FROM /BIC/AZFIAR_O500

INTO LV_BALMONTH WHERE DEBITOR = LV_DEBITOR AND

CALMONTH GE LV_STARTMONTH AND CALMONTH LE LV_LASTCALMON.

I want to put ZFIAR data to internal table and read and do SUM thing..is it possible?? withotut usiong loop.

regards,

rakesh

Former Member — Mon, 07 Mar 2011 10:56:15 GMT

You can use SUM statement at the time of selecting data to an internal table...

Do not know if any keyword is there to do similar activity...

Thanks

prasoon_sahay — Mon, 07 Mar 2011 11:07:37 GMT

You have loop on your internal table, then use COLLECT or SUM ststement

Former Member — Mon, 07 Mar 2011 11:30:10 GMT

Hi Rajesh,

types : begin of ty_tab,

date type dats,

DEB_CRE_LC type ..... " delare type & is the filed need to summerized

end of ty_tab,

data: itab type standard table of ty_tab.

SELECT date

SUM( DEB_CRE_LC ) as DEB_CRE_LC FROM /BIC/AZFIAR_O500

INTO corresponding fields of itab

where CALMONTH GE LV_STARTMONTH AND CALMONTH LE LV_LASTCALMON

group by date. " date is the field available in your ODS/transparent table

simulate the above code in your program...

Hope this will work..