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 do you activate a function exit?
What is hotspot?
What is the tcode to create indexes?
Explain the difference between a dialog program and a report?
What is repository info. Systems?
What are the data types of internal tables?
What happens if only one of the commands set screen and leave screen is used without using the other?
What are the two ways for restricting the value range for a domain? : sap abap data dictionary
Name a few data dictionary objects? : abap data dictionary
What are the organizational related infotypes? : abap hr
How can you access the function code from menu painter?
What is a multiple line field? : abap bdc
The data of a view is not physically stored, but derived from one or more tables (t/f) : abap data dictionary
What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
how to read the standard field value in your custom program.