topic Re: Totals Calculation in Application Development and Automation Discussions

Totals Calculation

Former Member — Mon, 21 Jul 2008 10:44:52 GMT

Hi Experts,

I have a requirement that:

I need to calculate the total for a particular field according to the individual years.

For Eg: Let the field name be 'Amount reimbursed' for the year 2007 from a particular Ztable, we need to calculate the total amount and later need to check whether the value is less than $5000.

Regards,

Srikanth

Re: Totals Calculation

Former Member — Mon, 21 Jul 2008 10:46:09 GMT


> Hi Experts,
> 
> I have a requirement that:
> I need to calculate the total for a particular field according to the individual years.
> 
> For Eg: Let the field name be 'Amount reimbursed' for the year 2007 from a particular Ztable, we need to calculate the total amount and later need to check whether the value is less than $5000.
> 
> Regards,
> Srikanth

That's nice - sounds interesting.

Do you have a specific question?

Re: Totals Calculation

Former Member — Mon, 21 Jul 2008 10:48:58 GMT

Hi Srik,

try this

SELECT SUM( amount field )

into lv_total_amount

from ztable

where year field = '2007'.

if lv_total_amount > 5000.

*do the processing

endif.

//Kothand

Re: Totals Calculation

Former Member — Mon, 21 Jul 2008 10:49:19 GMT

Hi,

That itseld is my requirement. I created a custom infotype and I need to insert a field call Total and this contains the total of the fee reimburesed.

Regards,

Srik

Re: Totals Calculation

Former Member — Mon, 21 Jul 2008 10:49:23 GMT

This message was moderated.

Re: Totals Calculation

Former Member — Mon, 21 Jul 2008 10:50:44 GMT

Hi,

I just gave 2007 as an example but actually it should work for the future years aswell.

Regards,

Srik

Re: Totals Calculation

Former Member — Mon, 21 Jul 2008 10:55:54 GMT

Srik,

I just gae you the idea SUM is used for calculating total even throught SELECT statement.

You need to fit the requirement

//Kothand

Re: Totals Calculation

Former Member — Mon, 21 Jul 2008 11:25:45 GMT

Hi,

The requirement above is w.r.t to custom infotype. Please help me out.

Regards,

Srik

Re: Totals Calculation

Former Member — Mon, 21 Jul 2008 11:26:55 GMT

Srik,

You've already been given some suggestions on how to do this - what more do you want? Do you want someone else to write the code for you?

Re: Totals Calculation

former_member125931 — Mon, 21 Jul 2008 12:16:23 GMT

Try like this.

*sort itab ascending by yearfield .

loop at itab into wa.

at yearfield.

endat.

sum = sum + wa-amountfield.

at END OF yearfield.

endat.

ENDLOOP.*

Re: Totals Calculation

Former Member — Tue, 05 Aug 2008 14:25:34 GMT

thank u