Subtotal option is missing in ALV output in a screen.

[Former Member]

Dear All,

I am taking ALV Output in a screen using method SET_TABLE_FOR_FIRST_DISPLAY.

My ALV is displaying fine but Subtotal functioanlity and Subtotal Tool is missing in ALV Toolbar.

My Output internal table is having data type of type I.

I created fieldcatalog manually I tried to use Do_Sum = 'X' in fieldcatalog but it fails.

Any suggestion how to resolve this issue?

Regards,

Amit

Edited by: Amit Singh on Jan 24, 2011 8:08 AM

[Former Member]

Dear Amit;

you work strurcture for subtotal in structure u have field named

Do_Sum = 'X' set this field which are u want to calculate subtotal.

and plz do refer to the links also

Thanks.

Rakan ALDossary.

[SuhaSaha]

Hello Amit,

You need to pass the corresponding details to the interface param IT_SORT (SUBTOT = 'X') during the call to the method SET_TABLE_FOR_FIRST_DISPLAY.

Search the forum for further details.

BR,

Suhas

[Former Member]

Hi Amit.

For the same fieldcatalog define data type as INT4.

For eg.

wa_fieldcat-fieldname = 'Integer'.

wa_fieldcat-do_sum = 'X'.

wa_fieldcat-datatype = 'INT4'.

and in the layout.

wa_layout-totals_only = 'X'.

wa_layout-subtotals_text = 'Subtotal of Integer'.

I hope this will work.

Best Regard,

Nikhil Patil

Edited by: Nikhil Patil on Jan 24, 2011 9:13 AM

[Former Member]

Thanks a lot to all of you for your quick response.

I used DO_SUM = 'X' and DATATYPE = 'INT4' only.

Now problem has been resolved.

Amit