REPORT ymm_po_wise_financial_status. TYPE-POOLS : slis. " SLIS is the type library for ALV grid TABLES: ekpo, mseg, ekkn, ekko, bsim, bsik, bsas, bseg, ekbe, bsak. TYPES : BEGIN OF itab, ebeln LIKE ekpo-ebeln , " PO No mblnr LIKE mseg-mblnr , " GRN No lblni LIKE essr-lblni , " SES No projn LIKE ekkn-projn , " Porject No aufnr LIKE ekkn-aufnr , " Maintenance Order lifnr LIKE ekko-lifnr , " Vendor Code *********************** SAP PO TOTAL ************************* menge LIKE ekpo-menge , " Quantity brtwr LIKE ekpo-brtwr , " PO FCY / PKR waers LIKE ekko-waers , " PO Currency *********************** ADVANCE **************************** belnr LIKE bkpf-belnr , " SAP Payment Doc# chect LIKE payr-chect , " Cheque No. *DMBTR LIKE BSEG-DMBTR , " Value FCY / PKR ************************ GRN VALUE ************************* menge1 LIKE mseg-menge , " Quantity mblnr1 LIKE mseg-mblnr , " GRN Doc# dmbtr1 LIKE mseg-dmbtr , " Value *WRONG MATNR LIKE MSEG-MATNR , " M NO ************************ TOTAL INVOICE ************************* menge2 LIKE mseg-menge , " Quantity belnr1 LIKE bsik-belnr , " SAP Invoice Doc# dmbtr2 LIKE bsik-dmbtr , " Value FCY / PKR dmbt1 LIKE bsik-dmbt1 , " GST PKR ************************ PAYMENT ***************************** belnr2 LIKE bsas-belnr , " SAP Payment Doc# chect1 LIKE payr-chect , " CHEQUE NO./AUTHORITY NO. wrbtr LIKE bseg-dmbtr , " Amount wmwst LIKE bseg-wmwst , " WITHHOLDING TAX / PKR dmbt3 LIKE bsik-dmbt3 , " WH GST 1% netamtpaid TYPE p DECIMALS 2 , " NET AMOUNT PAID ************************ RETENTION ***************************** belnr3 LIKE bseg-belnr , " SAP PAYMENT DOC# chect2 LIKE payr-chect , " CHEQUE NO./AUTHORITY NO. dmbtr3 LIKE bsas-dmbtr , " Value / FCY/PKR ************************ BALANCE ***************************** qty TYPE p DECIMALS 2 , " QTY value TYPE p DECIMALS 2 , " Value FCY/PKR bukrs TYPE ekpo-bukrs , END OF itab. DATA: it_itab TYPE STANDARD TABLE OF itab INITIAL SIZE 0 , wa_itab TYPE itab. DATA: fieldcatalog TYPE slis_t_fieldcat_alv WITH HEADER LINE, gd_tab_group TYPE slis_t_sp_group_alv, gd_layout TYPE slis_layout_alv, gd_repid LIKE sy-repid, gt_events TYPE slis_t_event, gd_prntparams TYPE slis_print_alv. SELECTION-SCREEN BEGIN OF BLOCK b3 WITH FRAME TITLE text-001. SELECT-OPTIONS: bukrs FOR ekpo-bukrs, "COMPANY CODE ebeln FOR ekpo-ebeln, "SAP PURCHASE ORDER NO. aufnr FOR ekkn-aufnr, "PROJECT NO./MAINTENANCE ORDER NO. ps_psp FOR ekkn-ps_psp_pnr, "WBSE NO. lifnr FOR ekko-lifnr, "VENDOR CODE bedat FOR ekko-bedat, "DATE matnr FOR ekpo-matnr, "MATERIAL CODE werks FOR ekpo-werks, "PLANT CODE knttp FOR ekpo-knttp, "PURCHASING TYPE (K, A , S ETC.) belnr FOR mseg-belnr, "DOCUMENT NO. bsart FOR ekko-bsart, "DOCUMENT TYPE saknr FOR bsik-saknr, "GL ACCOUNT kostl FOR bsik-kostl. "COST CENTER PARAMETERS: num_rows(5) TYPE c DEFAULT '500'. SELECTION-SCREEN END OF BLOCK b3. SELECT: DISTINCT ekpo~ebeln " PO No mseg~mblnr " GRN No ***** error MSEG~MATNR " Material No essr~lblni " SES No ekkn~projn " Porject No ekkn~aufnr " Maintenance Order ekko~lifnr " Vendor Code ********** SAP PO TOTAL ************ ekpo~menge " Quantity ekpo~brtwr " PO FCY / PKR ekko~waers " PO Currency ************ ADVANCE ************ bkpf~belnr " SAP Payment Doc# payr~chect " Cheque No. *BSEG~DMBTR " Value FCY / PKR ************* GRN VALUE ************ mseg~menge " Quantity mseg~mblnr " GRN Doc# mseg~dmbtr " Value ************* TOTAL INVOICE ************ mseg~menge " Quantity *****bsik~belnr " SAP Invoice Doc# *****bsik~dmbtr " Value FCY / PKR *****bsik~dmbt1 " GST PKR ************* PAYMENT ************ bkpf~belnr " SAP Payment Doc# payr~chect " CHEQUE NO./AUTHORITY NO. *BSEG~DMBTR " Amount *BSEG~WMWST " WITHHOLDING TAX / PKR ****bsik~dmbt3 " WH GST 1% ************* RETENTION ************ mseg~belnr " SAP PAYMENT DOC# payr~chect " CHEQUE NO./AUTHORITY NO. ****bsas~dmbtr " Value / FCY/PKR ekpo~bukrs INTO CORRESPONDING FIELDS OF wa_itab * from EKPO, MSEG, BSIM, ESSR, EKKN, EKKO, PAYR, BKPF FROM ekpo INNER JOIN mseg ON ekpo~ebeln = mseg~ebeln INNER JOIN ekkn ON ekpo~ebeln = ekkn~ebeln INNER JOIN ekko ON ekpo~ebeln = ekko~ebeln INNER JOIN bsak ON ekpo~ebeln = bsak~ebeln AND ekpo~ebelp = bsak~ebelp INNER JOIN bkpf ON bsak~belnr = bkpf~dbblg INNER JOIN payr ON bkpf~belnr = payr~vblnr ***INNER JOIN bseg ON bseg~belnr = bkpf~belnr INNER JOIN essr ON ekpo~ebeln = essr~ebeln * UP TO num_rows ROWS WHERE ekpo~bukrs IN bukrs AND "COMPANY CODE ekpo~ebeln IN ebeln AND "SAP PURCHASE ORDER NO. ekkn~aufnr IN aufnr AND "PROJECT NO./MAINTENANCE ORDER NO. ekkn~ps_psp_pnr IN ps_psp AND "WBSE NO. ekko~lifnr IN lifnr AND "VENDOR CODE ekko~bedat IN bedat AND "DATE ekpo~matnr IN matnr AND "MATERIAL CODE ekpo~werks IN werks AND "PLANT CODE ekpo~knttp IN knttp AND "PURCHASING TYPE (K AND A AND S ETC.) mseg~belnr IN belnr AND "DOCUMENT NO. ekko~bsart IN bsart." AND "DOCUMENT TYPE ****bsik~saknr IN saknr AND "GL ACCOUNT ****bsik~kostl IN kostl. "COST CENTER APPEND wa_itab TO it_itab. ENDSELECT. LOOP AT it_itab INTO wa_itab. ****Write : / wa_itab-ebeln. **"GRN value to display *SELECT DISTINCT MAX( MENGE ) into wa_itab-MENGE1 from MSEG * where MSEG~EBELN = wa_itab-EBELN AND MSEG~MATNR = wa_itab-MATNR * GROUP BY MENGE. *ENDSELECT. * **BAL_QTY = EKPO-MENGE - MSEG-ERFMG. " PO Quantity - DELIVERED QTY = BALANCE **BAL_VAL = EKPO-NETWR - MSEG-DMBTR. " PO VALUE - DELIVERED VALUE - BAL. VALUE * formula P = (K+L) - (E+N+O+R) wa_itab-netamtpaid = ( bsik-dmbtr + bsik-dmbt1 ) - ( bsim-dmbtr + bseg-wmwst + bsik-dmbt3 + bsas-dmbtr ). * formula S = A-I wa_itab-qty = ekpo-menge - mseg-menge. * formula T = B - ( D + M + Q) wa_itab-value = ekpo-brtwr - ( bsim-dmbtr + bseg-dmbtr + bsas-dmbtr ). * wa_itab-NETAMTPAID = DMBTR + DMBT1 - DMBTR + WMWST + DMBT3 + DMBTR MODIFY it_itab INDEX sy-tabix FROM wa_itab. ENDLOOP. *&---------------------------------------------------------------------* *& Looping at internal table to process the Document Date in Document *& inorder to calculate total number of days, months and years from specified date to current date *&---------------------------------------------------------------------* **perform data_retrieval. PERFORM build_fieldcatalog. PERFORM build_layout. PERFORM build_events. *perform build_print_params. PERFORM display_alv_report. *&---------------------------------------------------------------------* *& Form BUILD_FIELDCATALOG *&---------------------------------------------------------------------* * Build Fieldcatalog for ALV Report *----------------------------------------------------------------------* FORM build_fieldcatalog. * There are a number of ways to create a fieldcat. * For the purpose of this example i will build the fieldcatalog manualy * by populating the internal table fields individually and then * appending the rows. This method can be the most time consuming but can * also allow you more control of the final product. * Beware though, you need to ensure that all fields required are * populated. When using some of functionality available via ALV, such as * total. You may need to provide more information than if you were * simply displaying the result * I.e. Field type may be required in-order for * the 'TOTAL' function to work. fieldcatalog-fieldname = 'EBELN'. " field Name fieldcatalog-seltext_m = 'PO No'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'MBLNR'. " field Name fieldcatalog-seltext_m = 'GRN No'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'LBLNI'. " field Name fieldcatalog-seltext_m = 'SES No'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'PROJN'. " field Name fieldcatalog-seltext_m = 'Porject No'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'AUFNR'. " field Name fieldcatalog-seltext_m = 'Maintenance Order'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'LIFNR'. " field Name fieldcatalog-seltext_m = 'Vendor Code'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. ************************************************** SAP PO TOTAL ******* fieldcatalog-fieldname = 'MENGE'. " field Name fieldcatalog-seltext_m = 'Quantity'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'BRTWR'. " field Name fieldcatalog-seltext_m = 'PO FCY / PKR'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'WAERS'. " field Name fieldcatalog-seltext_m = 'PO Currency'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. ************************************************* ADVANCE ******* fieldcatalog-fieldname = 'BELNR'. " field Name fieldcatalog-seltext_m = 'SAP Payment Doc#'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'CHECT'. " field Name fieldcatalog-seltext_m = 'Cheque No.'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'DMBTR'. " field Name fieldcatalog-seltext_m = 'Value FCY / PKR'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. ************************************************ GRN VALUE ******** fieldcatalog-fieldname = 'MENGE1'. " field Name fieldcatalog-seltext_m = 'GRN Quantity'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'MBLNR1'. " field Name fieldcatalog-seltext_m = 'GRN Doc#'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'DMBTR1'. " field Name fieldcatalog-seltext_m = 'Value'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. ************************************************ TOTAL VALUE ********* fieldcatalog-fieldname = 'MENGE2'. " field Name fieldcatalog-seltext_m = 'Total Value Quantity'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'BELNR1'. " field Name fieldcatalog-seltext_m = 'SAP Invoice Doc#'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'DMBTR2'. " field Name fieldcatalog-seltext_m = 'Value FCY / PKR'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'DMBT1'. " field Name fieldcatalog-seltext_m = 'GST PKR'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. ************************************************* PAYMENT ********* * fieldcatalog-fieldname = 'BELNR2'. " field Name fieldcatalog-seltext_m = 'SAP Payment Doc#'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'CHECT1'. " field Name fieldcatalog-seltext_m = 'CHEQUE NO/AUTHORITY NO.'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'WRBTR'. " field Name fieldcatalog-seltext_m = 'Payment Amount'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'WMWST'. " field Name fieldcatalog-seltext_m = 'WH TAX / PKR'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'DMBT3'. " field Name fieldcatalog-seltext_m = 'WH GST 1%'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'NETAMTPAID'. " field Name fieldcatalog-seltext_m = 'NET AMOUNT PAID'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. *********************************************** RETENTION ********* fieldcatalog-fieldname = 'BELNR3'. " field Name fieldcatalog-seltext_m = 'SAP PAYMENT DOC#'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'CHECT2'. " field Name fieldcatalog-seltext_m = 'CHEQUE NO./AUTHORITY NO.'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'DMBTR3'. " field Name fieldcatalog-seltext_m = 'Value / FCY/PKR'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. *********************************************** BALANCE ********* fieldcatalog-fieldname = 'QTY'. " field Name fieldcatalog-seltext_m = 'QTY'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. fieldcatalog-fieldname = 'VALUE'. " field Name fieldcatalog-seltext_m = 'Value FCY/PKR'. " Field heading fieldcatalog-col_pos = 0. " col position fieldcatalog-outputlen = 10. " output Lenght fieldcatalog-key = 'X'. APPEND fieldcatalog TO fieldcatalog. CLEAR fieldcatalog. ENDFORM. " BUILD_FIELDCATALOG *&---------------------------------------------------------------------* *& Form BUILD_LAYOUT *&---------------------------------------------------------------------* * Build layout for ALV grid report *----------------------------------------------------------------------* FORM build_layout. gd_layout-no_input = 'X'. gd_layout-colwidth_optimize = 'X'. gd_layout-totals_text = 'Totals'(201). * gd_layout-totals_only = 'X'. * gd_layout-f2code = 'DISP'. "Sets fcode for when double * "click(press f2) * gd_layout-zebra = 'X'. * gd_layout-group_change_edit = 'X'. * gd_layout-header_text = 'helllllo'. ENDFORM. " BUILD_LAYOUT *&---------------------------------------------------------------------* *& Form DISPLAY_ALV_REPORT *&---------------------------------------------------------------------* * Display report using ALV grid *----------------------------------------------------------------------* FORM display_alv_report. gd_repid = sy-repid. CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_callback_program = gd_repid i_callback_top_of_page = 'TOP-OF-PAGE' "see FORM * i_callback_user_command = 'USER_COMMAND' * i_grid_title = outtext is_layout = gd_layout it_fieldcat = fieldcatalog[] * it_special_groups = gd_tabgroup it_events = gt_events is_print = gd_prntparams i_save = 'X' * is_variant = z_template TABLES t_outtab = it_itab 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. ENDFORM. " DISPLAY_ALV_REPORT *-------------------------------------------------------------------* * Form TOP-OF-PAGE * *-------------------------------------------------------------------* * ALV Report Header * *-------------------------------------------------------------------* FORM top-of-page. *ALV Header declarations DATA: t_header TYPE slis_t_listheader, wa_header TYPE slis_listheader, t_line LIKE wa_header-info, ld_lines TYPE i, ld_linesc(10) TYPE c. * Title wa_header-typ = 'H'. wa_header-info = 'Purchase Order Wise Financial Status Report'. APPEND wa_header TO t_header. CLEAR wa_header. * Date wa_header-typ = 'S'. wa_header-key = 'Date: '. CONCATENATE sy-datum+6(2) '.' sy-datum+4(2) '.' sy-datum(4) INTO wa_header-info. "todays date APPEND wa_header TO t_header. CLEAR: wa_header. * Total No. of Records Selected DESCRIBE TABLE it_itab LINES ld_lines. ld_linesc = ld_lines. CONCATENATE 'Total No. of Records Selected: ' ld_linesc INTO t_line SEPARATED BY space. wa_header-typ = 'A'. wa_header-info = t_line. APPEND wa_header TO t_header. CLEAR: wa_header, t_line. CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = t_header. * i_logo = 'Z_LOGO'. ENDFORM. "top-of-page *------------------------------------------------------------------* * FORM USER_COMMAND * *------------------------------------------------------------------* * --> R_UCOMM * * --> RS_SELFIELD * *------------------------------------------------------------------* *FORM user_command USING r_ucomm LIKE sy-ucomm * rs_selfield TYPE slis_selfield. * ** Check function code * CASE r_ucomm. * WHEN '&IC1'. ** Check field clicked on within ALVgrid report * IF rs_selfield-fieldname = 'EBELN'. ** Read data table, using index of row user clicked on * READ TABLE itab INTO wa_EKPO INDEX rs_selfield-tabindex. ** Set parameter ID for transaction screen field * SET PARAMETER ID 'BES' FIELD wa_EKPO-EBELN. ** Sxecute transaction ME23N, and skip initial data entry screen * CALL TRANSACTION 'ME23N' AND SKIP FIRST SCREEN. * ENDIF. * ENDCASE. *ENDFORM. *&---------------------------------------------------------------------* *& Form BUILD_EVENTS *&---------------------------------------------------------------------* * Build events table *----------------------------------------------------------------------* FORM build_events. DATA: ls_event TYPE slis_alv_event. CALL FUNCTION 'REUSE_ALV_EVENTS_GET' EXPORTING i_list_type = 0 IMPORTING et_events = gt_events[]. READ TABLE gt_events WITH KEY name = slis_ev_end_of_page INTO ls_event. IF sy-subrc = 0. MOVE 'END_OF_PAGE' TO ls_event-form. APPEND ls_event TO gt_events. ENDIF. READ TABLE gt_events WITH KEY name = slis_ev_end_of_list INTO ls_event. IF sy-subrc = 0. MOVE 'END_OF_LIST' TO ls_event-form. APPEND ls_event TO gt_events. ENDIF. ENDFORM. " BUILD_EVENTS *&---------------------------------------------------------------------* *& Form BUILD_PRINT_PARAMS *&---------------------------------------------------------------------* * Setup print parameters *----------------------------------------------------------------------* FORM build_print_params. gd_prntparams-reserve_lines = '3'. "Lines reserved for footer gd_prntparams-no_coverpage = 'X'. ENDFORM. " BUILD_PRINT_PARAMS *&---------------------------------------------------------------------* *& Form END_OF_PAGE *&---------------------------------------------------------------------* FORM end_of_page. DATA: listwidth TYPE i, ld_pagepos(10) TYPE c, ld_page(10) TYPE c. WRITE: sy-uline(50). SKIP. WRITE:/40 'Page:', sy-pagno . ENDFORM. "END_OF_PAGE *&---------------------------------------------------------------------* *& Form END_OF_LIST *&---------------------------------------------------------------------* FORM end_of_list. DATA: listwidth TYPE i, ld_pagepos(10) TYPE c, ld_page(10) TYPE c. SKIP. WRITE:/40 'Page:', sy-pagno . ENDFORM. "END_OF_LIST