Month wise Total

[Former Member]

Hi alll

I want month wise summary total. How can i calculate.my datas r in internal table. how can i calculate. Internal table structre

date

amount,

sales organisation,

etc.

[Former Member]

Hi alll

I want month wise summary total. How can i calculate.my datas r in internal table. how can i calculate. Internal table structre

date

amount,

sales organisation,

etc.

[Former Member]

check the infostuctures which u are using ?

search in se11 with s*

Regards

Prabhu

[Former Member]

Hi,

u can use one simple logic.

assum your table name is itab and date format is ddmmyyyy.

loop at itab.

case itab-date+2(2).

when '01'." for month of jan

sum1 = sum1 + itab-amount. "sum 1 represent sum for jan month

"similarly do it for all the 12 months.

endcase.

endloop.

Regards,

Sumit.

[Former Member]

Hi,

call function 'CACS_DATE_GET_YEAR_MONTH'

by using this function u can find out the month and year and insert these month and year with all the records in int tab. than u can easily use

at ...endat for calculating the sum