Hi,
I am generating an ALV and want to do calculation at the end of rows, my code is below please guide me which is best way to do calculation
FORM DISPLAY_SM .
DATA: HEADER1(100) TYPE C.
HEADER1 = 'Department Report Orgnizational Unit Wise'.
PERFORM fill_fieldcat USING 'ORGEH' 10 'Organization Unit' 'TAB'.
PERFORM fill_fieldcat USING 'PERNR' 20 'Personnel Number' 'TAB'.
PERFORM fill_fieldcat USING 'ENAME' 22 ' EmpName' 'TAB'.
PERFORM fill_fieldcat USING 'PERSG' 6 'EE. Group' 'TAB'.
PERFORM fill_fieldcat USING 'PERSK' 18 'EE. Subgroup' 'TAB'.
PERFORM fill_fieldcat USING 'BASIC' 12 'Basic Salary' 'TAB'.
PERFORM fill_fieldcat USING 'TRANSPORT' 10 'Transportation' 'TAB'.
PERFORM fill_fieldcat USING 'HOUSING' 10 'Housing' 'TAB'.
PERFORM fill_fieldcat USING 'FOOD' 11 'Food ' 'TAB'.
PERFORM fill_fieldcat USING 'OTHERS' 11 'Others' 'TAB'.
PERFORM fill_fieldcat USING 'OVERTIME' 10 'Over Time' 'TAB'.
PERFORM fill_fieldcat USING 'BONUS' 11 'Bonus' 'TAB'.
PERFORM fill_fieldcat USING 'GROSS' 11 'Gross Salary' 'TAB'.
PERFORM fill_fieldcat USING 'GOSI' 11 'Gosi' 'TAB'.
PERFORM fill_fieldcat USING 'OTHER_DED' 11 'Other Deduct' 'TAB'.
PERFORM fill_fieldcat USING 'LOAN' 11 'Loan' 'TAB'.
PERFORM fill_fieldcat USING 'PLAC_FEE' 11 'Placement Fee' 'TAB'.
PERFORM fill_fieldcat USING 'SEC_DEP' 11 'Security Deposit' 'TAB'.
PERFORM fill_fieldcat USING 'ABSENT' 11 'Absent' 'TAB'.
PERFORM fill_fieldcat USING 'PLENTY' 11 'Plenty' 'TAB'.
PERFORM fill_fieldcat USING 'LATE' 11 'Late Attendance' 'TAB'.
PERFORM fill_fieldcat USING 'NET' 11 'Net Income' 'TAB'.
PERFORM add_heading_alv USING c_alv_head_header '' HEADER1.
* PERFORM add_heading_alv USING c_alv_head_selection '' HEADER1.
PERFORM display_alv USING TAB[].
endform.
DO I NEED TO MAKE FIELD LIKE THIS
fieldcatalog-fieldname = 'EBELN'.
fieldcatalog-seltext_m = 'Purchase Order'.
fieldcatalog-col_pos = 0.
fieldcatalog-outputlen = 10.
fieldcatalog-emphasize = 'X'.
fieldcatalog-key = 'X'.
* fieldcatalog-do_sum = 'X'.
* fieldcatalog-no_zero = 'X'.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
fieldcatalog-fieldname = 'EBELP'.
fieldcatalog-seltext_m = 'PO Item'.
fieldcatalog-col_pos = 1.
append fieldcatalog to fieldcatalog.
clear fieldcatalog.
REGARDS