topic Re: alv report in Application Development and Automation Discussions

topic Re: alv report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431380#M543571 <HTML><HEAD></HEAD><BODY><P>HI ,</P><P>THIS MIGHT HEALP YOU OUT</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Report YMP_ALV_BLOCK *</P><P>*& *</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& *</P><P>*& *</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P>REPORT YMP_ALV_BLOCK .</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="--------------------------" />TABLES--<HR originaltext="----------------------------" /><P></P><P>TABLES : VBAK.</P><P></P><P>TYPE-POOLS : SLIS,ICON.</P><P></P><P>SELECT-OPTIONS : S_VBELN FOR VBAK-VBELN.</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="-------------------------" />STRUCTURE DECALRATION--<HR originaltext="--------------" /><P></P><P></P><P>TYPES : BEGIN OF TY_VBAK,</P><P> VBELN TYPE VBELN_VA,</P><P> ERDAT TYPE ERDAT,</P><P> ERZET TYPE ERZET,</P><P> ERNAM TYPE ERNAM,</P><P> ANY(4) TYPE C,</P><P> END OF TY_VBAK.</P><P></P><P>TYPES : BEGIN OF TY_VBAP,</P><P> VBELN TYPE VBELN_VA,</P><P> POSNR TYPE POSNR_VA,</P><P> MATNR TYPE MATNR,</P><P> MATWA TYPE MATWA,</P><P> END OF TY_VBAP.</P><P></P><P>TYPES : TT_VBAK TYPE STANDARD TABLE OF TY_VBAK,</P><P> TT_VBAP TYPE STANDARD TABLE OF TY_VBAP.</P><P></P><P>DATA : IT_VBAK TYPE TT_VBAK WITH HEADER LINE,</P><P> IT_VBAP TYPE TT_VBAP WITH HEADER LINE.</P><P></P><P>DATA : FCAT TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE,</P><P> FCAT1 TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE,</P><P> LAYOUT TYPE SLIS_LAYOUT_ALV,</P><P> LAYOUT1 TYPE SLIS_LAYOUT_ALV,</P><P> EVENTS TYPE SLIS_T_EVENT.</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="----------------------" />START OF SELECTION--<HR originaltext="--------------------" /><P></P><P></P><P>SELECT VBELN</P><P> ERDAT</P><P> ERZET</P><P> ERNAM</P><P> FROM VBAK</P><P> INTO TABLE IT_VBAK</P><P> WHERE VBELN IN S_VBELN.</P><P></P><P>IF IT_VBAK IS NOT INITIAL.</P><P></P><P>SELECT VBELN</P><P> POSNR</P><P> MATNR</P><P> MATWA</P><P> FROM VBAP</P><P> INTO TABLE IT_VBAP</P><P> FOR ALL ENTRIES IN IT_VBAK</P><P> WHERE VBELN EQ IT_VBAK-VBELN.</P><P></P><P>ENDIF.</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="-----------------------------" />FIELDCATLOG--<HR originaltext="-----------" /><P></P><P></P><P>FCAT-COL_POS = '1'.</P><P>FCAT-FIELDNAME = 'VBELN'.</P><P>FCAT-TABNAME = 'IT_VBAK'.</P><P>FCAT-OUTPUTLEN = '20'.</P><P>FCAT-SELTEXT_L = 'SALES DOCUMENT'.</P><P>FCAT-EMPHASIZE = 'C310'.</P><P>APPEND FCAT.</P><P>CLEAR FCAT.</P><P></P><P>FCAT-COL_POS = '2'.</P><P>FCAT-FIELDNAME = 'ERDAT'.</P><P>FCAT-TABNAME = 'IT_VBAK'.</P><P>FCAT-OUTPUTLEN = '20'.</P><P>FCAT-SELTEXT_L = 'DATE OF ENTRY'.</P><P>FCAT-EMPHASIZE = 'C410'.</P><P>APPEND FCAT.</P><P>CLEAR FCAT.</P><P></P><P>FCAT-COL_POS = '3'.</P><P>FCAT-FIELDNAME = 'EZETR'.</P><P>FCAT-TABNAME = 'IT_VBAK'.</P><P>FCAT-OUTPUTLEN = '20'.</P><P>FCAT-SELTEXT_L = 'TIME OF ENTRY'.</P><P>FCAT-EMPHASIZE = 'C510'.</P><P>APPEND FCAT.</P><P>CLEAR FCAT.</P><P></P><P>FCAT-COL_POS = '4'.</P><P>FCAT-FIELDNAME = 'ERNAM'.</P><P>FCAT-TABNAME = 'IT_VBAK'.</P><P>FCAT-OUTPUTLEN = '20'.</P><P>FCAT-SELTEXT_L = 'NAME OF ENTRY'.</P><P>FCAT-EMPHASIZE = 'C610'.</P><P>APPEND FCAT.</P><P>CLEAR FCAT.</P><P></P><P>FCAT1-COL_POS = '1'.</P><P>FCAT1-FIELDNAME = 'VBELN'.</P><P>FCAT1-TABNAME = 'IT_VBAP'.</P><P>FCAT1-OUTPUTLEN = '20'.</P><P>FCAT1-SELTEXT_L = 'SALES DOCUMENT'.</P><P>APPEND FCAT1.</P><P>CLEAR FCAT1.</P><P></P><P>FCAT1-COL_POS = '2'.</P><P>FCAT1-FIELDNAME = 'POSNR'.</P><P>FCAT1-TABNAME = 'IT_VBAP'.</P><P>FCAT1-OUTPUTLEN = '20'.</P><P>FCAT1-SELTEXT_L = 'ITEM DOCUMENT'.</P><P>APPEND FCAT1.</P><P>CLEAR FCAT1.</P><P></P><P>FCAT1-COL_POS = '3'.</P><P>FCAT1-FIELDNAME = 'MATNR'.</P><P>FCAT1-TABNAME = 'IT_VBAP'.</P><P>FCAT1-OUTPUTLEN = '20'.</P><P>FCAT1-SELTEXT_L = 'MATERIAL NUMBER'.</P><P>APPEND FCAT1.</P><P>CLEAR FCAT1.</P><P></P><P>FCAT1-COL_POS = '4'.</P><P>FCAT1-FIELDNAME = 'MATWA'.</P><P>FCAT1-TABNAME = 'IT_VBAP'.</P><P>FCAT1-OUTPUTLEN = '20'.</P><P>FCAT1-SELTEXT_L = 'MATERIAL NAME'.</P><P>APPEND FCAT1.</P><P>CLEAR FCAT1.</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="-----------------------" />DISPLAY--<HR originaltext="-------------------" /><P></P><P></P><P>CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_INIT'</P><P> EXPORTING</P><P> i_callback_program = SY-CPROG.</P><P></P><P>CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND'</P><P> EXPORTING</P><P> is_layout = LAYOUT</P><P> it_fieldcat = FCAT[]</P><P> i_tabname = 'IT_VBAK'</P><P> it_events = EVENTS</P><P> tables</P><P> t_outtab = IT_VBAK</P><P> .</P><P></P><P>CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND'</P><P> EXPORTING</P><P> is_layout = LAYOUT1</P><P> it_fieldcat = FCAT1[]</P><P> i_tabname = 'IT_VBAP'</P><P> it_events = EVENTS</P><P> tables</P><P> t_outtab = IT_VBAP</P><P> .</P><P></P><P>CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_DISPLAY'.</P></BODY></HTML> Thu, 28 Jun 2007 10:27:26 GMT Former Member 2007-06-28T10:27:26Z alv report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431375#M543566 <HTML><HEAD></HEAD><BODY><P>hi can any body tell me shy my program is not working.urgent plz...</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Report Z_PM_MAINTANANCE_ORDERS</P><P>*&</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*&</P><P>*&</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P>REPORT Z_PM_MAINTANANCE_ORDERS</P><P> no standard page heading</P><P> line-count 20</P><P> line-size 130.</P><P>type-pools: slis.</P><P>*message-id 00</P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>*Author: kiran kumar</P><P>*Creation Date: 28/06/2007</P><P>*Description:</P><P></P><P>*This is an alv Report program to show material planning for maintanance orders.</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& definition of tables</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P>tables:caufv,</P><P> resb,</P><P> rsdb.</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& definition of select-options,ranges</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P>selection-screen begin of block s_blk1 with frame title text-001.</P><P>select-options:s_aufnr for caufv-aufnr ,</P><P> s_sowrk for caufv-sowrk,</P><P> s_auart for caufv-auart,</P><P> s_gstrp for caufv-gstrp.</P><P>selection-screen end of block s_blk1 .</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& data definition of types/structures</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>types:begin of ty_caufv,</P><P> aufnr like caufv-aufnr,</P><P> sowrk like caufv-sowrk,</P><P> auart like caufv-auart,</P><P> gstrp like caufv-gstrp,</P><P> rsnum like caufv-rsnum,</P><P> end of ty_caufv.</P><P></P><P>types:begin of ty_resb,</P><P> matnr like resb-matnr,</P><P> bdmng like resb-bdmng,</P><P> meins like resb-meins,</P><P> end of ty_resb.</P><P></P><P>types:begin of ty_rsdb,</P><P> banfn like rsdb-banfn,</P><P> bnfpo like rsdb-bnfpo,</P><P> end of ty_rsdb.</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& data definition of internal tables</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>data:i_itab_caufv type table of ty_caufv with header line,</P><P> i_itab_resb type table of ty_resb with header line,</P><P> i_itab_rsdb type table of ty_rsdb with header line.</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& internal tables declaration for grid display</P><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> it_list type slis_t_listheader,</P><P> wa_list type slis_listheader.</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& initialisaiton</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P>initialization.</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& at selection-screen</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P>at selection-screen.</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& start-of-selection</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P> select aufnr</P><P> sowrk</P><P> auart</P><P> gstrp</P><P> rsnum from caufv into table i_itab_caufv</P><P> where aufnr in s_aufnr</P><P> and sowrk in s_sowrk</P><P> and auart in s_auart</P><P> and gstrp in s_gstrp.</P><P></P><P> select matnr</P><P> bdmng</P><P> meins from resb into table i_itab_resb</P><P> for all entries in i_itab_caufv</P><P> where rsnum = i_itab_caufv-rsnum.</P><P></P><P> select banfn</P><P> bnfpo from rsdb into table i_itab_rsdb</P><P> for all entries in i_itab_caufv</P><P> where rsnum = i_itab_caufv-rsnum.</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& display of data</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P> wa_fieldcat-fieldname = 'aufnr'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'order number'.</P><P> wa_fieldcat-outputlen = 8.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></P><P> wa_fieldcat-fieldname = 'sowrk'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'plant'.</P><P> wa_fieldcat-outputlen = 8.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></P><P>wa_fieldcat-fieldname = 'auart'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'order type'.</P><P> wa_fieldcat-outputlen = 8.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></P><P> wa_fieldcat-fieldname = 'gstrp'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'basic start date'.</P><P> wa_fieldcat-outputlen = 8.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></P><P>wa_fieldcat-fieldname = 'rsnum'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'reservation number'.</P><P> wa_fieldcat-outputlen = 8.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></P><P>wa_fieldcat-fieldname = 'matnr'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'material number'.</P><P> wa_fieldcat-outputlen = 8.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></P><P>wa_fieldcat-fieldname = 'bdmng'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'requirement quantity'.</P><P> wa_fieldcat-outputlen = 10.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></P><P> wa_fieldcat-fieldname = 'meins'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'unit of measure'.</P><P> wa_fieldcat-outputlen = 10.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></P><P> wa_fieldcat-fieldname = 'banfn'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'purcahse requisition number'.</P><P> wa_fieldcat-outputlen = 15.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></P><P>wa_fieldcat-fieldname = 'bnfpo'.</P><UL><LI level="1" type="ul"><P> wa_fieldcat-tabname = ''.</P></LI></UL><P> wa_fieldcat-seltext_l = 'requisition.item number'.</P><P> wa_fieldcat-outputlen = 15.</P><P> APPEND wa_fieldcat TO it_fieldcat.</P><P> clear wa_fieldcat.</P><P></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 =</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> I_HTML_HEIGHT_TOP = 0</P></LI><LI level="1" type="ul"><P> I_HTML_HEIGHT_END = 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> IR_SALV_FULLSCREEN_ADAPTER =</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 = i_itab_resb</P><UL><LI level="1" type="ul"><P>EXCEPTIONS</P></LI><LI level="1" type="ul"><P> PROGRAM_ERROR = 1</P></LI><LI level="1" type="ul"><P> OTHERS = 2</P></LI></UL><P> .</P><P>IF SY-SUBRC <> 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></P><P>ENDIF.</P><P></P><P>urgent plz andpoints will be rewarded.</P></BODY></HTML> Thu, 28 Jun 2007 09:52:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431375#M543566 Former Member 2007-06-28T09:52:56Z Re: alv report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431376#M543567 <HTML><HEAD></HEAD><BODY><P>HI.</P><P></P><P>You have tree internal table.two have values.transfer all record to one internal table if both have any comman filed .Give export and import parament to Functional module.</P><P></P><P>refer this code.</P><P></P><P>*data definition</P><P></P><P>tables:</P><P>marav. "Table MARA and table MAKT</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Data to be displayed in ALV</P></LI><LI level="1" type="ul"><P>Using the following syntax, REUSE_ALV_FIELDCATALOG_MERGE can auto-</P></LI><LI level="1" type="ul"><P>matically determine the fieldstructure from this source program</P></LI></UL><P>Data:</P><P>begin of imat occurs 100,</P><P>matnr like marav-matnr, "Material number</P><P>maktx like marav-maktx, "Material short text</P><P>matkl like marav-matkl, "Material group (so you can test to make</P><P> " intermediate sums)</P><P>ntgew like marav-ntgew, "Net weight, numeric field (so you can test to</P><P> "make sums)</P><P>gewei like marav-gewei, "weight unit (just to be complete)</P><P>end of imat.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Other data needed</P></LI><LI level="1" type="ul"><P>field to store report name</P></LI></UL><P>data i_repid like sy-repid.</P><UL><LI level="1" type="ul"><P>field to check table length</P></LI></UL><P>data i_lines like sy-tabix.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Data for ALV display</P></LI></UL><P>TYPE-POOLS: SLIS.</P><P>data int_fcat type SLIS_T_FIELDCAT_ALV.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>select-options:</P><P>s_matnr for marav-matnr matchcode object MAT1.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>start-of-selection.</P><P></P><UL><LI level="1" type="ul"><P>read data into table imat</P></LI></UL><P> select * from marav</P><P> into corresponding fields of table imat</P><P> where</P><P> matnr in s_matnr.</P><P></P><UL><LI level="1" type="ul"><P>Check if material was found</P></LI></UL><P> clear i_lines.</P><P> describe table imat lines i_lines.</P><P> if i_lines lt 1.</P><UL><LI level="1" type="ul"><P> Using hardcoded write here for easy upload</P></LI></UL><P> write: /</P><P> 'No materials found.'.</P><P> exit.</P><P> endif.</P><P></P><P>end-of-selection.</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*</P><UL><LI level="1" type="ul"><P>Now, we start with ALV</P></LI></UL><P>*</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*</P><P>*</P><UL><LI level="1" type="ul"><P>To use ALV, we need a DDIC-structure or a thing called Fieldcatalogue.</P></LI><LI level="1" type="ul"><P>The fieldcatalouge can be generated by FUNCTION</P></LI><LI level="1" type="ul"><P>'REUSE_ALV_FIELDCATALOG_MERGE' from an internal table from any</P></LI><LI level="1" type="ul"><P>report source, including this report.</P></LI><LI level="1" type="ul"><P>The only problem one might have is that the report and table names</P></LI><LI level="1" type="ul"><P>need to be in capital letters. (I had it <SPAN __jive_emoticon_name="sad"></SPAN> )</P></LI></UL><P>*</P><P>*</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><UL><LI level="1" type="ul"><P>Store report name</P></LI></UL><P> i_repid = sy-repid.</P><P></P><UL><LI level="1" type="ul"><P>Create Fieldcatalogue from internal table</P></LI></UL><P> CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'</P><P> EXPORTING</P><P> I_PROGRAM_NAME = i_repid</P><P> I_INTERNAL_TABNAME = 'IMAT' "capital letters!</P><P> I_INCLNAME = i_repid</P><P> CHANGING</P><P> CT_FIELDCAT = int_fcat</P><P> EXCEPTIONS</P><P> INCONSISTENT_INTERFACE = 1</P><P> PROGRAM_ERROR = 2</P><P> OTHERS = 3.</P><P>*explanations:</P><UL><LI level="1" type="ul"><P> I_PROGRAM_NAME is the program which calls this function</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> I_INTERNAL_TABNAME is the name of the internal table which you want</P></LI><LI level="1" type="ul"><P> to display in ALV</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> I_INCLNAME is the ABAP-source where the internal table is defined</P></LI><LI level="1" type="ul"><P> (DATA....)</P></LI><LI level="1" type="ul"><P> CT_FIELDCAT contains the Fieldcatalouge that we need later for</P></LI><LI level="1" type="ul"><P> ALV display</P></LI></UL><P></P><P></P><P> IF SY-SUBRC <> 0.</P><P> write: /</P><P> 'Returncode',</P><P> sy-subrc,</P><P> 'from FUNCTION REUSE_ALV_FIELDCATALOG_MERGE'.</P><P> ENDIF.</P><P></P><P>*This was the fieldcatlogue</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*</P><UL><LI level="1" type="ul"><P>And now, we are ready to display our list</P></LI></UL><P></P><UL><LI level="1" type="ul"><P>Call for ALV list display</P></LI></UL><P> CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> I_CALLBACK_PROGRAM = 'Z_ALV_SIMPLE_EXAMPLE_WITH_ITAB'</P></LI></UL><P> I_CALLBACK_PROGRAM = i_repid</P><P> IT_FIELDCAT = int_fcat</P><P> I_SAVE = 'A'</P><P> TABLES</P><P> T_OUTTAB = imat</P><P> EXCEPTIONS</P><P> PROGRAM_ERROR = 1</P><P> OTHERS = 2.</P><P>*</P><P>*explanations:</P><UL><LI level="1" type="ul"><P> I_CALLBACK_PROGRAM is the program which calls this function</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> IT_FIELDCAT (just made by REUSE_ALV_FIELDCATALOG_MERGE) contains</P></LI><LI level="1" type="ul"><P> now the data definition needed for display</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> I_SAVE allows the user to save his own layouts</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> T_OUTTAB contains the data to be displayed in ALV</P></LI></UL><P></P><P></P><P> IF SY-SUBRC <> 0.</P><P> write: /</P><P> 'Returncode',</P><P> sy-subrc,</P><P> 'from FUNCTION REUSE_ALV_LIST_DISPLAY'.</P><P> ENDIF.</P><P>*</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*</P><UL><LI level="1" type="ul"><P>yes, it is that simple. Go ahead and try yourself!</P></LI></UL><P>*</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P></P><P></P><P>Reward all helpfull answers.</P><P>Regards.</P><P>Jay</P></BODY></HTML> Thu, 28 Jun 2007 09:59:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431376#M543567 Former Member 2007-06-28T09:59:04Z Re: alv report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431377#M543568 <HTML><HEAD></HEAD><BODY><P>HI.</P><P></P><P>You have tree internal table.two have values.transfer all record to one internal table if both have any comman filed .Give export and import parament to Functional module.</P><P></P><P>refer this code.</P><P></P><P>*data definition</P><P></P><P>tables:</P><P>marav. "Table MARA and table MAKT</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Data to be displayed in ALV</P></LI><LI level="1" type="ul"><P>Using the following syntax, REUSE_ALV_FIELDCATALOG_MERGE can auto-</P></LI><LI level="1" type="ul"><P>matically determine the fieldstructure from this source program</P></LI></UL><P>Data:</P><P>begin of imat occurs 100,</P><P>matnr like marav-matnr, "Material number</P><P>maktx like marav-maktx, "Material short text</P><P>matkl like marav-matkl, "Material group (so you can test to make</P><P> " intermediate sums)</P><P>ntgew like marav-ntgew, "Net weight, numeric field (so you can test to</P><P> "make sums)</P><P>gewei like marav-gewei, "weight unit (just to be complete)</P><P>end of imat.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Other data needed</P></LI><LI level="1" type="ul"><P>field to store report name</P></LI></UL><P>data i_repid like sy-repid.</P><UL><LI level="1" type="ul"><P>field to check table length</P></LI></UL><P>data i_lines like sy-tabix.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Data for ALV display</P></LI></UL><P>TYPE-POOLS: SLIS.</P><P>data int_fcat type SLIS_T_FIELDCAT_ALV.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>select-options:</P><P>s_matnr for marav-matnr matchcode object MAT1.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>start-of-selection.</P><P></P><UL><LI level="1" type="ul"><P>read data into table imat</P></LI></UL><P> select * from marav</P><P> into corresponding fields of table imat</P><P> where</P><P> matnr in s_matnr.</P><P></P><UL><LI level="1" type="ul"><P>Check if material was found</P></LI></UL><P> clear i_lines.</P><P> describe table imat lines i_lines.</P><P> if i_lines lt 1.</P><UL><LI level="1" type="ul"><P> Using hardcoded write here for easy upload</P></LI></UL><P> write: /</P><P> 'No materials found.'.</P><P> exit.</P><P> endif.</P><P></P><P>end-of-selection.</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*</P><UL><LI level="1" type="ul"><P>Now, we start with ALV</P></LI></UL><P>*</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*</P><P>*</P><UL><LI level="1" type="ul"><P>To use ALV, we need a DDIC-structure or a thing called Fieldcatalogue.</P></LI><LI level="1" type="ul"><P>The fieldcatalouge can be generated by FUNCTION</P></LI><LI level="1" type="ul"><P>'REUSE_ALV_FIELDCATALOG_MERGE' from an internal table from any</P></LI><LI level="1" type="ul"><P>report source, including this report.</P></LI><LI level="1" type="ul"><P>The only problem one might have is that the report and table names</P></LI><LI level="1" type="ul"><P>need to be in capital letters. (I had it <SPAN __jive_emoticon_name="sad"></SPAN> )</P></LI></UL><P>*</P><P>*</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><UL><LI level="1" type="ul"><P>Store report name</P></LI></UL><P> i_repid = sy-repid.</P><P></P><UL><LI level="1" type="ul"><P>Create Fieldcatalogue from internal table</P></LI></UL><P> CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'</P><P> EXPORTING</P><P> I_PROGRAM_NAME = i_repid</P><P> I_INTERNAL_TABNAME = 'IMAT' "capital letters!</P><P> I_INCLNAME = i_repid</P><P> CHANGING</P><P> CT_FIELDCAT = int_fcat</P><P> EXCEPTIONS</P><P> INCONSISTENT_INTERFACE = 1</P><P> PROGRAM_ERROR = 2</P><P> OTHERS = 3.</P><P>*explanations:</P><UL><LI level="1" type="ul"><P> I_PROGRAM_NAME is the program which calls this function</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> I_INTERNAL_TABNAME is the name of the internal table which you want</P></LI><LI level="1" type="ul"><P> to display in ALV</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> I_INCLNAME is the ABAP-source where the internal table is defined</P></LI><LI level="1" type="ul"><P> (DATA....)</P></LI><LI level="1" type="ul"><P> CT_FIELDCAT contains the Fieldcatalouge that we need later for</P></LI><LI level="1" type="ul"><P> ALV display</P></LI></UL><P></P><P></P><P> IF SY-SUBRC <> 0.</P><P> write: /</P><P> 'Returncode',</P><P> sy-subrc,</P><P> 'from FUNCTION REUSE_ALV_FIELDCATALOG_MERGE'.</P><P> ENDIF.</P><P></P><P>*This was the fieldcatlogue</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*</P><UL><LI level="1" type="ul"><P>And now, we are ready to display our list</P></LI></UL><P></P><UL><LI level="1" type="ul"><P>Call for ALV list display</P></LI></UL><P> CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> I_CALLBACK_PROGRAM = 'Z_ALV_SIMPLE_EXAMPLE_WITH_ITAB'</P></LI></UL><P> I_CALLBACK_PROGRAM = i_repid</P><P> IT_FIELDCAT = int_fcat</P><P> I_SAVE = 'A'</P><P> TABLES</P><P> T_OUTTAB = imat</P><P> EXCEPTIONS</P><P> PROGRAM_ERROR = 1</P><P> OTHERS = 2.</P><P>*</P><P>*explanations:</P><UL><LI level="1" type="ul"><P> I_CALLBACK_PROGRAM is the program which calls this function</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> IT_FIELDCAT (just made by REUSE_ALV_FIELDCATALOG_MERGE) contains</P></LI><LI level="1" type="ul"><P> now the data definition needed for display</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> I_SAVE allows the user to save his own layouts</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> T_OUTTAB contains the data to be displayed in ALV</P></LI></UL><P></P><P></P><P> IF SY-SUBRC <> 0.</P><P> write: /</P><P> 'Returncode',</P><P> sy-subrc,</P><P> 'from FUNCTION REUSE_ALV_LIST_DISPLAY'.</P><P> ENDIF.</P><P>*</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*</P><UL><LI level="1" type="ul"><P>yes, it is that simple. Go ahead and try yourself!</P></LI></UL><P>*</P><P><STRONG>----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P></P><P></P><P>Reward all helpfull answers.</P><P>Regards.</P><P>Jay</P></BODY></HTML> Thu, 28 Jun 2007 09:59:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431377#M543568 Former Member 2007-06-28T09:59:53Z Re: alv report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431378#M543569 <HTML><HEAD></HEAD><BODY><P>hi kiran,</P><P></P><P>try this </P><P>while calling the FM REUSE_ALV_GRID_DISPLAY</P><P>pass the parameter I_CALLBACK_PROGRAM = g_repid where g_repid type sy-repid without quotes.</P><P></P><P>if helpful reward points .</P></BODY></HTML> Thu, 28 Jun 2007 10:02:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431378#M543569 Former Member 2007-06-28T10:02:19Z Re: alv report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431379#M543570 <HTML><HEAD></HEAD><BODY><P>1) you have three int table but you are passing only i_itab_resb which has only three fields but you are buiding the fieldcat for more fields . So you have to take all the data in a final itab and have to pass that one to reuse alv grid display .</P><P></P><P>2) in the fn module you are passing I_CALLBACK_PROGRAM = 'sy-repid' but it should be I_CALLBACK_PROGRAM = sy-repid i.e. without qoute..</P><P></P><P>3)in field cat you are passing the field name like wa_fieldcat-fieldname = 'banfn'. but it should be wa_fieldcat-fieldname = 'BANFN'. i.e. in CAPS.</P><P></P><P>after trying those pls let us know whether you are getting the output or not?</P><P></P><P>regards</P><P>shiba dutta</P></BODY></HTML> Thu, 28 Jun 2007 10:17:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431379#M543570 Former Member 2007-06-28T10:17:47Z Re: alv report https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431380#M543571 <HTML><HEAD></HEAD><BODY><P>HI ,</P><P>THIS MIGHT HEALP YOU OUT</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Report YMP_ALV_BLOCK *</P><P>*& *</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& *</P><P>*& *</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P></P><P>REPORT YMP_ALV_BLOCK .</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="--------------------------" />TABLES--<HR originaltext="----------------------------" /><P></P><P>TABLES : VBAK.</P><P></P><P>TYPE-POOLS : SLIS,ICON.</P><P></P><P>SELECT-OPTIONS : S_VBELN FOR VBAK-VBELN.</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="-------------------------" />STRUCTURE DECALRATION--<HR originaltext="--------------" /><P></P><P></P><P>TYPES : BEGIN OF TY_VBAK,</P><P> VBELN TYPE VBELN_VA,</P><P> ERDAT TYPE ERDAT,</P><P> ERZET TYPE ERZET,</P><P> ERNAM TYPE ERNAM,</P><P> ANY(4) TYPE C,</P><P> END OF TY_VBAK.</P><P></P><P>TYPES : BEGIN OF TY_VBAP,</P><P> VBELN TYPE VBELN_VA,</P><P> POSNR TYPE POSNR_VA,</P><P> MATNR TYPE MATNR,</P><P> MATWA TYPE MATWA,</P><P> END OF TY_VBAP.</P><P></P><P>TYPES : TT_VBAK TYPE STANDARD TABLE OF TY_VBAK,</P><P> TT_VBAP TYPE STANDARD TABLE OF TY_VBAP.</P><P></P><P>DATA : IT_VBAK TYPE TT_VBAK WITH HEADER LINE,</P><P> IT_VBAP TYPE TT_VBAP WITH HEADER LINE.</P><P></P><P>DATA : FCAT TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE,</P><P> FCAT1 TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE,</P><P> LAYOUT TYPE SLIS_LAYOUT_ALV,</P><P> LAYOUT1 TYPE SLIS_LAYOUT_ALV,</P><P> EVENTS TYPE SLIS_T_EVENT.</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="----------------------" />START OF SELECTION--<HR originaltext="--------------------" /><P></P><P></P><P>SELECT VBELN</P><P> ERDAT</P><P> ERZET</P><P> ERNAM</P><P> FROM VBAK</P><P> INTO TABLE IT_VBAK</P><P> WHERE VBELN IN S_VBELN.</P><P></P><P>IF IT_VBAK IS NOT INITIAL.</P><P></P><P>SELECT VBELN</P><P> POSNR</P><P> MATNR</P><P> MATWA</P><P> FROM VBAP</P><P> INTO TABLE IT_VBAP</P><P> FOR ALL ENTRIES IN IT_VBAK</P><P> WHERE VBELN EQ IT_VBAK-VBELN.</P><P></P><P>ENDIF.</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="-----------------------------" />FIELDCATLOG--<HR originaltext="-----------" /><P></P><P></P><P>FCAT-COL_POS = '1'.</P><P>FCAT-FIELDNAME = 'VBELN'.</P><P>FCAT-TABNAME = 'IT_VBAK'.</P><P>FCAT-OUTPUTLEN = '20'.</P><P>FCAT-SELTEXT_L = 'SALES DOCUMENT'.</P><P>FCAT-EMPHASIZE = 'C310'.</P><P>APPEND FCAT.</P><P>CLEAR FCAT.</P><P></P><P>FCAT-COL_POS = '2'.</P><P>FCAT-FIELDNAME = 'ERDAT'.</P><P>FCAT-TABNAME = 'IT_VBAK'.</P><P>FCAT-OUTPUTLEN = '20'.</P><P>FCAT-SELTEXT_L = 'DATE OF ENTRY'.</P><P>FCAT-EMPHASIZE = 'C410'.</P><P>APPEND FCAT.</P><P>CLEAR FCAT.</P><P></P><P>FCAT-COL_POS = '3'.</P><P>FCAT-FIELDNAME = 'EZETR'.</P><P>FCAT-TABNAME = 'IT_VBAK'.</P><P>FCAT-OUTPUTLEN = '20'.</P><P>FCAT-SELTEXT_L = 'TIME OF ENTRY'.</P><P>FCAT-EMPHASIZE = 'C510'.</P><P>APPEND FCAT.</P><P>CLEAR FCAT.</P><P></P><P>FCAT-COL_POS = '4'.</P><P>FCAT-FIELDNAME = 'ERNAM'.</P><P>FCAT-TABNAME = 'IT_VBAK'.</P><P>FCAT-OUTPUTLEN = '20'.</P><P>FCAT-SELTEXT_L = 'NAME OF ENTRY'.</P><P>FCAT-EMPHASIZE = 'C610'.</P><P>APPEND FCAT.</P><P>CLEAR FCAT.</P><P></P><P>FCAT1-COL_POS = '1'.</P><P>FCAT1-FIELDNAME = 'VBELN'.</P><P>FCAT1-TABNAME = 'IT_VBAP'.</P><P>FCAT1-OUTPUTLEN = '20'.</P><P>FCAT1-SELTEXT_L = 'SALES DOCUMENT'.</P><P>APPEND FCAT1.</P><P>CLEAR FCAT1.</P><P></P><P>FCAT1-COL_POS = '2'.</P><P>FCAT1-FIELDNAME = 'POSNR'.</P><P>FCAT1-TABNAME = 'IT_VBAP'.</P><P>FCAT1-OUTPUTLEN = '20'.</P><P>FCAT1-SELTEXT_L = 'ITEM DOCUMENT'.</P><P>APPEND FCAT1.</P><P>CLEAR FCAT1.</P><P></P><P>FCAT1-COL_POS = '3'.</P><P>FCAT1-FIELDNAME = 'MATNR'.</P><P>FCAT1-TABNAME = 'IT_VBAP'.</P><P>FCAT1-OUTPUTLEN = '20'.</P><P>FCAT1-SELTEXT_L = 'MATERIAL NUMBER'.</P><P>APPEND FCAT1.</P><P>CLEAR FCAT1.</P><P></P><P>FCAT1-COL_POS = '4'.</P><P>FCAT1-FIELDNAME = 'MATWA'.</P><P>FCAT1-TABNAME = 'IT_VBAP'.</P><P>FCAT1-OUTPUTLEN = '20'.</P><P>FCAT1-SELTEXT_L = 'MATERIAL NAME'.</P><P>APPEND FCAT1.</P><P>CLEAR FCAT1.</P><P></P><P><STRONG>--</STRONG><DEL><STRONG></STRONG></DEL></P><HR originaltext="-----------------------" />DISPLAY--<HR originaltext="-------------------" /><P></P><P></P><P>CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_INIT'</P><P> EXPORTING</P><P> i_callback_program = SY-CPROG.</P><P></P><P>CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND'</P><P> EXPORTING</P><P> is_layout = LAYOUT</P><P> it_fieldcat = FCAT[]</P><P> i_tabname = 'IT_VBAK'</P><P> it_events = EVENTS</P><P> tables</P><P> t_outtab = IT_VBAK</P><P> .</P><P></P><P>CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND'</P><P> EXPORTING</P><P> is_layout = LAYOUT1</P><P> it_fieldcat = FCAT1[]</P><P> i_tabname = 'IT_VBAP'</P><P> it_events = EVENTS</P><P> tables</P><P> t_outtab = IT_VBAP</P><P> .</P><P></P><P>CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_DISPLAY'.</P></BODY></HTML> Thu, 28 Jun 2007 10:27:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-report/m-p/2431380#M543571 Former Member 2007-06-28T10:27:26Z