There are three line items for all main account types : general ledger account, vendor account and customer account, the transaction code are listed here :
1.FBL1N is vendor line-items report
2.FBL3N is General Ledger account line-items report
3.FBL5N is Customer Line items report.
Technically, All line items report look very similar, All report based on logical database : SDF for General Ledger Accounts, KDF for customer account ( account receivables ) and LDF for vendor ( account payables ).
All of three report use same function group FI_ITEMS for report output and FI_ITEMS_DISPLAY is used for ALV output.
BTE Event 1640
In this article we will explain how to change result list header and footer of line items report by using BTE Event 1640 ( Line Item Display : Additional Header Lines ). This BTE Event is called only when output is formatted using ALV List and not called in ALV Grid Formatted List.
We assume you know how to implement SAP BTE ( Business Transaction Event ), Ok go to FIBF Transaction code and setting up all BTE needed. After all setup finished you can paste this code into BTE Function module.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | FUNCTION z_interface_00001640. *"---------------------------------------------------------------------- *"*"Local Interface: *" IMPORTING *" VALUE(I_RFXPO) LIKE RFXPO STRUCTURE RFXPO *" VALUE(I_KNA1) LIKE KNA1 STRUCTURE KNA1 *" VALUE(I_LFA1) LIKE LFA1 STRUCTURE LFA1 *" VALUE(I_SKA1) LIKE SKA1 STRUCTURE SKA1 *" EXPORTING *" VALUE(E_SUPPRESS_STANDARD) LIKE BOOLE-BOOLE *" TABLES *" T_LINES STRUCTURE EPTEXT *"---------------------------------------------------------------------- CASE i_rfxpo-koart. WHEN 'S'. * “gl accounts t_lines-color = '4'. t_lines-text = 'LAPORAN GL ACCOUNT'. APPEND t_lines. WHEN 'D'. "Customer WHEN 'K'. "Vendor ENDCASE. ENDFUNCTION. |
We put header text into FBL3N ( GL Account Report ) only. This is the result if you open FBL3N.
