Skip to Content
0
Former Member
Nov 01, 2012 at 07:15 AM

ALV calculation issue

50 Views

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