ALV Fields summing

[Former Member]

I have to correct error in ALV out put. The error is the sum of amount field is not displaying in the ALV out put of particular column . Actually in SAP 4.7 version of the same program, it is summing correctly and displaying at the end of the column of that particular field .

But in 4.6 C it is not displaying. It looks the same code in both 4.6 C and 4.7 as well. Could you please suggest me how to achieve this ? This is very urgent.

Below is the code

ADD 1 TO col_pos.

fieldcat_ln-ref_tabname = ws_table . "You can also use the db tabl

fieldcat_ln-fieldname = ws_fieldname. "name(BSIS) here, but it will

fieldcat_ln-qfieldname = ws_qfieldname.

fieldcat_ln-cfieldname = ws_cfieldname.

fieldcat_ln-key = ws_key. "use the db field name instea

fieldcat_ln-do_sum = ws_sum. "of the name you give in

fieldcat_ln-col_pos = col_pos. "reptext_ddic.

fieldcat_ln-no_out = ws_noout.

fieldcat_ln-hotspot = ws_hotspot.

fieldcat_ln-outputlen = ws_outputlen.

fieldcat_ln-reptext_ddic = ws_ddic.

• fieldcat_In-seltext_s = ws_ddic.

• fieldcat_In-seltext_m = ws_ddic.

APPEND fieldcat_ln TO fieldcat.

********************************

data : pgm like sy-repid.

pgm = sy-repid.

call function 'REUSE_ALV_LIST_DISPLAY'

exporting

i_callback_program = pgm

• I_CALLBACK_PF_STATUS_SET = ' '

• i_callback_user_command = 'USER_COMMAND'

• I_STRUCTURE_NAME = 'DEFERRED ACCOUNTS REC RPT'

• is_layout = lay_out

it_fieldcat = fieldcat

• IT_EXCLUDING =

• IT_SPECIAL_GROUPS =

• it_sort = sortcat

• IT_FILTER =

• IS_SEL_HIDE =

• I_DEFAULT = 'X'

i_save = 'A'

is_variant = g_variant

it_events = eventcat

it_event_exit = gt_event_exit[]

tables

t_outtab = itab_alv

exceptions

program_error = 1

others = 2

.

if sy-subrc <> 0.

message i100(zg) with 'Unable to display ALV due to error'.

stop.

endif.

You help is highly appreciated.

[RichHeilman]

Please try adding this one line.

ADD 1 TO col_pos.
fieldcat_ln-ref_tabname = ws_table . "You can also use the db tabl
fieldcat_ln-fieldname = ws_fieldname. "name(BSIS) here, but it will
fieldcat_ln-qfieldname = ws_qfieldname.
fieldcat_ln-cfieldname = ws_cfieldname.
fieldcat_ln-key = ws_key. "use the db field name instea
fieldcat_ln-do_sum = ws_sum. "of the name you give in
<b>fieldcat_in-datatype = 'QUAN'. "<------ Right Here</b>
fieldcat_ln-col_pos = col_pos. "reptext_ddic.
fieldcat_ln-no_out = ws_noout.
fieldcat_ln-hotspot = ws_hotspot.
fieldcat_ln-outputlen = ws_outputlen.
fieldcat_ln-reptext_ddic = ws_ddic.
* fieldcat_In-seltext_s = ws_ddic.
* fieldcat_In-seltext_m = ws_ddic.

APPEND fieldcat_ln TO fieldcat.

Regards,

Rich Heilman

[Former Member]

I have to correct error in ALV out put. The error is the subtotaling of a field is not displaying in the ALV out put of particular column . Actually in SAP 4.7 version of the same program is working fine. it is doing sub-totaling.

But in 4.6 C it is not displaying. It seems the same code is copied both into 4.6 C and 4.7 as well. Could you please suggest me where to check which field I need to check ? how to achieve this ? This is very urgent.

Below is the code

ADD 1 TO col_pos.

fieldcat_ln-ref_tabname = ws_table . "You can also use the db tabl

fieldcat_ln-fieldname = ws_fieldname. "name(BSIS) here, but it will

fieldcat_ln-qfieldname = ws_qfieldname.

fieldcat_ln-cfieldname = ws_cfieldname.

fieldcat_ln-key = ws_key. "use the db field name instea

fieldcat_ln-do_sum = ws_sum. "of the name you give in

fieldcat_ln-col_pos = col_pos. "reptext_ddic.

fieldcat_ln-no_out = ws_noout.

fieldcat_ln-hotspot = ws_hotspot.

fieldcat_ln-outputlen = ws_outputlen.

fieldcat_ln-reptext_ddic = ws_ddic.

• fieldcat_In-seltext_s = ws_ddic.

• fieldcat_In-seltext_m = ws_ddic.

APPEND fieldcat_ln TO fieldcat.

********************************

data : pgm like sy-repid.

pgm = sy-repid.

call function 'REUSE_ALV_LIST_DISPLAY'

exporting

i_callback_program = pgm

• I_CALLBACK_PF_STATUS_SET = ' '

• i_callback_user_command = 'USER_COMMAND'

• I_STRUCTURE_NAME = 'DEFERRED ACCOUNTS REC RPT'

• is_layout = lay_out

it_fieldcat = fieldcat

• IT_EXCLUDING =

• IT_SPECIAL_GROUPS =

• it_sort = sortcat

• IT_FILTER =

• IS_SEL_HIDE =

• I_DEFAULT = 'X'

i_save = 'A'

is_variant = g_variant

it_events = eventcat

it_event_exit = gt_event_exit[]

tables

t_outtab = itab_alv

exceptions

program_error = 1

others = 2

[Former Member]

Hi sam,

I think the column is not Numeric,may be its CHAR.

change it to Numeric..

[Former Member]

It is neither numeric nor char field .

It is CURR field.

The problem is in 4.7 SAP system ...it is doing subtotaling and is working fine .

and the same program is copied to 4.6C...and in 4.6C it is not showing subtotaling.

THIS IS VERY URGENT .

COULD ANY BODY RESPOND SOON.

YOUR HELP WILL BE HIGHLY APPRECIATED.

THANKS IN ADVANCE

[Former Member]

Hi,

If you want to do the sub totaling..You should have a sort order for the field which you want to have a sub-total..And in the field catalog internal table for the the corresponding CURR make the DO_SUM = 'X'.

DATA: T_SORT TYPE SLIS_T_SORTINFO_ALV.

DATA: S_SORT TYPE SLIS_SORTINFO_ALV.

S_SORT-SPOS = '1'.

S_SORT-FIELDNAME = 'VBELN'. "Sales order #

S_SORT-UP = 'X'.

APPEND S_SORT TO T_SORT..

Thanks,

Naren