summation of netvalues with currency in alv

[Former Member]

Hi,

how to display subtotals of netvalues currency wise at bottom of alv grid display ?

Thanks & Regards ,

PRadeep

[former_member632729]

Hi ,

at sort section use this..it sort lifnr wise and do sum..

FORM sort_alv .

wa_sort-spos = 1.

wa_sort-fieldname = 'LIFNR'.

wa_sort-up = 'X'.

wa_sort-subtot = 'X'.

APPEND wa_sort TO it_sort.

ENDFORM. "sort_alv

Hope Helpfull

Raghunath.S

[Former Member]

thanks for ur reply.but, i want to display totals currency wise only at the bottom of list

[GauthamV]

hi,

use this.

  fieldcatalog-fieldname   = 'WRBTR'.
  fieldcatalog-REF_TABNAME   = 'BSEG'.
   fieldcatalog-seltext_l   = 'TRANSACTION CURRRENCY'.
  fieldcatalog-col_pos     = 17.
   fieldcatalog-cfieldname   = 'WAERS'.     < -----     you should give this
  fieldcatalog-do_sum   = 'X'.
  fieldcatalog-emphasize   = 'X'.
  append fieldcatalog to fieldcatalog.
  clear  fieldcatalog.

[Former Member]

for example plz refer BCALV_TEMPLATE

[Former Member]

For above replies , the totals will be displayed only at the middle of list i;e; before currency changes .but i want to display them at the bottom of list

[Former Member]

For example if u want to display at end of particulat item,

then use at end of ebeln (ex).

....

endat.

[Former Member]

Hi Jansi Dorai ,

i am displaying in alv grid and i want at bottom of list.

Regards,

Pradeep

[Former Member]

Hi Gautam,

my problem solved by following ur code .

Thanks a lot and i am closing this thread.

With Regards,

Pradeep

[Former Member]

Thanks a lot to u all and i am closing this thread.

[Former Member]

select the field sub_tot from fieldcatalog table.