topic Re: ALV grid Display in Application Development and Automation Discussions

ALV grid Display

Former Member — Wed, 19 Mar 2008 14:44:56 GMT

HI experts,

I have ALV grid display with subtotals and grandtotols by company code BUKRS.

But My requirment is.

How to have subtotals.

separtely at end of layout.

It fine to have same layout or other layout on same page.

All company codes should appear at one place to see subtotals.

Kindly help.

Thanks.

Re: ALV grid Display

Former Member — Wed, 19 Mar 2008 14:47:07 GMT

Hi,

Please refer the code below and for summation use gs_fieldcat-do_sum = 'X':

ALV data declarations

data: it_sortcat type slis_sortinfo_alv occurs 1,

wa_sort like line of it_sortcat.

perform build_sortcat.

&----

*& Form build_sortcat

&----

Build Sort catalog

----

FORM build_sortcat .

wa_sort-spos = 1.

wa_sort-fieldname = 'EBELN'.

wa_sort-SUBTOT = 'X'. "subtotals any totals column by this field

gd_sortcat-tabname

APPEND wa_sort TO it_sortcat.

wa_sort-spos = 2.

wa_sort-fieldname = 'EBELP'.

gd_sortcat-tabname

APPEND wa_sort TO it_sortcat.

ENDFORM. " build_sortcat

call function 'REUSE_ALV_GRID_DISPLAY'

exporting

i_callback_program = gd_repid

i_callback_top_of_page = 'TOP-OF-PAGE'

is_layout = gd_layout

it_fieldcat = fieldcatalog[]

it_sort = it_sortcat

i_save = 'X'

tables

t_outtab = it_ekko

exceptions

program_error = 1

others = 2.

Thanks,

Sriram Ponna.

Re: ALV grid Display

Former Member — Wed, 19 Mar 2008 14:49:15 GMT

Hi Reddy,

Which method are you using to display ALV Grid?

Functional Module Methods or Object Oriented??

Regards

Madhu.

Re: ALV grid Display

Former Member — Wed, 19 Mar 2008 14:50:35 GMT

sriram.

Thanks for your reply.

But I have done those.

But i need to save sperately at botoom of the layout.

or different layout at bottom of main layout.

ex:

BUKRS1 = 1,234.

BUKRS2 = 2.233.

etc...

Re: ALV grid Display

Former Member — Wed, 19 Mar 2008 14:51:15 GMT

Function module method

Re: ALV grid Display

Former Member — Wed, 19 Mar 2008 14:52:29 GMT

Hi,

To display sub-totals in ALV , Use SORT Tables of TYPE Slis_sortinfo_alv.

x_sort-fieldname = 'BUKRS'.

x_sort-spos = '1'.

x_sort-up = 'X'.

x_sort-group = '*'.

x_sort-subtot = 'X'.

APPEND x_sort TO t_sort.

To display Sub-total lines only , use TOTLINES_ONLY in the fieldcatalog to 'X'.

<REMOVED BY MODERATOR>

Regards

Rose

Edited by: Alvaro Tejada Galindo on Mar 19, 2008 5:04 PM

Re: ALV grid Display

Former Member — Wed, 20 Jul 2011 08:07:00 GMT

Self answered