ALV Display

22 Views

Hi,

I am unable to display Sum option in ALV Display.My code is as below.

Please look into it and advise me.

I am using add fields instead of fieldcatalog.The code is as below but i am unable to display sum please advise.

DEFINE add_field.

clear wa_alv_fields.

wa_alv_fields-tabname = 'INT_final'. " INTERNAL OUTPUT TABLE

wa_alv_fields-fieldname = &1. " FIELD NAME FROM INT.

wa_alv_fields-seltext_l = &2. " LONG TEXT

wa_alv_fields-ddictxt = &3. " FORCE HEADER TEXT

wa_alv_fields-ref_tabname = &4. " DDIC TABLE NAME

wa_alv_fields-datatype = &5. " DATATYPE FOR NON DDIC

wa_alv_fields-hotspot = &6. "HOTSPOT

wa_alv_fields-do_sum = &7.

append wa_alv_fields to int_alv_fields.

END-OF-DEFINITION.

int_layout-colwidth_optimize = 'X'.

Add fields to display

add_field 'ZCONT' 'Contract Number' 'L' 'ZOIL_CONTRACTS' '' ''

''.

add_field 'ZSTART' 'Start Date' 'L' 'ZOIL_CONTRACTS' '' ''

''.

add_field 'ZEND' 'End Date' 'L' 'ZOIL_CONTRACTS' '' ''

''.

add_field 'NAME1' 'Ven/Cust Name' 'L' 'LFA1-NAME1' '' ''

''.

add_field 'VOLUME' 'Volume Opening Bal' 'L' 'ZOIL_CONTRACT_OB' '' ''

''.

add_field 'VOLUME_M' 'Volume Current Month' 'L' 'ZOIL_FIN_DET' '' 'X'

'X'.

add_field 'VOLUME_Y' 'Volume Current Year' 'L' 'ZOIL_FIN_DET' '' 'X'

'X' .

add_field 'VOLUME_I' 'Volume Total' 'L' 'ZOIL_FIN_DET' '' 'X'

'X'.

And FM is as below

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_callback_program = s_repid

is_layout = int_layout

it_fieldcat = int_alv_fields

i_callback_user_command = 'USER_COMMAND'

i_save = 'A'

TABLES

t_outtab = int_final

EXCEPTIONS

program_error = 1

OTHERS = 2.

Is there anything to add in FM.

Thanks,

Pavan.