topic Re: ALV in Application Development and Automation Discussions

ALV

Former Member — Wed, 28 Feb 2007 14:36:31 GMT

Hello All,

Can anybody explain how to display Grand Total of a field directly <b>(not by selecting a column and clicking on Total button)</b> when i execute a report.

And how i can i display a text for a field which i calculated the total.

Thanks and Regards

Madhavi

Message was edited by:

madhavi p

Re: ALV

Former Member — Wed, 28 Feb 2007 14:42:33 GMT

1. In fieldcatalog  for that field

     wA_fieldcat-do_sum = 'X'.

2. to display text

     wa_layout-totals_text = 'total'.

Re: ALV

Former Member — Wed, 28 Feb 2007 14:42:44 GMT

hi madhavi,

DATA: S_LAYOUT TYPE SLIS_LAYOUT_ALV.

For Text:

s_layout-totals_text = 'TOTALS:'.

DATA: IT_FLDCAT TYPE STANDARD TABLE OF

SLIS_FIELDCAT_ALV WITH HEADER LINE.

it_fldcat-fieldname = 'KWMENG'.

it_fldcat-tabname = 'ITAB'.

it_fldcat-seltext_m = 'QUANTITY'.

it_fldcat-outputlen = 15.

it_fldcat-do_sum = 'X'.

APPEND it_fldcat.

regards,

priya.

Message was edited by:

Priya

Re: ALV

Former Member — Wed, 28 Feb 2007 15:13:45 GMT

I wonder whats wrong with my answer?

Re: ALV

Former Member — Wed, 28 Feb 2007 15:18:49 GMT

Hi..

I am able to change the fieldnames and displaying the total. But i have to get

the totals text at the bottom of the list like

TOTAL = 1000.

regards

Madhavi

Re: ALV

Former Member — Wed, 28 Feb 2007 15:23:12 GMT

Yes i had mentioned that <b>wa_layout-totals_text = 'total'.</b>

Re: ALV

Former Member — Wed, 28 Feb 2007 15:27:49 GMT

This is not the correct way of assigning points. 6+6 for my 2 answers is too much

Re: ALV

Former Member — Wed, 28 Feb 2007 15:31:36 GMT

Hi..

Sorry for that...

I am still not getting it. Could you please elobarate where and How exactly i have to use it.

regards

Madhavi

Re: ALV

gary_king2 — Wed, 28 Feb 2007 16:07:24 GMT

If I were you I would have looked at the many examples of ALV available.

Take a look at the package 'SLIS' for tonnes of examples...of which a fair few use totals.

Dr Sidewalk