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
How can one distinguish between different kinds of parameters? : abap modularization
What are two methods of modifying sap standard tables?
Explain the Inportance of pa40? : abap hr
How to write a code in tab control? : abap bdc
What are the different types of the sap abap data dictionary objects?
How is time management and payroll is integrated? : sap abap hr
Different types of locks?
What is the project you are currently working and work that you are doing
What is pretty printer?
What should be the approach for writing a bdc program? : abap bdc
What are pooled tables? : abap data dictionary
How to specify a client for database table processing?
Explain badi in abap.
How would you suppress the display of a parameter on the selection screen?
What is Transactional based Application & Role based Application?