ALV Subtotal

[Former Member]

Hi experts,

attached is a picture of my report.

Can i put the value of the subtotal into a variable? Because i need to put the subtotal into another ALV by year.

Here is my code in getting the subtotal in alv.

   x_fieldcat-fieldname = 'GRADUATES'.

   x_fieldcat-seltext_l = 'Graduates'.

   x_fieldcat-tabname = 'it_detailed'.

   x_fieldcat-col_pos = 5.

   x_fieldcat-outputlen = '17'.

   x_fieldcat-do_sum = 'X'.

   APPEND x_fieldcat TO it_fieldcat.

   CLEAR x_fieldcat.

Like, gv_subtot = x_fieldcat-do_sum = 'X'.

is there any way that i can do that?

Thanks.

[Former Member]

Hi experts,

attached is a picture of my report.

Can i put the value of the subtotal into a variable? Because i need to put the subtotal into another ALV by year.

Here is my code in getting the subtotal in alv.

   x_fieldcat-fieldname = 'GRADUATES'.

   x_fieldcat-seltext_l = 'Graduates'.

   x_fieldcat-tabname = 'it_detailed'.

   x_fieldcat-col_pos = 5.

   x_fieldcat-outputlen = '17'.

   x_fieldcat-do_sum = 'X'.

   APPEND x_fieldcat TO it_fieldcat.

   CLEAR x_fieldcat.

Like, gv_subtot = x_fieldcat-do_sum = 'X'.

is there any way that i can do that?

Thanks.

[Former Member]

Hi,

Check the below link :

http://scn.sap.com/thread/519906ALV Subtotal

[anubhab]

Hi Jepoy,

Please check the below link, it might be helpful...

http://scn.sap.com/thread/519906

Regards,

Anubhab

[Former Member]

Hi Jepoy,

You can use the method of the alv grid object given below:

CALL METHOD  <ref. var. to CL_GUI_ALV_GRID > ->get_subtotals.

[Former Member]

Hi,

I am using the OOPS and alv grid. The code i used is

CALL METHOD obj->fieldcatalog    (Calling a method)
    EXPORTING
      fieldname   = 'ROM_NO'
      tablename   = 'T_ROOM_BOOK'
      length      = '12'
      text        = 'Room Num'(004)
      hotspot     = 'X'
      do_sum      = ' '
      emphasize   = 'X'
    IMPORTING
      t_fieldcat = t_fieldcat.

Where t_fieldcat in an internal table for fieldcatalog.

Try this way,may it works. It works fine with mine.

Pass t_fieldcat to the grid function module calling ot through the grid object

set_table_for_first_display

    it_fieldcatalog               = t_fieldcat

Regards

[Former Member]

Hi Amar,

    Here you are using fieldcatalog method.Can you please give me the SAP Class name?. I searched in CL_GUI_ALV_GRID.It is not exist. Please give me details.                                                                                                                                                                      

Thanks

Satya

[Former Member]

Hi

Fieldcatalog is not a standard method.I said i am using OOPS and gird view. This is what i coded.

Class C1 Implementation.

Method

fieldcatalog IMPORTING   tablename   TYPE lvc_tname   

                                        fieldname   TYPE lvc_fname
                                        length      TYPE lvc_outlen
                                        text        TYPE lvc_txt
                                        hotspot     TYPE lvc_hotspt
                                        emphasize    TYPE lvc_emphsz
                             EXPORTING  t_fieldcat TYPE lvc_t_fcat,

Endmethod.

Endclass

DATA obj_c1 TYPE REF TO c1.

START-OF-SELECTION.
CREATE OBJECT obj_c1. 

CALL METHOD obj->fieldcatalog    (Calling a method)
    EXPORTING
      fieldname   = 'ROM_NO'                     "Field Name
      tablename   = 'T_ROOM_BOOK'        " Internal Table
      length      = '12'
      text        = 'Room Num'
      hotspot     = 'X'
      do_sum      = ' '
      emphasize   = 'X'
    IMPORTING
      t_fieldcat = t_fieldcat.

I think the case with you is because of the way you are passing the variables to the fieldcatalog table fields. See that you provide the inverted commas properly. Sometime that can be an issue

Hope this time it works fine as it worked for mine.

Regards.

[Former Member]

Thanks for your quick response and good solution..

[Former Member]

Hi Jepoy,

Folow this documentation .

http://help.sap.com/saphelp_erp2004/helpdata/en/9e/2c7b38180fee45e10000009b38f8cf/content.htm

Check this sample code.

http://www.sapwiki.cl/wiki/index.php?title=SAP_ABAP_ALV_cl_gui_alv_grid

[Former Member]

Hii calix,

you can't assign like

gv_subtot = x_fieldcat-do_sum = 'X'.

It will give u a dump.

To get subtotal u have to called the method get_subtotals of class cl_gui_alv_grid.

Do like below

Data: obj_grid type ref to cl_gui_alv_grid,

           subtotal type ref to data.

field-symbol <subtotal> like <internal table> which u r displaying in alv

CALL METHOD obj_grid->get_subtotals
  IMPORTING
    ep_collect00   = subtotal.              ---------this will hold the subtotal value.

    
assign subtotal->* to  <subtotal>.

now proceed according to requirement

regards

Syed