topic Re: SUM_OVERFLOW DUMP in Application Development and Automation Discussions

SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 04:05:28 GMT

Hi,

I am getting a SUM_OVERFLOW DUMP when running a report in summerised List, while its running correctly in Detailed List.

The field I am using for Total is TYPE bsik-dmbtr.

Runtime Errors SUM_OVERFLOW

Except. CX_SY_ARITHMETIC_OVERFLOW

Any solution?

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 04:24:57 GMT

Hi,

Could you try with total type i .

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 04:29:02 GMT

Thanx for the reply

I tried but still the same dump

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 04:30:00 GMT

Hi Nishan,

May I know how many digits you are trying to sum-up?

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 04:36:28 GMT

Hi,

If you are using function module REUSE_ALV_GRID_DISPLAY or REUSE_ALV_LIST_DISPLAY, are you making use of the export parameter I_CALLBACK_USER_COMMAND ?

If yes, there is some problem in this subroutine. Put a break point and check.

Regards,

Danish.

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 04:44:42 GMT

Hi,

Yes I m using i_callback_user_command but on setting up the breakpoints it is not showing anything just showing the dump

FORM start_list_viewer_item.

DATA: pgm LIKE sy-repid.

pgm = sy-repid.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

i_callback_program = pgm

i_callback_user_command = 'USER_COMMAND1'

it_fieldcat = fieldcat1

it_sort = sortcat1

is_layout = layout_in1

i_save = 'A'

it_events = eventcat1

TABLES

t_outtab = t_line

EXCEPTIONS

OTHERS = 2.

ENDFORM. " START_LIST_VIEWER_item

Total Number when i run detailed list is displayed as 35,608,528.31 and 35,964,566.00-

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 04:45:20 GMT

The Number when i run detailed list is displayed as 35,608,528.31 and 35,964,566.00-

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 04:48:08 GMT

Hi ,

The field DMBTR is having domain WERT7. Try using field or type with domain WERT9 and if you still get same error you can go for even more lenght of domain. just check in SE11 for different options of domain with WERT*.

Regards,

Ganesh.

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 06:28:41 GMT

Hi,

please help me out in getting the field or type with domain WERT9.

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 06:40:22 GMT

Hi,

Why you want field name?

go to WERT9 domain, press where used list button it will give you list of data elements.

You can declare total type <Data element ANY OF BELOW>.

DMHAB_LONG
DMSOL_LONG
ESBTR_EB
ESDMB_EB
FB_ICRC_ADIFF
FB_ICRC_DFOSP
FB_ICRC_DLOPP
FB_ICRC_DPREV
FC_ADDCO
FC_BKVAL
FC_COGMT
FC_HSL_C
FC_HSL_D
FC_KSL_C
FC_KSL_D
FC_LCVALIE
FC_NV2LC
FC_NV3LC
FC_VLC_EQ
FC_VLC_INV
FC_VRC_INV
ICRC_DAMNT
ICRC_GDIFF
ICRC_PAMNT
ICRC_TAMNT
ICRC_TDIFF
J_1IADDVAL
J_3RFBPR1
J_3RFBSM
J_3RFDELTAPRICE
J_3RFESM
J_3RFINSUM
J_3RFINSUMDOC
J_3RFISSVAL

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 06:45:50 GMT

Hi,

Use this,


DATA: LV TYPE J_3RFINSUM.

Regards,

Danish.

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 07:30:04 GMT

I have changed the field type but still dump is coming

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 08:28:57 GMT

Hi,

Are you using the SUM operation?

If yes, this statement tries to subtotal ALL the numeric fields of your table... The exception can be raised for another field that the one you changed... Please check them all.

Kr,

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 08:31:31 GMT

Hi,

Please paste the code of the field catalog of that column on which you want to provide summation.

Regards,

Danish.

Re: SUM_OVERFLOW DUMP

deepak_dhamat — Mon, 03 Oct 2011 08:32:11 GMT

Hi ,

Change fiedl Type with Type p decimals 2 .

regards

Deepak.

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 08:50:32 GMT

I have changed the field to TYPE P Decimals 2 but It not resolved showing the same dump

It showing correctly for 5 or 6 lifnr, but when i tried to get large data it's throwing the SUM OVERFLOW Dump

Here's the code for field catalog

FORM write_list .

DATA :

tot TYPE p DECIMALS 2,

tot1 TYPE p DECIMALS 2,

tot2 TYPE p DECIMALS 2,

tot3 TYPE p DECIMALS 2,

tot4 TYPE p DECIMALS 2,

tot5 TYPE p DECIMALS 2,

