topic ALV report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073728#M728768 <HTML><HEAD></HEAD><BODY><P>Hi, Please help me out in this regard</P><P>when i m displaying alv output i m getting the output but i couldnot see the heading of that field. Please let me know thw solution</P><P> regards.</P><P> Raj</P></BODY></HTML> Wed, 21 Nov 2007 05:41:11 GMT Former Member 2007-11-21T05:41:11Z ALV report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073728#M728768 <HTML><HEAD></HEAD><BODY><P>Hi, Please help me out in this regard</P><P>when i m displaying alv output i m getting the output but i couldnot see the heading of that field. Please let me know thw solution</P><P> regards.</P><P> Raj</P></BODY></HTML> Wed, 21 Nov 2007 05:41:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073728#M728768 Former Member 2007-11-21T05:41:11Z Re: ALV report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073729#M728769 <HTML><HEAD></HEAD><BODY><P>domain level do not maintain label so it si not display.</P><P></P><P>it can pass manually alv header text.</P><P></P><P></P><P>see fieldcatlog.</P><P></P><P>SAP Certification, Functional, Basis Administration and ABAP Programming Reference Books</P><P>Sample programs on ALV Grid </P><P>report zbnstest. </P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><LI level="1" type="ul"><P>TABLES AND DATA DECLARATION. </P></LI><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P>*TABLES: mara,makt.",marc. </P><P>data syrepid like sy-repid. </P><P>data sydatum(10). " LIKE sy-datum. </P><P>data sypagno(3) type n. </P><P> </P><P></P><UL><LI level="1" type="ul"><P>WHEN USING MORE THAN ONE TABLE IN ALV WE NEEED TO DECLARE THE TYPE </P></LI><LI level="1" type="ul"><P>GROUP (TYPE-POOLS---------&gt;SLIS) </P></LI></UL><P>type-pools : slis. </P><P> </P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><LI level="1" type="ul"><P>INTERNAL TABLE DECLARATION. </P></LI><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><LI level="1" type="ul"><P>INTERNAL TABLE TO HOLD THE VALUES FROM THE MARA TABLE </P></LI></UL><P>data: begin of t_mara occurs 0, </P><P>matnr like mara-matnr, </P><P>meins like mara-meins, </P><P>mtart like mara-mtart, </P><P>matkl like mara-matkl, </P><P></P><P>end of t_mara. </P><P></P><UL><LI level="1" type="ul"><P>INTERNAL TABLE TO HOLD THE CONTENTS FROM THE EKKO TABLE </P></LI></UL><P>data : begin of t_marc occurs 0, </P><P>matnr like mara-matnr, </P><P>werks like marc-werks, </P><P>minbe like marc-minbe. </P><P>data: end of t_marc. </P><P></P><UL><LI level="1" type="ul"><P>INTERNAL TABLE TO HOLD THE VALUES FROM MAKT TABLE. </P></LI></UL><P>data : begin of t_makt occurs 0, </P><P>matnr like mara-matnr, </P><P>maktx like makt-maktx, </P><P>spras like makt-spras, </P><P>end of t_makt. </P><P></P><UL><LI level="1" type="ul"><P>INTERNAL TABLE WHICH ACTUALLY MERGES ALL THE OTHER INTERNAL TABLES. </P></LI></UL><P>data: begin of itab1 occurs 0, </P><P>matnr like mara-matnr, </P><P>meins like mara-meins, </P><P>maktx like makt-maktx, </P><P>spras like makt-spras, </P><P>werks like marc-werks, </P><P>minbe like marc-minbe, </P><P>end of itab1. </P><P> </P><P></P><UL><LI level="1" type="ul"><P>THE FOLLOWING DECLARATION IS USED FOR DEFINING THE FIELDCAT </P></LI><LI level="1" type="ul"><P>AND THE LAYOUT FOR THE ALV. </P></LI><LI level="1" type="ul"><P>HERE AS slis_t_fieldcat_alv IS A INTERNAL TABLE WITHOUT A HEADER LINE </P></LI><LI level="1" type="ul"><P>WE EXPLICITELY DEFINE AN INTERNAL TABLE OF THE SAME STRUCTURE AS THAT </P></LI><LI level="1" type="ul"><P>OF slis_t_fieldcat_alv BUT WITH A HEADER LINE IN THE DEFINITION. </P></LI><LI level="1" type="ul"><P>THIS IS DONE TO MAKE THE CODE SIMPLER. </P></LI><LI level="1" type="ul"><P>OTHERWISE WE MAY HAVE TO DEFINE THE STRUCTURE AS IN THE NORMAL SAP </P></LI><LI level="1" type="ul"><P>PROGRAMS. </P></LI><LI level="1" type="ul"><P>IN THE FIELDCATALOG TABLE WE ACTUALLY PASS THE FIELDS FROM ONE OR </P></LI><LI level="1" type="ul"><P>MORE TABLES AND CREATE A STRUCTURE </P></LI><LI level="1" type="ul"><P>IN THE LAYOUT STRUCTURE WE BASICALLY DEFINE THE FORMATTING OPTIONS </P></LI><LI level="1" type="ul"><P>LIKE DISPLAY IN THE ZEBRA PATTERN ,THE HOTSPOT OPTIONS ETC. </P></LI></UL><P>data: fieldcatalog type slis_t_fieldcat_alv with header line, </P><P>fieldlayout type slis_layout_alv. </P><P> </P><P></P><UL><LI level="1" type="ul"><P>DECLARING THE EVENTTABLE INTERNL TABLE FOR USING EVENTS LIKE </P></LI><LI level="1" type="ul"><P>TOP-OF-PAGE ETC. </P></LI></UL><P>data : eventstab type slis_t_event with header line. </P><P></P><UL><LI level="1" type="ul"><P>DECLARING AN INTERNAL TABLE TO HOLD THE DATA FOR THE TOP-OF-PAGE </P></LI></UL><P>data : heading type slis_t_listheader with header line. </P><P>data : heading1 type slis_t_listheader with header line. </P><P>data : heading2 type slis_t_listheader with header line. </P><P>data : heading3 type slis_t_listheader with header line. </P><P>data : heading4 type slis_t_listheader with header line. </P><P>data : heading5 type slis_t_listheader with header line. </P><P>data : heading6 type slis_t_listheader with header line. </P><P>data : heading7 type slis_t_listheader with header line. </P><P>data : heading8 type slis_t_listheader with header line. </P><P> </P><P></P><UL><LI level="1" type="ul"><P>STRUCTURE TO PASS THE COLOR ATTRIBUTES FOR DISPLAY. </P></LI></UL><P>data : colorstruct type slis_coltypes. </P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><LI level="1" type="ul"><P>INITIALIZATION. * </P></LI><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P>initialization. </P><P>syrepid = sy-repid. </P><P>sypagno = sy-pagno. </P><P>clear fieldcatalog. </P><P> </P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><LI level="1" type="ul"><P>START-OF-SELECTION. * </P></LI><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P>start-of-selection. </P><UL><LI level="1" type="ul"><P>SUBROUTINE TO POPULATE THE COLORSTRUCT </P></LI></UL><P>perform fill_colorstruct using colorstruct. </P><UL><LI level="1" type="ul"><P>SUBROUTINE TO POPULATE THE FIELDS OF THE FIELD CATALOGUE </P></LI></UL><P>perform populate_fieldcatalog. </P><UL><LI level="1" type="ul"><P>SUBROUTINE TO SELECT DATA FROM VARIOUS TABLES AND POPULATE IT IN THE </P></LI><LI level="1" type="ul"><P>INTERNAL TABLE. </P></LI></UL><P>perform selectdata_and_sort. </P><UL><LI level="1" type="ul"><P>SUBROUTINE TO POPULATE THE LAYOUT STRUCTURE. </P></LI></UL><P>perform populate_layout using fieldlayout. </P><UL><LI level="1" type="ul"><P>SUBROUTINE TO CALL THE FUNCTION MERGE TO ENSURE PROPER DISPLAY. </P></LI></UL><P>perform merge_fieldcatalog. </P><UL><LI level="1" type="ul"><P>SUBROUTINE TO POPULATE THE EVENTSTAB. </P></LI></UL><P>perform fill_eventstab tables eventstab. </P><UL><LI level="1" type="ul"><P>SUBROUTINE TO POPULATE THE HEADING TABLES. </P></LI></UL><P>perform fill_headingtable tables heading using 'HEADING'. </P><P>perform fill_headingtable tables heading1 using 'HEADING1'. </P><P>perform fill_headingtable tables heading2 using 'HEADING2'. </P><P>perform fill_headingtable tables heading3 using 'HEADING3'. </P><P>perform fill_headingtable tables heading4 using 'HEADING4'. </P><P>perform fill_headingtable tables heading5 using 'HEADING5'. </P><P>perform fill_headingtable tables heading6 using 'HEADING6'. </P><P>perform fill_headingtable tables heading7 using 'HEADING7'. </P><P>perform fill_headingtable tables heading8 using 'HEADING8'. </P><P></P><UL><LI level="1" type="ul"><P>SUBROUTINE TO DISPLAY THE LIST. </P></LI></UL><P>perform display_alv_list. </P><P> </P><P> </P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><LI level="1" type="ul"><P>FORMS </P></LI><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="72" type="ul"></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><LI level="1" type="ul"><P>IN THIS SUBROUTINE WE POPULATE THE FIELDCATALOG TABLE WITH THE NAMES </P></LI><LI level="1" type="ul"><P>OF THE TABLE,FIELDNAME,WHETHER IT IS KEY FIELD OR NOT,HEADING AND </P></LI><LI level="1" type="ul"><P>COLUMN JUSTIFICATION. </P></LI></UL><P>form populate_fieldcatalog. </P><P>perform fill_fields_of_fieldcatalog tables fieldcatalog </P><P>using 'ITAB1' 'MATNR' 'X' . </P><P>perform fill_fields_of_fieldcatalog tables fieldcatalog </P><P>using 'ITAB1' 'MEINS' ' '. </P><P>perform fill_fields_of_fieldcatalog tables fieldcatalog </P><P>using 'ITAB1' 'MAKTX' ' ' . </P><P>perform fill_fields_of_fieldcatalog tables fieldcatalog </P><P>using 'ITAB1' 'MTART' ' ' . </P><P>perform fill_fields_of_fieldcatalog tables fieldcatalog </P><P>using 'ITAB1' 'MATKL' ' ' . </P><P>perform fill_fields_of_fieldcatalog tables fieldcatalog </P><P>using 'ITAB1' 'SPRAS' ' ' . </P><P>perform fill_fields_of_fieldcatalog tables fieldcatalog </P><P>using 'ITAB1' 'WERKS' ' ' . </P><P>perform fill_fields_of_fieldcatalog tables fieldcatalog </P><P>using 'ITAB1' 'MINBE' ' ' . </P><P>endform. " POPULATE_FIELDCATALOG </P><P> </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM FILL_FIELDS_OF_FIELDCATALOG * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>--&gt; FIELDCATALOG * </P></LI><LI level="1" type="ul"><P>--&gt; P_TABNAME * </P></LI><LI level="1" type="ul"><P>--&gt; P_FIELDNAME * </P></LI><LI level="1" type="ul"><P>--&gt; P_KEY * </P></LI><LI level="1" type="ul"><P>--&gt; P_KEY * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form fill_fields_of_fieldcatalog tables fieldcatalog </P><P>structure fieldcatalog </P><P>using p_tabname </P><P>p_fieldname </P><P>p_key. </P><UL><LI level="1" type="ul"><P>p_no_out. </P></LI></UL><P>fieldcatalog-tabname = p_tabname. </P><P>fieldcatalog-fieldname = p_fieldname. </P><P>fieldcatalog-key = p_key. </P><P>fieldcatalog-emphasize = '1234'. </P><P>*fieldcatalog-no_out = p_no_out. </P><P>append fieldcatalog. </P><P>endform. " FILL_FIELDSOFFIELDCATALOG </P><P> </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM POPULATE_LAYOUT * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>--&gt; FIELDLAYOUT * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form populate_layout using fieldlayout type slis_layout_alv. </P><P>fieldlayout-f2code = '&amp;ETA' . </P><P>fieldlayout-zebra = 'X'. </P><UL><LI level="1" type="ul"><P>FOR THE WINDOW TITLE. </P></LI></UL><P>fieldlayout-window_titlebar = 'ALV with Events'. </P><P></P><P>fieldlayout-colwidth_optimize = 'X'. </P><P>fieldlayout-no_vline = ' '. </P><P>*fieldlayout-no_input = 'X'. </P><P>fieldlayout-confirmation_prompt = ''. </P><P>fieldlayout-key_hotspot = 'X'. </P><UL><LI level="1" type="ul"><P>This removes the column headings if the flag is set to 'X' </P></LI></UL><P>fieldlayout-no_colhead = ' '. </P><P>*fieldlayout-hotspot_fieldname = 'MAKTX'. </P><P>fieldlayout-detail_popup = 'X'. </P><UL><LI level="1" type="ul"><P>fieldlayout-coltab_fieldname = 'X'. </P></LI></UL><P>endform. " POPULATE_LAYOUT </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM SELECTDATA_AND_SORT * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form selectdata_and_sort. </P><P>select matnr meins mtart matkl from mara </P><P>into corresponding fields of t_mara </P><P>up to 500 rows . </P><P></P><P>select matnr maktx spras from makt </P><P>into corresponding fields of t_makt </P><P>where matnr = t_mara-matnr and </P><P>spras = sy-langu. </P><P></P><P>select matnr werks minbe from marc </P><P>into corresponding fields of t_marc </P><P>where matnr = t_mara-matnr. </P><P>append t_marc. </P><P>endselect. </P><P>append t_makt. </P><P>endselect. </P><P>append t_mara. </P><P>endselect. </P><P>perform populate_itab1. </P><P>sort itab1 by matnr. </P><P>endform. " SELECTDATA_AND_SORT </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM MERGE_FIELDCATALOG * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form merge_fieldcatalog. </P><P>call function 'REUSE_ALV_FIELDCATALOG_MERGE' </P><P>exporting </P><P>i_program_name = syrepid </P><P>i_internal_tabname = 'ITAB1' </P><UL><LI level="1" type="ul"><P>i_structure_name = 'COLORSTRUCT' </P></LI><LI level="1" type="ul"><P>I_CLIENT_NEVER_DISPLAY = 'X' </P></LI></UL><P>i_inclname = syrepid </P><P>changing </P><P>ct_fieldcat = fieldcatalog[] </P><P>exceptions </P><P>inconsistent_interface = 1 </P><P>program_error = 2 </P><P>others = 3. </P><P>endform. " MERGE_FIELDCATALOG </P><P> </P><P></P><UL><LI level="1" type="ul"><P>IN THIS FUNCTION THE MINIMUM PARAMETERS THAT WE NEED TO PASS IS AS </P></LI><LI level="1" type="ul"><P>FOLLOWS:- </P></LI><LI level="1" type="ul"><P>i_callback_program --&gt; CALLING PROGRAM NAME </P></LI><LI level="1" type="ul"><P>i_structure_name --&gt; STRUCTURE NAME. </P></LI><LI level="1" type="ul"><P>is_layout --&gt; LAYOUT NAME. </P></LI><LI level="1" type="ul"><P>it_fieldcat ---&gt; BODY OF THE FIELD CATALOGUE INTERNAL TABLE </P></LI></UL><P>form display_alv_list. </P><P>call function 'REUSE_ALV_LIST_DISPLAY' </P><P>exporting </P><UL><LI level="1" type="ul"><P>I_INTERFACE_CHECK = ' ' </P></LI></UL><P>i_callback_program = syrepid </P><UL><LI level="1" type="ul"><P>I_CALLBACK_PF_STATUS_SET = ' ' </P></LI><LI level="1" type="ul"><P>I_CALLBACK_USER_COMMAND = ' ' </P></LI></UL><P>i_structure_name = 'ITAB1' </P><P>is_layout = fieldlayout </P><P>it_fieldcat = fieldcatalog[] </P><UL><LI level="1" type="ul"><P>IT_EXCLUDING = </P></LI><LI level="1" type="ul"><P>IT_SPECIAL_GROUPS = </P></LI><LI level="1" type="ul"><P>IT_SORT = </P></LI><LI level="1" type="ul"><P>IT_FILTER = </P></LI><LI level="1" type="ul"><P>IS_SEL_HIDE = </P></LI><LI level="1" type="ul"><P>I_DEFAULT = 'X' </P></LI><LI level="1" type="ul"><P>THE FOLLOWING PARAMETER IS SET AS 'A' INORDER TO DISPLAY THE STANDARD </P></LI><LI level="1" type="ul"><P>TOOL BAR </P></LI></UL><P>i_save = 'A' </P><UL><LI level="1" type="ul"><P>IS_VARIANT = ' ' </P></LI></UL><P>it_events = eventstab[] </P><UL><LI level="1" type="ul"><P>IT_EVENT_EXIT = </P></LI><LI level="1" type="ul"><P>IS_PRINT = </P></LI><LI level="1" type="ul"><P>I_SCREEN_START_COLUMN = 0 </P></LI><LI level="1" type="ul"><P>I_SCREEN_START_LINE = 0 </P></LI><LI level="1" type="ul"><P>I_SCREEN_END_COLUMN = 0 </P></LI><LI level="1" type="ul"><P>I_SCREEN_END_LINE = 0 </P></LI><LI level="1" type="ul"><P>IMPORTING </P></LI><LI level="1" type="ul"><P>E_EXIT_CAUSED_BY_CALLER = </P></LI><LI level="1" type="ul"><P>ES_EXIT_CAUSED_BY_USER = </P></LI></UL><P>tables </P><P>t_outtab = itab1 </P><P>exceptions </P><P>program_error = 1 </P><P>others = 2. </P><P>endform. " DISPLAY_ALV_LIST </P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>*&amp; Form POPULATE_ITAB1 </P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>text </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>--&gt; p1 text </P></LI><LI level="1" type="ul"><P>&lt;-- p2 text </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /> <P></P><P>form populate_itab1. </P><P>loop at t_mara. </P><P>loop at t_makt where matnr = t_mara-matnr. </P><P>loop at t_marc where matnr = t_mara-matnr. </P><P>move-corresponding t_mara to itab1. </P><P>move-corresponding t_makt to itab1. </P><P>move-corresponding t_marc to itab1. </P><P>append itab1. </P><P>endloop. </P><P>endloop. </P><P>endloop. </P><P>endform. " POPULATE_ITAB1 </P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>*&amp; Form FILL_EVENTSTAB </P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>text </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>--&gt;P_EVENTSTAB text * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /> <P></P><P>form fill_eventstab tables p_eventstab structure eventstab. </P><UL><LI level="1" type="ul"><P>WHEN THE FOLLOWING FUNCTION IS CALLED THE SYSTEM POPULATES THE </P></LI><LI level="1" type="ul"><P>INTERNAL TABLE EVENTSTAB WITH A LIST OF EVENTS NAME. </P></LI><LI level="1" type="ul"><P>AS SHOWN BELOW WHEN USING I_LIST_TYPE = 0 THE FUNCTION RETURNS 14 </P></LI><LI level="1" type="ul"><P>EVENTS NAME. </P></LI></UL><P>call function 'REUSE_ALV_EVENTS_GET' </P><P>exporting </P><P>i_list_type = 0 </P><P>importing </P><P>et_events = p_eventstab[] </P><P>exceptions </P><P>list_type_wrong = 1 </P><P>others = 2. </P><P></P><UL><LI level="1" type="ul"><P>BY CALLING THE ABOVE FUNCTION WE FIRST POPULATE THE EVENTSTAB WITH </P></LI><LI level="1" type="ul"><P>THE PREDEFINED EVENTS AND THEN WE MOVE THE FORM NAME AS SHOWN BELOW. </P></LI><LI level="1" type="ul"><P>WE ASSIGN A FORM NAME TO THE EVENT AS REQUIRED BY THE USER. </P></LI><LI level="1" type="ul"><P>FORM NAME CAN BE ANYTHING.THE PERFORM STATEMENT FOR THIS FORM </P></LI><LI level="1" type="ul"><P>IS DYNAMICALY CALLED. </P></LI></UL><P></P><P>read table p_eventstab with key name = slis_ev_top_of_page. </P><P>if sy-subrc = 0 . </P><P>move 'TOP_OF_PAGE' to p_eventstab-form. </P><P>append p_eventstab. </P><P>endif. </P><P></P><P>read table p_eventstab with key name = slis_ev_top_of_coverpage. </P><P>if sy-subrc = 0 . </P><P>move 'TOP_OF_COVERPAGE' to p_eventstab-form. </P><P>append p_eventstab. </P><P>endif. </P><P></P><P>read table p_eventstab with key name = slis_ev_end_of_coverpage . </P><P>if sy-subrc = 0 . </P><P>move 'END_OF_COVERPAGE' to p_eventstab-form. </P><P>append p_eventstab. </P><P>endif. </P><P></P><P>read table p_eventstab with key name = slis_ev_foreign_top_of_page. </P><P>if sy-subrc = 0 . </P><P>move 'FOREIGN_TOP_OF_PAGE' to p_eventstab-form. </P><P>append p_eventstab. </P><P>endif. </P><P></P><P>read table p_eventstab with key name = slis_ev_foreign_end_of_page. </P><P>if sy-subrc = 0 . </P><P>move 'FOREIGN_END_OF_PAGE' to p_eventstab-form. </P><P>append p_eventstab. </P><P>endif. </P><P></P><P>read table p_eventstab with key name = slis_ev_list_modify. </P><P>if sy-subrc = 0 . </P><P>move 'LIST_MODIFY' to p_eventstab-form. </P><P>append p_eventstab. </P><P>endif. </P><P></P><P>read table p_eventstab with key name = slis_ev_top_of_list. </P><P>if sy-subrc = 0 . </P><P>move 'TOP_OF_LIST' to p_eventstab-form. </P><P>append p_eventstab. </P><P>endif. </P><P></P><P>read table p_eventstab with key name = slis_ev_end_of_page. </P><P>if sy-subrc = 0 . </P><P>move 'END_OF_PAGE' to p_eventstab-form. </P><P>append p_eventstab. </P><P>endif. </P><P></P><P>read table p_eventstab with key name = slis_ev_end_of_list . </P><P>if sy-subrc = 0 . </P><P>move 'END_OF_LIST' to p_eventstab-form. </P><P>append p_eventstab. </P><P>endif. </P><P>endform. " FILL_EVENTSTAB </P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>*&amp; Form FILL_HEADINGTABLE </P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>text </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>--&gt;P_HEADING text * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /> <P></P><P>form fill_headingtable tables p_heading structure heading </P><P>using tablename. </P><P>case tablename. </P><P>when 'HEADING'. </P><P>p_heading-typ = 'H'. </P><P>concatenate </P><P>' REPORT NAME:-' syrepid </P><P>' ABB Industry Pte Ltd' into p_heading-info. </P><P>append p_heading. </P><P>write sy-datum using edit mask '__/__/____' to sydatum. </P><P></P><P>concatenate </P><P>' DATE:-' sydatum ' USER: ' sy-uname 'PAGE NO:' sypagno </P><P>into p_heading-info. </P><P>append p_heading. </P><P>when 'HEADING1'. </P><P>p_heading-typ = 'H'. </P><P>p_heading-info = 'TOP-OF-COVER-PAGE'. </P><P>append p_heading. </P><P>when 'HEADING2'. </P><P>p_heading-typ = 'H'. </P><P>p_heading-info = 'END-OF-COVER-PAGE'. </P><P>append p_heading. </P><P>when 'HEADING3'. </P><P>p_heading-typ = 'H'. </P><P>p_heading-info = 'FOREIGN-TOP-OF-PAGE'. </P><P>append p_heading. </P><P>when 'HEADING4'. </P><P>p_heading-typ = 'H'. </P><P>p_heading-info = 'FOREIGN-END-OF-PAGE'. </P><P>append p_heading. </P><UL><LI level="1" type="ul"><P>WHEN 'HEADING5'. </P></LI><LI level="1" type="ul"><P>P_HEADING-TYP = 'H'. </P></LI><LI level="1" type="ul"><P>P_HEADING-INFO = 'LIST-MODIFY'. </P></LI><LI level="1" type="ul"><P>APPEND P_HEADING. </P></LI></UL><P>when 'HEADING6'. </P><P>p_heading-typ = 'H'. </P><P>p_heading-info = 'END-OF-PAGE'. </P><P>append p_heading. </P><P>when 'HEADING7'. </P><P>p_heading-typ = 'H'. </P><P>p_heading-info = 'END-OF-LIST'. </P><P>append p_heading. </P><P>when 'HEADING8'. </P><P>p_heading-typ = 'H'. </P><P>p_heading-info = 'TOP-OF-LIST'. </P><P>append p_heading. </P><P>endcase. </P><P>endform. " FILL_HEADINGTABLE </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM TOP_OF_PAGE * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form top_of_page. </P><P>call function 'REUSE_ALV_COMMENTARY_WRITE' </P><P>exporting </P><P>it_list_commentary = heading[] </P><P>exceptions </P><P>others = 1. </P><P>endform. </P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>*&amp; Form FILL_COLORSTRUCT </P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>text </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>--&gt;P_COLORSTRUCT text * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /> <P></P><P>form fill_colorstruct using p_colorstruct type slis_coltypes . </P><P>p_colorstruct-heacolfir-col = 6. </P><P>p_colorstruct-heacolfir-int = 1. </P><P>p_colorstruct-heacolfir-inv = 1. </P><P>endform. " FILL_COLORSTRUCT </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM TOP_OF_COVERPAGE * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form top_of_coverpage. </P><P>call function 'REUSE_ALV_COMMENTARY_WRITE' </P><P>exporting </P><P>it_list_commentary = heading1[] </P><P>exceptions </P><P>others = 1. </P><P>endform. </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM END_OF_COVERPAGE * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form end_of_coverpage. </P><P>call function 'REUSE_ALV_COMMENTARY_WRITE' </P><P>exporting </P><P>it_list_commentary = heading2[] </P><P>exceptions </P><P>others = 1. </P><P>endform. </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM FOREIGN_TOP_OF_PAGE * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form foreign_top_of_page. </P><P>call function 'REUSE_ALV_COMMENTARY_WRITE' </P><P>exporting </P><P>it_list_commentary = heading3[] </P><P>exceptions </P><P>others = 1. </P><P></P><P>endform. </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM FOREIGN_END_OF_PAGE * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form foreign_end_of_page. </P><P>call function 'REUSE_ALV_COMMENTARY_WRITE' </P><P>exporting </P><P>it_list_commentary = heading4[] </P><P>exceptions </P><P>others = 1. </P><P>endform. </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM LIST_MODIFY * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>*FORM LIST_MODIFY. </P><UL><LI level="1" type="ul"><P>CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' </P></LI><LI level="1" type="ul"><P>EXPORTING </P></LI><LI level="1" type="ul"><P>IT_LIST_COMMENTARY = HEADING5[] </P></LI><LI level="1" type="ul"><P>EXCEPTIONS </P></LI><LI level="1" type="ul"><P>OTHERS = 1. </P></LI></UL><P>*ENDFORM. </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM END_OF_PAGE * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form end_of_page. </P><P>call function 'REUSE_ALV_COMMENTARY_WRITE' </P><P>exporting </P><P>it_list_commentary = heading6[] </P><P>exceptions </P><P>others = 1. </P><P>endform. </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM END_OF_LIST * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form end_of_list. </P><P>call function 'REUSE_ALV_COMMENTARY_WRITE' </P><P>exporting </P><P>it_list_commentary = heading7[] </P><P>exceptions </P><P>others = 1. </P><P>endform. </P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>FORM TOP_OF_LIST * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><UL><LI level="1" type="ul"><P>........ * </P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /> <P></P><P>form top_of_list. </P><P>call function 'REUSE_ALV_COMMENTARY_WRITE' </P><P>exporting </P><P>it_list_commentary = heading8[] </P><P>exceptions </P><P>others = 1. </P><P>endform. </P><P></P><P>*--- End of Program</P><P></P><P>null</P></BODY></HTML> Wed, 21 Nov 2007 05:48:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073729#M728769 Former Member 2007-11-21T05:48:40Z Re: ALV report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073730#M728770 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>the headings of the coulms will be done in the filed catalog </P><P></P><P> fieldcatalog-fieldname = 'VBELN'.</P><P>&lt;b&gt; fieldcatalog-seltext_m = 'Sales Order'.&lt;/b&gt;</P><P> fieldcatalog-col_pos = 0.</P><P> fieldcatalog-outputlen = 10.</P><P> fieldcatalog-emphasize = 'X'.</P><P> fieldcatalog-key = 'X'.</P><P> append fieldcatalog to fieldcatalog.</P><P> clear fieldcatalog.</P></BODY></HTML> Wed, 21 Nov 2007 05:51:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073730#M728770 Former Member 2007-11-21T05:51:17Z Re: ALV report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073731#M728771 <HTML><HEAD></HEAD><BODY><P>hi Raj,</P><P></P><P> I will develop a small code for u.plz check it once.ur problem will be solved</P><P>If u r satisfy with the Answer plz give me REWARD POINTS.</P><P></P><P>copy the below code and execute it(see the field catalog form carefully-ur problem is that form)</P><P></P><P>code:</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Type Pools</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>TYPE-POOLS:slis.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Tables</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>TABLES: vbak,vbap.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Global Variable</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>data: w_var type i.</P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Global Data</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>DATA:it_fieldcat TYPE slis_t_fieldcat_alv,</P><P> wa_fieldcat TYPE slis_fieldcat_alv.</P><P>*</P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Internal Table</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>data: BEGIN OF it_salesorder OCCURS 0,</P><P></P><P> vbeln LIKE vbak-vbeln, " Sales Document Number</P><P> posnr like vbap-posnr, " Sales Doc Item</P><P> netwr like vbap-netwr, " Net Value</P><P></P><P> END OF it_salesorder.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> SELECT OPTIONS</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.</P><P>SELECT-OPTIONS: s_vbeln FOR vbak-vbeln. " Sales Document Number.</P><P>SELECTION-SCREEN END OF BLOCK b1.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> Initialization</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>INITIALIZATION.</P><P> PERFORM initialization.</P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*&amp; Form initialization</P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> --&gt; p1 text</P></LI><LI level="1" type="ul"><P> &lt;-- p2 text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>form initialization .</P><P> s_vbeln-sign = 'I'.</P><P> s_vbeln-option = 'BT'.</P><P> s_vbeln-low = '4969'.</P><P> s_vbeln-high = '5000'.</P><P> APPEND s_vbeln.</P><P>endform. " initialization</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> Start Of Selection</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>START-OF-SELECTION.</P><P> PERFORM field_catalog. "For Structure Creation</P><P> PERFORM fetch_data. "Get the Data From DB Table</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>End Of Selection</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>END-OF-SELECTION.</P><P> perform display_data.</P><P></P><P></P><P></P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*&amp; Form field_catalog</P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> --&gt; p1 text</P></LI><LI level="1" type="ul"><P> &lt;-- p2 text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>form field_catalog .</P><P></P><P> wa_fieldcat-col_pos = w_var. " Column Position Variable</P><P> wa_fieldcat-tabname = 'IT_SALESORDER'. " Internal Table Name</P><P> wa_fieldcat-fieldname = 'VBELN'. " Field Name</P><P> wa_fieldcat-key = 'X'. " Blue Color</P><P> wa_fieldcat-ref_tabname = 'VBAK'. " Table Name</P><P> wa_fieldcat-ref_fieldname = 'VBELN'. " Field Name</P><P> wa_fieldcat-seltext_m = 'Sales Doc No'. " Display Text In Screen</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> CLEAR wa_fieldcat.</P><P> ADD 1 TO w_var.</P><P></P><P> wa_fieldcat-col_pos = w_var. " Column Position Variable</P><P> wa_fieldcat-tabname = 'IT_SALESORDER'. " Internal Table Name</P><P> wa_fieldcat-fieldname = 'POSNR'. " Field Name</P><P> wa_fieldcat-ref_tabname = 'VBAP'. " Table Name</P><P> wa_fieldcat-ref_fieldname = 'POSNR'. " Field Name</P><P> wa_fieldcat-seltext_m = 'Sales Doc Item'. " Display Text In Screen</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> CLEAR wa_fieldcat.</P><P> ADD 1 TO w_var.</P><P></P><P> wa_fieldcat-col_pos = w_var. " Column Position Variable</P><P> wa_fieldcat-tabname = 'IT_SALESORDER'. " Internal Table Name</P><P> wa_fieldcat-fieldname = 'NETWR'. " Field Name</P><P> wa_fieldcat-ref_tabname = 'VBAP'. " Table Name</P><P> wa_fieldcat-ref_fieldname = 'NETWR'. " Field Name</P><UL><LI level="1" type="ul"><P> wa_fieldcat-do_sum = 'X'. " Sum</P></LI></UL><P> wa_fieldcat-seltext_m = 'Net Value'. " Display Text In Screen</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> CLEAR wa_fieldcat.</P><P> ADD 1 TO w_var.</P><P>endform. " field_catalog</P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*&amp; Form display_data</P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> --&gt; p1 text</P></LI><LI level="1" type="ul"><P> &lt;-- p2 text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>form display_data .</P><P>CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> I_INTERFACE_CHECK = ' '</P></LI><LI level="1" type="ul"><P> I_BYPASSING_BUFFER = ' '</P></LI><LI level="1" type="ul"><P> I_BUFFER_ACTIVE = ' '</P></LI></UL><P> I_CALLBACK_PROGRAM = SY-REPID</P><UL><LI level="1" type="ul"><P> I_CALLBACK_PF_STATUS_SET = ' '</P></LI><LI level="1" type="ul"><P> I_CALLBACK_USER_COMMAND = ' '</P></LI><LI level="1" type="ul"><P> I_CALLBACK_TOP_OF_PAGE = ' '</P></LI><LI level="1" type="ul"><P> I_CALLBACK_HTML_TOP_OF_PAGE = ' '</P></LI><LI level="1" type="ul"><P> I_CALLBACK_HTML_END_OF_LIST = ' '</P></LI><LI level="1" type="ul"><P> I_STRUCTURE_NAME =</P></LI><LI level="1" type="ul"><P> I_BACKGROUND_ID = ' '</P></LI><LI level="1" type="ul"><P> I_GRID_TITLE =</P></LI><LI level="1" type="ul"><P> I_GRID_SETTINGS =</P></LI><LI level="1" type="ul"><P> IS_LAYOUT =</P></LI></UL><P> IT_FIELDCAT = it_fieldcat</P><UL><LI level="1" type="ul"><P> IT_EXCLUDING =</P></LI><LI level="1" type="ul"><P> IT_SPECIAL_GROUPS =</P></LI><LI level="1" type="ul"><P> IT_SORT = it_sortcat</P></LI><LI level="1" type="ul"><P> IT_FILTER =</P></LI><LI level="1" type="ul"><P> IS_SEL_HIDE =</P></LI><LI level="1" type="ul"><P> I_DEFAULT = 'X'</P></LI><LI level="1" type="ul"><P> I_SAVE = ' '</P></LI><LI level="1" type="ul"><P> IS_VARIANT =</P></LI><LI level="1" type="ul"><P> IT_EVENTS =</P></LI><LI level="1" type="ul"><P> IT_EVENT_EXIT =</P></LI><LI level="1" type="ul"><P> IS_PRINT =</P></LI><LI level="1" type="ul"><P> IS_REPREP_ID =</P></LI><LI level="1" type="ul"><P> I_SCREEN_START_COLUMN = 0</P></LI><LI level="1" type="ul"><P> I_SCREEN_START_LINE = 0</P></LI><LI level="1" type="ul"><P> I_SCREEN_END_COLUMN = 0</P></LI><LI level="1" type="ul"><P> I_SCREEN_END_LINE = 0</P></LI><LI level="1" type="ul"><P> IT_ALV_GRAPHICS =</P></LI><LI level="1" type="ul"><P> IT_HYPERLINK =</P></LI><LI level="1" type="ul"><P> IT_ADD_FIELDCAT =</P></LI><LI level="1" type="ul"><P> IT_EXCEPT_QINFO =</P></LI><LI level="1" type="ul"><P> I_HTML_HEIGHT_TOP =</P></LI><LI level="1" type="ul"><P> I_HTML_HEIGHT_END =</P></LI><LI level="1" type="ul"><P>IMPORTING</P></LI><LI level="1" type="ul"><P> E_EXIT_CAUSED_BY_CALLER =</P></LI><LI level="1" type="ul"><P> ES_EXIT_CAUSED_BY_USER =</P></LI></UL><P> TABLES</P><P> t_outtab = it_salesorder</P><P> EXCEPTIONS</P><P> PROGRAM_ERROR = 1</P><P> OTHERS = 2</P><P> .</P><P>IF sy-subrc &lt;&gt; 0.</P><UL><LI level="1" type="ul"><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P></LI><LI level="1" type="ul"><P> WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P></LI></UL><P>ENDIF.</P><P></P><P>endform. " display_data</P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*&amp; Form fetch_data</P><P><STRONG>&amp;----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> --&gt; p1 text</P></LI><LI level="1" type="ul"><P> &lt;-- p2 text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>form fetch_data .</P><P>select a~vbeln</P><P> posnr</P><P> b~netwr</P><P> from vbak as a</P><P> inner join vbap as b on a<SUB>vbeln = b</SUB>vbeln</P><P> into table it_salesorder</P><P> where a~vbeln in s_vbeln.</P><P></P><P>endform. " fetch_data</P></BODY></HTML> Wed, 21 Nov 2007 05:57:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073731#M728771 Former Member 2007-11-21T05:57:43Z Re: ALV report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073732#M728772 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>R u using REUSE_ALV_FIELDCATALOG_MERGE or u have created manually.</P><P></P><P>if u have created manually u can use this format.</P><P></P><P>i_fieldcate-col_pos = '1'.</P><P>i_fieldcate-fieldname = 'EBELN'.</P><P>i_fieldcate-ref_fieldname = 'EBELN'.</P><P>i_fieldcate-tabname = 'ITAB'.</P><P>i_fieldcate-ref_tabname = 'EKKO'.</P><P>i_fieldcat-seltext_l = 'PURCHASE ORDERNO'.</P><P></P><P>APPEND I_FIELDCATE.</P><P>CLEAR I_FIELDCATE.</P></BODY></HTML> Wed, 21 Nov 2007 06:01:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/3073732#M728772 Former Member 2007-11-21T06:01:28Z