topic Re: Problems with itab: subtotal in Application Development and Automation Discussions

Problems with itab: subtotal

Former Member — Tue, 11 Dec 2007 14:04:34 GMT

hi,

i've got some problems with the report which i should write.

i have to move to the negative values of the itab-field betrh to the itab-field verb and the positiv to the itab-field ford, but i don't know how to do this.

i have to make sub-totals for each gpart which should be displayed in the alv-grid in the itab-field Saldo.

DATA: BEGIN OF itab OCCURS 1000,

      gs       TYPE dimaiobpar-zgst,
      status   TYPE dimaiobpar-zstatus,
      bukrs    TYPE dfkkop-bukrs,
      betrh    TYPE dfkkop-betrh,
      verb     TYPE dfkkop-betrh,
      ford     TYPE dfkkop-betrh,
      saldo    TYPE dfkkop-betrh,
      gpart    TYPE dfkkop-gpart,
      vtref    TYPE dfkkop-vtref,
      mtyp     TYPE dimabroker-brostmtyp,
      n1       TYPE adrc-name1,
      n2       TYPE adrc-name2,
      n3       TYPE adrc-name3,
      abrtyp   TYPE dimaiobpar-zabrtyp,
      vertart  TYPE dimaiobpar-zvat,
      zrtyp    TYPE dimaiobpar-azawe_x,
      opbel    TYPE dfkkop-opbel,

      END OF itab.

regards,

Tobias

Re: Problems with itab: subtotal

Former Member — Tue, 11 Dec 2007 14:19:13 GMT

Hi,

Once data is populated into itab which -ve and +ve values .

Loop at itab.

if itab-betrh LT 0.
itab-verb = itab-betrh
else.
itab-ford = itab-betrh.
endif.
modify itab.
clear itab.
endloop.

before ALV display add the below code :

  DATA: ls_sort TYPE slis_sortinfo_alv,
             gt_sort       TYPE slis_t_sortinfo_alv.


  CLEAR ls_sort.
  ls_sort-fieldname = 'SALDO'.
  ls_sort-up        = 'X'.
  ls_sort-subtot    = 'X'.
  APPEND ls_sort TO gt_sort.

And pass gt_sort to it_sort of ALV grid display export parameter.

Thanks,

Sriram Ponna.

Re: Problems with itab: subtotal

Former Member — Tue, 11 Dec 2007 14:21:49 GMT

Hi,

loop at itab.

if itab-betrh < 0.

itab-verb = itab-betrh.

else if itab-betrh > 0.

itab-ford = itab-betrh.

endif.

modify itab.

at end of (changing field name for which u want to add totals)

sum.

itab-saldo = itab-gpart.

endat.

modify itab.

endloop.

Try as above

Regards,

Subbu

Re: Problems with itab: subtotal

Former Member — Tue, 11 Dec 2007 14:25:14 GMT

Hi,

1.) You can loop the table itab and if the value of berth is negagive, move the same to itab-field VERB else move the values to the field Itab-field ford.

at the end of the loop modify your table itab.

2.) For Subtotal, while preparing sort table of your field catalaog, say subtotal = 'X'. If you are not able to find this read the documentation of the FM, to get details. You should get to know some more things tis way.

Hope this would help.

Regards,

Lalit

Re: Problems with itab: subtotal

Former Member — Tue, 11 Dec 2007 15:07:30 GMT

ok thx

the loop is working.

but the subtotal only makes a summary of the itab-field ford.

i need the subtotal of ford and verb so that i get the account balance for each gpart.