Display Only Subtotals lines in ALV

[Former Member]

Hi All,

I am using FM REUSE_ALV_LIST_DISPLAY for alv display. I am summing few field on the changes of BUKRS.

Requirement is to display only subtotals lines in ALV and not the items lines.

Which field in layout structure , fieldcatelog or sort structure will be used for this...

[Former Member · Accepted solution]

Hi again,

1. Simply doing this won't work.

2. We have to do SOME EXTRA thing also.

3. srtwa-expa = 'X'.

4. Just check out this program (copy paste in new program)

IT WILL SHOW ONLY TOTALS

(NOT DETAIL LINES)

<b>IMPRTANT THING IS : srtwa-expa = 'X'.</b>

5.

REPORT abc.

*----

---

NECESSARY / MUST

TYPE-POOLS : slis.

DATA : alvfc TYPE slis_t_fieldcat_alv.

DATA : fcwa TYPE slis_fieldcat_alv.

DATA : alvly TYPE slis_layout_alv.

DATA : alvsrt TYPE slis_t_sortinfo_alv.

DATA : srtwa TYPE slis_sortinfo_alv.

DATA : BEGIN OF itab OCCURS 0,

f1(3) TYPE c,

f2(25) TYPE c,

f3 TYPE i,

END OF itab.

*----

---

itab-f1 = '10c'.

itab-f2 = 'Description1'.

itab-f3 = 24.

APPEND itab.

itab-f1 = '10c'.

itab-f2 = 'Description1'.

itab-f3 = 34.

APPEND itab.

itab-f1 = '10c'.

itab-f2 = 'Description1'.

itab-f3 = 12.

APPEND itab.

*----

---

CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'

EXPORTING

i_program_name = sy-repid

i_internal_tabname = 'ITAB'

i_inclname = sy-repid

CHANGING

ct_fieldcat = alvfc

EXCEPTIONS

inconsistent_interface = 1

program_error = 2

OTHERS = 3.

*----

---

IMPORTANT

LOOP AT alvfc INTO fcwa.

IF fcwa-fieldname = 'F3'.

fcwa-do_sum = 'X'.

ENDIF.

MODIFY alvfc FROM fcwa.

ENDLOOP.

*----

---

IMPORTANT

srtwa-fieldname = 'F1'.

srtwa-expa = 'X'.

srtwa-spos = 1.

*SRTWA-GROUP = 'X'.

APPEND srtwa TO alvsrt.

srtwa-fieldname = 'F2'.

srtwa-subtot = 'X'.

srtwa-spos = 2.

APPEND srtwa TO alvsrt.

*alvly-totals_only = 'X'.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

it_fieldcat = alvfc

i_callback_program = sy-repid

is_layout = alvly

it_sort = alvsrt

i_save = 'A'

TABLES

t_outtab = itab

EXCEPTIONS

program_error = 1

OTHERS = 2.

regards,

amit m.

[Former Member · Accepted solution]

Hi Amit,

it works ... thanks...

Pawan.

[Former Member]

Hi Pawan,

well, you could display the list, show only the subtotals (menu Settings > Summation levels > Specify breakdown) and save the layout as default setting.

I hope this helps. BR,

Alvaro

[Former Member]

Hi,

just try out this,

DEFINE m_sort.

add 1 to ls_sort-spos.

ls_sort-fieldname = &1.

ls_sort-up = 'X'.

ls_sort-subtot = &2.

append ls_sort to lt_sort.

END-OF-DEFINITION.

for furhter more details check out this link,

http://www.sap-basis-abap.com/abap/alv-grid-list-with-sub-totals.htm.

Hope this may help you.

regards, prema.A

[Former Member]

Hi

You can do that by sort table: infact here you can decide which fields to be used for subtotal and if list has to be collapsed.

Field is EXPA

lt_sort-fieldname = <FIELD>.

lt_sort-up = 'X'.

lt_sort-subtot = 'X'.

lt_sort-expa = 'X'.

APPEND lt_sort TO gt_sort.

Max

[Former Member]

I already used totals_only field of layout but it is not giving me desire output. In fact there is no diffrence in ALV list

[Former Member]

Hi again,

1. Yes, u are right.

In fact, that is not at all required.

2. Please read my previous reply.

U r query will get solved.

regards,

amit m.

[Former Member]

hi pawan,

1. layout-totals_only = 'X'.

regards,

amit m.