Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

ALV subtotal text

Former Member
0 Likes
580

Hi,

i have two different internal tables

f1 and f2

keyfield is id

one is internal table with values and other one with text

at run for every id text should trigger .hereiam using f1 as header and f2 as item table.

can u please tell me what is mistake in following functional module

CALL FUNCTION 'REUSE_ALV_HIERSEQ_LIST_DISPLAY'

EXPORTING

  • I_INTERFACE_CHECK = ' '

i_callback_program = c_repid

  • I_CALLBACK_PF_STATUS_SET = ' '

i_callback_user_command = 'F_USER_COMMAND'

is_layout = ls_layout

it_fieldcat = gt_fieldcat

  • IT_EXCLUDING =

  • IT_SPECIAL_GROUPS =

  • it_sort = gt_sort

  • IT_FILTER =

  • IS_SEL_HIDE =

  • I_SCREEN_START_COLUMN = 0

  • I_SCREEN_START_LINE = 0

  • I_SCREEN_END_COLUMN = 0

  • I_SCREEN_END_LINE = 0

  • I_DEFAULT = 'X'

  • I_SAVE = ' '

  • IS_VARIANT =

it_events = gt_events

  • IT_EVENT_EXIT =

i_tabname_header = 'GT_FINAL'

i_tabname_item = 'GT_TEXT'

  • I_STRUCTURE_NAME_HEADER =

  • I_STRUCTURE_NAME_ITEM =

is_keyinfo = ls_keyinfo

  • IS_PRINT =

  • IS_REPREP_ID =

  • I_BYPASSING_BUFFER =

  • I_BUFFER_ACTIVE =

  • IMPORTING

  • E_EXIT_CAUSED_BY_CALLER =

  • ES_EXIT_CAUSED_BY_USER =

TABLES

t_outtab_header = gt_final

t_outtab_item = gt_text

  • 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.

where

f1

id objecid posdt appr_id

se23 45-67 6/7/2008 system

se24 67-78 5/7/2008 se24

se24 69-80 4/5/2008 system

f2

id total of system per

se23 1 100%

se24 1 50%

output

se23 45-67 6/7/2008 system

total of system 1

per 100%

se24 67-78 5/7/2008 se24

se24 69-80 4/5/2008 system

total of system 1

per 50%

regards

jansi

1 ACCEPTED SOLUTION
Read only

0 Likes
554

Hi Janse,

decalre do_sum in the feild catalog declaration.

it_fieldcatalog-do_sum = 'X'. for the field in F1 internal table.

Thanks,

nelson

Hi,

i have two different internal tables

f1 and f2

keyfield is id

one is internal table with values and other one with text

at run for every id text should trigger .hereiam using f1 as header and f2 as item table.

can u please tell me what is mistake in following functional module

CALL FUNCTION 'REUSE_ALV_HIERSEQ_LIST_DISPLAY'

EXPORTING

  • I_INTERFACE_CHECK = ' '

i_callback_program = c_repid

  • I_CALLBACK_PF_STATUS_SET = ' '

i_callback_user_command = 'F_USER_COMMAND'

is_layout = ls_layout

it_fieldcat = gt_fieldcat

  • IT_EXCLUDING =

  • IT_SPECIAL_GROUPS =

  • it_sort = gt_sort

  • IT_FILTER =

  • IS_SEL_HIDE =

  • I_SCREEN_START_COLUMN = 0

  • I_SCREEN_START_LINE = 0

  • I_SCREEN_END_COLUMN = 0

  • I_SCREEN_END_LINE = 0

  • I_DEFAULT = 'X'

  • I_SAVE = ' '

  • IS_VARIANT =

it_events = gt_events

  • IT_EVENT_EXIT =

i_tabname_header = 'GT_FINAL'

i_tabname_item = 'GT_TEXT'

  • I_STRUCTURE_NAME_HEADER =

  • I_STRUCTURE_NAME_ITEM =

is_keyinfo = ls_keyinfo

  • IS_PRINT =

  • IS_REPREP_ID =

  • I_BYPASSING_BUFFER =

  • I_BUFFER_ACTIVE =

  • IMPORTING

  • E_EXIT_CAUSED_BY_CALLER =

  • ES_EXIT_CAUSED_BY_USER =

TABLES

t_outtab_header = gt_final

t_outtab_item = gt_text

  • 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.

where

f1

id objecid posdt appr_id

se23 45-67 6/7/2008 system

se24 67-78 5/7/2008 se24

se24 69-80 4/5/2008 system

f2

id total of system per

se23 1 100%

se24 1 50%

output

se23 45-67 6/7/2008 system

total of system 1

per 100%

se24 67-78 5/7/2008 se24

se24 69-80 4/5/2008 system

total of system 1

per 50%

regards

jansi

3 REPLIES 3
Read only

0 Likes
555

Hi Janse,

decalre do_sum in the feild catalog declaration.

it_fieldcatalog-do_sum = 'X'. for the field in F1 internal table.

Thanks,

nelson

Read only

0 Likes
554

Hi nelson,

thanks for your input.

but when iam running this fm iam getting empty table in output

where gt_final and gt_text are having entries.

and key field is id.

regards

jansi

Read only

Former Member
0 Likes
554

Hi,

Can you plz explain your requirement clearly?

Do you want the total to appear in the ALV report?

If so use the "do-sum" in your field catalogue as given below,

WA_FIELDCATALOG-DO_SUM = 'X'.

For sub-total text use Slis_ev_subtotal_text TYPE slis_formname VALUE 'SUBTOTAL_TEXT'.

Please view the below site,it may be useful for you,

http://www.abapprogramming.net/2007/07/alv-documentation-complete.html

Regards,

P.S.Chitra