How Calculate TOTALS,SUBTOTALS in ALV Reporting?

Answer Posted / gogo

1. You need 2 internal tables: FIELDCATALOG table and SORT table
DATA: gt_fieldcatalog TYPE lvc_t_fcat,
gt_fieldcatalog_sort TYPE lvc_t_sort,
lw_fcat TYPE lvc_s_fcat,
lw_fcat_sort TYPE lvc_s_sort.

2. Fill fieldcatalog table fields
lw_fcat-fieldname = 'YOUR FIELD NAME'.
* Subtotal for this field
lw_fcat-do_sum = 'X'.
APPEND lw_fcat TO gt_fieldcatalog.

3. Fill sort table fields
* Mark the fields that you want to make subtotals after
(e.g. VKORG KUNNR VBELN = keys ; NETWR = sum)
CASE 'YOUR FIELD NAME'.
WHEN 'VKORG' OR 'KUNNR'.
lw_fcat_sort-fieldname = u_fieldname.
lw_fcat_sort-up = 'X'.
lw_fcat_sort-subtot = 'X'.
APPEND lw_fcat_sort TO gt_fieldcatalog_sort.
WHEN OTHERS.
ENDCASE.

Risult
VKORG | KUNNR | VBELN |NETWR
1 a 001 10
1 a 002 20
1 a 003 30
----------------------------
subtotal 1 a 60
----------------------------
1 b 001 5
----------------------------
subtotal 1 b 5
----------------------------

Hope it helps!

Is This Answer Correct ?    25 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can one distinguish between different kinds of parameters? : abap modularization

588


What are two methods of modifying sap standard tables?

577


Explain the Inportance of pa40? : abap hr

574


How to write a code in tab control? : abap bdc

625


What are the different types of the sap abap data dictionary objects?

538






How is time management and payroll is integrated? : sap abap hr

555


Different types of locks?

623


What is the project you are currently working and work that you are doing

1012


What is pretty printer?

588


What should be the approach for writing a bdc program? : abap bdc

574


What are pooled tables? : abap data dictionary

657


How to specify a client for database table processing?

613


Explain badi in abap.

580


How would you suppress the display of a parameter on the selection screen?

559


What is Transactional based Application & Role based Application?

1040