tot6 TYPE p DECIMALS 2,

tot7 TYPE p DECIMALS 2,

totn TYPE p DECIMALS 2,

totn6 TYPE p DECIMALS 2,

totn66 TYPE p DECIMALS 2,

name1(40).

DATA : BEGIN OF name OCCURS 100,

lifnr LIKE lfa1-lifnr,

name1 LIKE lfa1-name1,

END OF name.

DELETE itab WHERE total = 0.

SORT itab BY lifnr.

SELECT lifnr name1 FROM lfa1 INTO TABLE name

FOR ALL ENTRIES IN itab

WHERE lifnr = itab-lifnr.

DELETE ADJACENT DUPLICATES FROM name COMPARING lifnr name1.

LOOP AT itab.

AT NEW lifnr.

READ TABLE name WITH KEY lifnr = itab-lifnr.

IF sy-subrc = 0.

itab-name1 = name-name1.

MODIFY itab TRANSPORTING name1.

ENDIF.

SUM.

WRITE 😕 itab-lifnr NO-GAP, sy-vline NO-GAP,

(35) itab-name1 NO-GAP, sy-vline NO-GAP,

(20) itab-total NO-GAP, sy-vline NO-GAP ,

(20) itab-notdue NO-GAP, sy-vline NO-GAP ,

(20) itab-notdue6 NO-GAP, sy-vline NO-GAP ,

(20) itab-notdue66 NO-GAP, sy-vline NO-GAP ,

(20) itab-age2 NO-GAP, sy-vline NO-GAP,

(20) itab-age3 NO-GAP, sy-vline NO-GAP,

(20) itab-age4 NO-GAP, sy-vline NO-GAP,

(20) itab-age5 NO-GAP, sy-vline NO-GAP,

(20) itab-agen NO-GAP, sy-vline NO-GAP,

(20) itab-agel NO-GAP, sy-vline NO-GAP.

tot = itab-total + tot.

tot1 = itab-age2 + tot1. tot2 = itab-age3 + tot2.

tot3 = itab-age4 + tot3. tot4 = itab-age5 + tot4.

tot5 = itab-agen + tot5.

tot6 = itab-agel + tot6.

totn = itab-notdue + totn . totn6 = itab-notdue6 + totn6. totn66 = itab-notdue66 + totn66.

ENDAT.

ENDLOOP.

WRITE :/(270) sy-uline NO-GAP,(270) sy-uline.

WRITE :/47 sy-vline,(19) tot NO-GAP COLOR COL_TOTAL, sy-vline NO-GAP,

(19) totn COLOR COL_TOTAL, sy-vline NO-GAP,

(19) totn6 COLOR COL_TOTAL, sy-vline NO-GAP,

(19) totn66 COLOR COL_TOTAL, sy-vline NO-GAP,

(19) tot1 COLOR COL_TOTAL, sy-vline NO-GAP,

(19) tot2 COLOR COL_TOTAL, sy-vline NO-GAP,

(19) tot3 COLOR COL_TOTAL, sy-vline NO-GAP,

(19) tot4 COLOR COL_TOTAL, sy-vline NO-GAP,

(19) tot5 COLOR COL_TOTAL, sy-vline NO-GAP,

(19) tot6 COLOR COL_TOTAL, sy-vline NO-GAP.

ULINE /47(240).

ENDFORM. " WRITE_LIST

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 08:56:29 GMT

Take data type as character.It will solve your problem.

Re: SUM_OVERFLOW DUMP

deepak_dhamat — Mon, 03 Oct 2011 08:58:24 GMT

Hi Nishant ,

You might be using "Sum " statement in your COde :

This SUM will work fine only when it is of type I,F, or P type fields . OTherwise it will give problem in calculation .

SO you have to change type of fields which you have used .

regards

Deepak.

Re: SUM_OVERFLOW DUMP

Former Member — Mon, 03 Oct 2011 09:07:27 GMT

SUM Statement is used, I have tried using TYPE P Decimals 2, but no success

While using type C it still not working.

It showing correctly for 5 or 6 lifnr, but when i tried to get large data it's throwing the SUM OVERFLOW Dump

Re: SUM_OVERFLOW DUMP

deepak_dhamat — Mon, 03 Oct 2011 09:23:11 GMT

Hi Nishant ,

Actually there is no problem in your Code ,

When you are Executing SUM statement .

What it does is It creates work area to store values on sum , and That sum values Goes Beyond length of field

And it cannot store that value so it gives dump .

Better Try to Increase Length of that Field which stores large Value .

Regards

Deepak.