Totals Calculation

[Former Member]

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

[Former Member]

>

> 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?

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

Regards,

Srik

[Former Member]

Srik,

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

You need to fit the requirement

//Kothand

[Former Member]

This message was moderated.

[Former Member]

Hi,

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

Regards,

Srik

[Former Member]

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?

[former_member125931]

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.*

[Former Member]

thank u