Total Field in ALV Grid

[Former Member]

Can i change the values in total column in ALV Grid program. I had made one report with 3 hirerchy level and for first hirerchy i need different total values just for one column as total values are misleading the users. is it possible to change the value total field in ALV?

[hymavathi_oruganti · Accepted solution]

u put

refresh_table_display

immediately after calculating total in data_changed.

u can see the total changing

[Former Member · Accepted solution]

thanks for replying my query where shall i put refresh_table_display and what is data_changed?

[hymavathi_oruganti · Accepted solution]

hi

make the fields for which u r displaying total as editable.

so when ever u make changes in the column,

see the sample code, i have done a similar program

FORM DATA_CHANGED_MATRIX USING P_ER_DATA_CHANGED TYPE REF TO

CL_ALV_CHANGED_DATA_PROTOCOL P_ONF4 type C E_UCOMM TYPE SY-UCOMM.

DATA: VALUE LIKE YRECORDINGD_QDMS-SCORE.

CLEAR VALUE.

data: begin of wa_tot,

TOTAL_SCORE like yrecordingd_qdms-score,

end of wa_tot.

DATA: BEGIN OF WA_DATA,

SRNO type i,

LOCATION LIKE YCONCERNS_QDMS-LOCATION,

LOC_DESC LIKE YLOCATION_QDMST-LOC_DESC,

TOTAL_SCORE LIKE YRECORDINGD_QDMS-SCORE,

END OF WA_DATA.

FIELD-SYMBOLS: <LS_VALUE1> TYPE ANY,

<LS_VALUE2> TYPE ANY.

DATA: L_VALUE TYPE LVC_VALUE,

ls_mod_cell type lvc_s_modi.

SORT P_ER_DATA_CHANGED->MT_MOD_CELLS BY ROW_ID.

LOOP AT P_ER_DATA_CHANGED->MT_MOD_CELLS INTO LS_MOD_CELL.

CALL METHOD P_ER_DATA_CHANGED->GET_CELL_VALUE

EXPORTING

I_ROW_ID = LS_MOD_CELL-row_id

I_FIELDNAME = LS_MOD_CELL-fieldname

IMPORTING

E_VALUE = L_VALUE.

VALUE = L_VALUE.

IF VALUE < 100.

READ TABLE <TEMP_TAB> INTO <TEMP_WA> INDEX LS_MOD_CELL-ROW_ID.

MOVE-CORRESPONDING <TEMP_WA> TO WA_TOT.

WA_TOT-TOTAL_SCORE = WA_TOT-TOTAL_SCORE + VALUE.

MOVE-CORRESPONDING WA_TOT TO <TEMP_WA>.

MODIFY <TEMP_TAB> FROM <TEMP_WA> INDEX LS_MOD_CELL-ROW_ID.

CALL METHOD GO_GRID->REFRESH_TABLE_DISPLAY.

ELSE.

CLEAR WA_DATA.

ENDIF.

CLEAR:WA_TOT,VALUE.

ENDLOOP.

ENDFORM.

[Former Member · Accepted solution]

Thanks again for replying. Problem solved.. thanks