Skip to Content
0
Former Member
Jul 18, 2006 at 06:32 AM

Is it possible to get the breakup of subtotals got by subtot of sort table.

16 Views

I have developed a alv report by using the 'REUSE_ALV_GRID_DISPLAY' function module, in this I have got the grand total by using the do_sum field from the fieldcatalog table i.e.(slis_t_fieldcat_alv)

And I have got the subtotals by using the subtot field from the (slis_t_sortinfo_alv) table.Now the issue is that user needs the break up of this subtotals & also the grand totals.

Is it possible for me to get the break up of Subtotals & Totals. I can explain it further with an e.g. as follows.

Suppose there is a report whose o/p is displayed in an 'REUSE_ALV_GRID_DISPLAY' and the subtotals is occuring on the base of 4 field levels such as GMI DIVISION, MFG PLATFORM, PNL & LOCATION, now sub-totalling occurs on every level change and the last grand totalling takes place as per the do_sum checked for the field catalog, now suppose the group subtotal for the Mfg Platform is 9, which is actual totalling of three fields of the label column which is constant such as, the fields in the label column are.

Fixed by Horizon = 6

Fixed by User = 3

Not Fixed = 0

for the DRYD manufacturing platform level which occurs for every level change of 4 levels described(GMI DIVISION,MFG PLATFORM,PNL & LOCATION). Now the subtotal of these 4 levels is 9 after going through different levels.But the user now wants to see the last subtotal as a break up of column LABEL.

Fixed by Horizon = 6

Fixed by User = 3

Not Fixed = 0

Instead of Plain subtotal as DRYD with 3 dots (i.e. the grouping level) 9.

Is there any way out for the user to show the subtotal in the break as explained.

Hope to get some ideas ont this.

Thanks in Advance.

Regards,

Sanjay.