topic Re: Problem while using At Last Event in Application Development and Automation Discussions

Problem while using At Last Event

Former Member — Wed, 24 Dec 2008 07:51:35 GMT

hi,

The following is my code...

LOOP AT it_ekpo INTO wa_ekpo.
AT LAST.
      SUM.
      WRITE:/'GRAND TOTAL',69  wa_ekpo-netpr .
    ENDAT.
  ENDLOOP.

After executing the report, it is giving an Runtime Error.

Runtime Errors : Sum_overflow

Can u people give some valuable inputs to solve this issue.

Thanks

Gov

Re: Problem while using At Last Event

Former Member — Wed, 24 Dec 2008 07:54:29 GMT

Cause: Value too large when calculating totals in internal table, field too small

Runtime Error: SUM_OVERFLOW

Increase the size of : wa_ekpo-netpr

Re: Problem while using At Last Event

Former Member — Wed, 24 Dec 2008 08:21:06 GMT


> Cause: Value too large when calculating totals in internal table, field too small 
> Runtime Error: SUM_OVERFLOW 
> 
> Increase the size of : wa_ekpo-netpr

Thanks for your reply,

but how can i increase the size of the variable...

here i'm referring to ekpo-netpr

Thanks

Gov

Re: Problem while using At Last Event

Former Member — Wed, 24 Dec 2008 08:26:16 GMT

hi,

use datatype as

netpr type bapicurr_d.

It should work...

Rgds.,

subash

Re: Problem while using At Last Event

jayanthi_jayaraman — Wed, 24 Dec 2008 08:36:46 GMT

Hi,

While declaring the internal table it_ekpo, try to specify the field width as more than actual field width in the table.

Re: Problem while using At Last Event

Former Member — Wed, 24 Dec 2008 08:41:56 GMT

thanks for your replies.

My structure was like this before

TYPES: BEGIN OF ty_ekpo,
          lifnr TYPE ekko-lifnr,    "vendor number
          ebeln TYPE ekko-ebeln,    "purchase document number
          ebelp TYPE ekpo-ebelp,    "Item Number of Purchasing Document
          matnr TYPE ekpo-matnr,    "Material Number
          bukrs TYPE ekpo-bukrs,    "Company Code
          werks TYPE ekpo-werks,    "Plant
          lgort TYPE ekpo-lgort,    "Storage Location
          menge TYPE ekpo-menge,    "Purchase Order Quantity
          netpr TYPE ekpo-netpr,
      END OF ty_ekpo.

Now i changed it to the way u suggested

TYPES: BEGIN OF ty_ekpo,
          lifnr TYPE ekko-lifnr,    "vendor number
          ebeln TYPE ekko-ebeln,    "purchase document number
          ebelp TYPE ekpo-ebelp,    "Item Number of Purchasing Document
          matnr TYPE ekpo-matnr,    "Material Number
          bukrs TYPE ekpo-bukrs,    "Company Code
          werks TYPE ekpo-werks,    "Plant
          lgort TYPE ekpo-lgort,    "Storage Location
          menge TYPE ekpo-menge,    "Purchase Order Quantity
          netpr(16) type p decimals 2,
      END OF ty_ekpo.

But still the problem persists.

I'm getting the same error.

Thanks

Gov

Re: Problem while using At Last Event

Former Member — Wed, 24 Dec 2008 08:45:05 GMT

Hi,

Debug the above program, and find out the value of wa_ekpo-netpr and TOTAL value before giving runtime error. Then you will find the required length of the netpr.

Regards,

Re: Problem while using At Last Event

jayanthi_jayaraman — Wed, 24 Dec 2008 08:49:04 GMT

Hi,

Just try to use

TYPES: BEGIN OF ty_ekpo,

lifnr TYPE ekko-lifnr, "vendor number

ebeln TYPE ekko-ebeln, "purchase document number

ebelp TYPE ekpo-ebelp, "Item Number of Purchasing Document

matnr TYPE ekpo-matnr, "Material Number

bukrs TYPE ekpo-bukrs, "Company Code

werks TYPE ekpo-werks, "Plant

lgort TYPE ekpo-lgort, "Storage Location

menge TYPE ekpo-menge, "Purchase Order Quantity

netpr type GESUM,

END OF ty_ekpo.

Here GESUM is a data element with WERT15 as domain.

Re: Problem while using At Last Event

Former Member — Wed, 24 Dec 2008 08:55:10 GMT

hi,

try this one..

data: v_netpr type ekpo-netpr.

v_netpr = 0.

LOOP AT it_ekpo INTO wa_ekpo.

v_netpr = v_netpr + wa_ekpo-netpr.

AT LAST.

WRITE:/'GRAND TOTAL', v_netpr .

ENDAT.

ENDLOOP.

if the same error exist, let me know....

Re: Problem while using At Last Event

Former Member — Wed, 24 Dec 2008 09:04:25 GMT

Thanks for your valuable suggestions