Skip to Content

The field XXX cannot be totalled because of field overflow

I've got the following message in my ALV grid report:

"The field Hours cannot be totalled because of field overflow

Message no. 0K 051 "

The column reference is to CATSDB-CATSHOURS (QUAN 4/2).

The fieldcatalog is generated the following way:

Code:

METHOD fill_fieldcatalog.

DATA: r_wa_fieldcat TYPE lvc_s_fcat.

*--> CATSDB

CALL FUNCTION 'LVC_FIELDCATALOG_MERGE'

EXPORTING

i_structure_name = 'CATSDB'

i_client_never_display = flagged

CHANGING

ct_fieldcat = r_it_fieldcat.

...

In SE16 I can summarize this field .... but I have no idea why it works there and doesn't in my report.

I found OSS note 435362, it describes the same situation, but we already have the package level mentioned there....so it's not my case.

Any idea?

Thanks in advance,

Incho

Ps:My release is SAP R/3 46C and ALV grid is implemented based on cl_gui_alv_grid.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jan 27, 2004 at 02:15 PM

    Set the fieldlenght to 10 or something like that in the fieldcatalog for th especifiet field (CATSHOURS) ...

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Jakob!

      I've already tried....the lenght was longer in the ALV grid display, but the summary didn't work:-(

      Like this:

      r_wa_fieldcat-dd_outlen = 10.

      I used structure LVC_S_FCAT for fieldcatalog reference.

      Incho

  • Jan 29, 2004 at 03:36 PM

    Probably you get an error only when your total exceeds 9999.99

    Indeed this message appears when arithmetic error occurs in form FB_SUBTOTALS_GET of module pool SKBH:

    catch system-exceptions arithmetic_errors = 5

    conversion_errors = 5.

    ---

    endcatch.

    if sy-subrc = 5.

    ---

    MESSAGE I051(0K) WITH LS_FIELDCAT-SELTEXT.

    endif.

    To avoid this you have to change internal type of your field in catalog, not just then output length. QUAN 4/2 is not enough to store big numbers.

    Add comment
    10|10000 characters needed characters exceeded

    • No solution, but maybe an explanation....

      the fields is a quantity field with reference to a unit.

      Since the unit determines how many decimals are displayed, I could imagine that a "large" can be summarized if the reference to the unit is ignored but fails if it has to be displayed without decimals.

      Just a thought....

      Christian