topic Re: ALV -- Do Sum ? in Application Development and Automation Discussions

ALV -- Do Sum ?

Former Member — Sun, 11 Jan 2009 07:52:39 GMT

Hi experts,

In my ALV output, I have done sub-total for all the fields using int_FCAT-do_sum = 'X' in field catalogue. I dont want the values to be displayed in output. I need to display only the total sum values at the end. How to hide the values in the column other than sum values at the end in ALV?

For e.g if the alv is shown as below:

1 12 1

2 10 1

3 20 1

6 42 3

2 01 1

3 05 3

5 06 4

In this above output how to hide the values in column 1 that is how to hide the values 1,2,3 in and how to hide the values in 2 & 3. But I need to display the subtotal values 6 & 5 at the end.

Regards,

Sakthi

Edited by: Sakthi Saravanan C on Jan 11, 2009 1:23 PM

Re: ALV -- Do Sum ?

Former Member — Sun, 11 Jan 2009 08:48:25 GMT

This message was moderated.

Re: ALV -- Do Sum ?

I355602 — Mon, 12 Jan 2009 07:31:37 GMT

Hi,

Use parameter totals_only in slis_layout_alv if using REUSE_ALV_GRID_DISPLAY.

Double click from report program on slis_layout_alv and then double click in slis_layout_alv_spec and then click slis_layout_alv_spec1.

Here you can check the section for Sums and use totals_only(1) type c, " show only totals.

Hope this helps you.

Thanks & Regards,

Tarun Gambhir

Re: ALV -- Do Sum ?

Former Member — Mon, 12 Jan 2009 07:36:11 GMT

you can do one thing

insted of writing FCAT-do_sum = 'X' , you can write the logic to do the sum of your column

and then append that sum atyour internal table,

Re: ALV -- Do Sum ?

Former Member — Mon, 12 Jan 2009 07:36:40 GMT

Go thru dis link...

http://www.sapfans.com/forums/viewtopic.php?t=20386

Re: ALV -- Do Sum ?

Former Member — Sun, 18 Jan 2009 07:15:06 GMT

Problem solved thank you