topic alv header list in Application Development and Automation Discussions

topic alv header list in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910653#M379107 <HTML><HEAD></HEAD><BODY><P>in the alv report for displaying the header data i have written my coding as</P><P></P><P>FORM E04_COMMENT_BUILD USING E04_LT_TOP_OF_PAGE TYPE SLIS_T_LISTHEADER.</P><P></P><P> DATA: LS_LINE TYPE SLIS_LISTHEADER.</P><P></P><P> CLEAR LS_LINE.</P><P> LS_LINE-TYP = 'S'.</P><P></P><P></P><P></P><P> LS_LINE-KEY = 'Payer'.</P><P> LS_LINE-INFO = gt_header_table-kunnr.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Compamy Code'.</P><P> LS_LINE-INFO = gt_header_table-bukrs.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Name'.</P><P> LS_LINE-INFO = it_h_kna1-name1.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'City'.</P><P> LS_LINE-INFO = it_h_kna1-ort01.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'State'.</P><P> LS_LINE-INFO = it_h_kna1-regio.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Telephone Number'.</P><P> LS_LINE-INFO = it_h_kna1-telf1.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Fax Number'.</P><P> LS_LINE-INFO = it_h_kna1-telfx.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Sales Group'.</P><P> LS_LINE-INFO = it_vbrp-vkgrp.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P>ENDFORM.</P><P></P><P></P><P>and for sorting by company code and for customer number i have written as</P><P></P><P>FORM IT_SORT.</P><P></P><P>clear wa_sort.</P><P> wa_sort-spos = 1.</P><P> wa_sort-fieldname = 'BUKRS'.</P><P> wa_sort-up = 'X'.</P><P> wa_sort-group = '* '.</P><UL><LI level="1" type="ul"><P> wa_sort-group = 'UL'.</P></LI></UL><P> append wa_sort to it_u_sort.</P><P> clear wa_sort.</P><P> wa_sort-spos = 2.</P><P> wa_sort-fieldname = 'KUNNR'.</P><P> wa_sort-up = 'X'.</P><P> wa_sort-subtot = 'X'.</P><P> wa_sort-group = '* '.</P><UL><LI level="1" type="ul"><P> wa_sort-group = 'UL'.</P></LI></UL><P> append wa_sort to it_u_sort.</P><P> clear wa_sort.</P><P>ENDFORM. " IT_SORT</P><P></P><P></P><P></P><P>my problem is in my header data the data s not getting refreshed for example if am giving customer in the input as 1 and in the company code input as 1000 and 1200 in my report the company code is getting populated only by 1200,plant 1000 is not getting displayed where am i going wrong</P></BODY></HTML> Tue, 20 Feb 2007 06:39:09 GMT Former Member 2007-02-20T06:39:09Z alv header list https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910653#M379107 <HTML><HEAD></HEAD><BODY><P>in the alv report for displaying the header data i have written my coding as</P><P></P><P>FORM E04_COMMENT_BUILD USING E04_LT_TOP_OF_PAGE TYPE SLIS_T_LISTHEADER.</P><P></P><P> DATA: LS_LINE TYPE SLIS_LISTHEADER.</P><P></P><P> CLEAR LS_LINE.</P><P> LS_LINE-TYP = 'S'.</P><P></P><P></P><P></P><P> LS_LINE-KEY = 'Payer'.</P><P> LS_LINE-INFO = gt_header_table-kunnr.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Compamy Code'.</P><P> LS_LINE-INFO = gt_header_table-bukrs.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Name'.</P><P> LS_LINE-INFO = it_h_kna1-name1.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'City'.</P><P> LS_LINE-INFO = it_h_kna1-ort01.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'State'.</P><P> LS_LINE-INFO = it_h_kna1-regio.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Telephone Number'.</P><P> LS_LINE-INFO = it_h_kna1-telf1.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Fax Number'.</P><P> LS_LINE-INFO = it_h_kna1-telfx.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P> LS_LINE-KEY = 'Sales Group'.</P><P> LS_LINE-INFO = it_vbrp-vkgrp.</P><P> APPEND LS_LINE TO E04_LT_TOP_OF_PAGE.</P><P></P><P>ENDFORM.</P><P></P><P></P><P>and for sorting by company code and for customer number i have written as</P><P></P><P>FORM IT_SORT.</P><P></P><P>clear wa_sort.</P><P> wa_sort-spos = 1.</P><P> wa_sort-fieldname = 'BUKRS'.</P><P> wa_sort-up = 'X'.</P><P> wa_sort-group = '* '.</P><UL><LI level="1" type="ul"><P> wa_sort-group = 'UL'.</P></LI></UL><P> append wa_sort to it_u_sort.</P><P> clear wa_sort.</P><P> wa_sort-spos = 2.</P><P> wa_sort-fieldname = 'KUNNR'.</P><P> wa_sort-up = 'X'.</P><P> wa_sort-subtot = 'X'.</P><P> wa_sort-group = '* '.</P><UL><LI level="1" type="ul"><P> wa_sort-group = 'UL'.</P></LI></UL><P> append wa_sort to it_u_sort.</P><P> clear wa_sort.</P><P>ENDFORM. " IT_SORT</P><P></P><P></P><P></P><P>my problem is in my header data the data s not getting refreshed for example if am giving customer in the input as 1 and in the company code input as 1000 and 1200 in my report the company code is getting populated only by 1200,plant 1000 is not getting displayed where am i going wrong</P></BODY></HTML> Tue, 20 Feb 2007 06:39:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910653#M379107 Former Member 2007-02-20T06:39:09Z Re: alv header list https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910654#M379108 <HTML><HEAD></HEAD><BODY><P>Refer this for Sorting</P><P></P><P>Hi,</P><P></P><P>Dont clear sales order, keep it and in ALV if u use sort by sales order then item u will get as u expect.</P><P></P><P> </P><PRE><CODE> DATA: wa_sortinfo TYPE slis_sortinfo_alv. i_sortcat TYPE slis_t_sortinfo_alv. CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_callback_program = report_id i_grid_title = ws_title * i_callback_top_of_page = 'TOP-OF-PAGE' is_layout = wa_layout it_fieldcat = i_fieldcat[] it_sort = i_sortcat i_save = 'A' it_events = i_events TABLES t_outtab = i_reportdata1 EXCEPTIONS program_error = 1 OTHERS = 2. IF sy-subrc <> 0. * MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF. PERFORM sortcat_init CHANGING i_sortcat. FORM sortcat_init CHANGING i_sortcat TYPE slis_t_sortinfo_alv. CLEAR wa_sortinfo. wa_sortinfo-fieldname = 'EBELN'. (sales order) wa_sortinfo-tabname = 'I_REPORTDATA1'. (specify the output table name) wa_sortinfo-spos = 1. " First sort by this field. wa_sortinfo-up = 'X'. " Ascending wa_sortinfo-subtot = 'X'. " Subtotal at Name1 APPEND wa_sortinfo TO i_sortcat. CLEAR wa_sortinfo. wa_sortinfo-fieldname = 'EBELP'. wa_sortinfo-tabname = 'I_REPORTDATA1'. wa_sortinfo-spos = 2. " Sec sort by this field. wa_sortinfo-up = 'X'. " Ascending wa_sortinfo-subtot = 'X'. " Subtotal at Name1 APPEND wa_sortinfo TO i_sortcat. ENDFORM. " sortcat_init</CODE></PRE><P></P><P><A href="http://www.sapdevelopment.co.uk/reporting/alv/alvgrid_rephead.htm" target="test_blank">http://www.sapdevelopment.co.uk/reporting/alv/alvgrid_rephead.htm</A></P></BODY></HTML> Tue, 20 Feb 2007 06:46:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910654#M379108 Former Member 2007-02-20T06:46:33Z Re: alv header list https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910655#M379109 <HTML><HEAD></HEAD><BODY><P>if u have to 2 entries or 2 values ,in that case u have to concatenate these 2 values.</P><P></P><P><b> fheader-typ = 'S'.</P><P> fheader-key = 'Date'.</P><P> write s_budat-low to w_low.</P><P> write s_budat-high to w_high.</P><P></P><P> concatenate w_low ' - ' w_high into fheader-info.</P><P> append fheader.</b></P><P></P><P>regards</P><P>Prabhu</P></BODY></HTML> Tue, 20 Feb 2007 06:48:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910655#M379109 Former Member 2007-02-20T06:48:04Z Re: alv header list https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910656#M379110 <HTML><HEAD></HEAD><BODY><P>if suppose i give multiple entries in low range itself</P></BODY></HTML> Tue, 20 Feb 2007 07:08:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910656#M379110 Former Member 2007-02-20T07:08:49Z Re: alv header list https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910657#M379111 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>if u have to 2 entries or 2 values ,in that case u have to concatenate these 2 values.</P><P></P><P>fheader-typ = 'S'.</P><P>fheader-key = 'Date'.</P><P>write s_budat-low to w_low.</P><P>write s_budat-high to w_high.</P><P></P><P>concatenate w_low ' - ' w_high into fheader-info.</P><P>append fheader.</P><P></P><P>Once you was used the data please make sure that you have to clear that data.</P><P>For example here you have to</P><P>clear fheader.</P><P></P><P>Regards,</P><P>kumar</P></BODY></HTML> Tue, 20 Feb 2007 07:10:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910657#M379111 sreeramkumar_madisetty 2007-02-20T07:10:42Z Re: alv header list https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910658#M379112 <HTML><HEAD></HEAD><BODY><P>Hi Lakshmi,,</P><P>data:begin of it_bukrs occurs 0,</P><P> bukrs(4),</P><P> end of it_bukrs.</P><P></P><P>data: v_bukrs(40). </P><P></P><P>select bukrs from t001 into it_bukrs where bukrs in so_bukrs.</P><P></P><P>loop at it_bukrs.</P><P>concatenate v_bukrs it_bukrs-bukrs into v_bukrs.</P><P>endloop.</P><P></P><P>finally in the header u display the v_bukrs...Please keep in mind that u have limitation on the length which u can display....</P></BODY></HTML> Tue, 20 Feb 2007 10:12:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-header-list/m-p/1910658#M379112 Former Member 2007-02-20T10:12:11Z