topic internal table record in Application Development and Automation Discussions

internal table record

Former Member — Wed, 01 Nov 2006 21:43:35 GMT

Hello Experts,

I need to sum up the values of an internal table record.

data: l_demand type p decimals 2.

The itab is:

MATNR DEMAND

....................

A005 100.00

A005 200.00

A005 300.00

A005 450.00

A005 325.00

Now I would want to get the sum of all values "DEMAND" into variable "l_demand".

Can you please tell me how can I do that?

Thanks.

Re: internal table record

Former Member — Wed, 01 Nov 2006 21:45:56 GMT

Hi,

Try this..

LOOP AT ITAB.

AT LAST.

SUM.

L_DEMAND = ITAB-DEMAND.

ENDAT.

ENDLOOP.

WRITE: / L_DEMAND.

Thanks,

Naren

Re: internal table record

ferry_lianto — Wed, 01 Nov 2006 21:48:58 GMT

Hi,

You can also code like this.


LOOP AT ITAB.
  L_DEMAND = L_DEMAND + ITAB-DEMAND
ENDLOOP.

WRITE: / L_DEMAND.

Regards,

Ferry Lianto

Re: internal table record

Former Member — Wed, 01 Nov 2006 22:04:07 GMT

Thank you very much for the help.

Re: internal table record

Former Member — Wed, 01 Nov 2006 22:34:12 GMT

Hi,

Try this..Exit out of the loop if the current row is greater than 12.

LOOP AT ITAB.

IF SY-TABIX > 12.

EXIT.

ENDIF.

L_DEMAND = L_DEMAND + ITAB-DEMAND.

ENDLOOP.

WRITE: / L_DEMAND.

Thanks,

Naren

Re: internal table record

Former Member — Wed, 01 Nov 2006 22:36:34 GMT

LOOP AT ITAB FROM 1

TO 12.

L_DEMAND = L_DEMAND + ITAB-DEMAND.

ENDLOOP.

Max

Re: internal table record

Former Member — Wed, 01 Nov 2006 23:02:56 GMT

Hi,

Please remember to award points for helpful answers..

Thanks,

Naren

Re: internal table record

Former Member — Wed, 01 Nov 2006 23:47:41 GMT

thnx for all help.

sorry for the delay in rewarding points.