topic Re: ALV Grid display in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alv-grid-display/m-p/8557735#M1658803 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>have sorted your table on BUKRS?</P><P></P><P>refer <A href="http://wiki.sdn.sap.com/wiki/display/Snippets/Display" target="test_blank">http://wiki.sdn.sap.com/wiki/display/Snippets/Display</A><EM>subtotal</EM>text<EM>in</EM>ALV+grid</P><P></P><P>Regards</P><P>Vinit</P></BODY></HTML> Wed, 22 Feb 2012 20:53:18 GMT former_member189779 2012-02-22T20:53:18Z ALV Grid display https://community.sap.com/t5/application-development-and-automation-discussions/alv-grid-display/m-p/8557734#M1658802 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P></P><P>How do I include a text for sub total field on ALV. </P><P></P><P></P><P>I got different columns on ALV which shows count. Want to put a text at the left end of Report for field BUKRS like "State level total" </P><P></P><P>I tried creating SUBTOTAL_TEXT with events and passed it on REUSE_ALV_GRID_DISPLAY for IT_EVENTS. It doesn't works. Not sure what am I missing. </P><P></P><P>Field catalog I created:</P><P></P><P> lw_fieldcat-tabname = 't_out_val'.</P><P> lw_fieldcat-fieldname = 'BUKRS1'.</P><P> lw_fieldcat-seltext_l = 'Company Code'.</P><P> lw_fieldcat-col_Pos = lv_col_pos.</P><P> lw_fieldcat-outputlen = 15.</P><P> APPEND lw_fieldcat TO pi_fieldcat.</P><P> lv_col_pos = +1.</P><P> CLEAR lw_fieldcat.</P><P></P><P></P><P>Event for Subtotal_text:</P><P></P><P>FORM SUB_GET_EVENT .</P><P></P><P>CONSTANTS: c_formname_subtotal_text TYPE slis_formname VALUE 'SUBTOTAL_TEXT'.</P><P></P><P> DATA: l_s_event TYPE slis_alv_event.</P><P></P><P> CALL FUNCTION 'REUSE_ALV_EVENTS_GET'</P><P> EXPORTING</P><P> I_LIST_TYPE = 4</P><P> IMPORTING</P><P> ET_EVENTS = i_event</P><P> EXCEPTIONS</P><P> LIST_TYPE_WRONG = 0</P><P> OTHERS = 0.</P><P></P><P> READ TABLE i_event INTO l_s_event WITH KEY name = slis_ev_subtotal_text.</P><P> IF sy-subrc EQ 0.</P><P> MOVE c_formname_subtotal_text TO l_s_event-form.</P><P> MODIFY i_event FROM l_s_event INDEX sy-tabix.</P><P> ENDIF.</P><P></P><P></P><P>Text for subtotal:</P><P></P><P>FORM subtotal_text CHANGING</P><P> p_total TYPE any</P><P> p_subtot_text TYPE slis_subtot_text.</P><P> IF p_subtot_text-criteria = 'BUKRS1'.</P><P> p_subtot_text-display_text_for_subtotal = 'State level total'.</P><P> ENDIF.</P><P>ENDFORM. "subtotal_text</P><P></P><P>Thanks,</P><P>Francis</P></BODY></HTML> Wed, 22 Feb 2012 20:27:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-grid-display/m-p/8557734#M1658802 Former Member 2012-02-22T20:27:31Z Re: ALV Grid display https://community.sap.com/t5/application-development-and-automation-discussions/alv-grid-display/m-p/8557735#M1658803 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>have sorted your table on BUKRS?</P><P></P><P>refer <A href="http://wiki.sdn.sap.com/wiki/display/Snippets/Display" target="test_blank">http://wiki.sdn.sap.com/wiki/display/Snippets/Display</A><EM>subtotal</EM>text<EM>in</EM>ALV+grid</P><P></P><P>Regards</P><P>Vinit</P></BODY></HTML> Wed, 22 Feb 2012 20:53:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-grid-display/m-p/8557735#M1658803 former_member189779 2012-02-22T20:53:18Z Re: ALV Grid display https://community.sap.com/t5/application-development-and-automation-discussions/alv-grid-display/m-p/8557736#M1658804 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Change your Field catalog a bit and Check with this..</P><P></P><P>lw_fieldcat-fieldname = 'BUKRS'.</P><P>lw_fieldcat-seltext_l = 'Company Code'.</P><P>lw_fieldcat-no_out= 'X'.</P><P>lw_fieldcat-TECH= ' '.</P><P>APPEND lw_fieldcat TO pi_fieldcat.</P><P></P><P></P><P></P><P>Regards,</P><P></P><P>PraVeen..</P></BODY></HTML> Fri, 24 Feb 2012 13:43:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-grid-display/m-p/8557736#M1658804 praveen_reddy2 2012-02-24T13:43:31Z