Interested to Buy Any Domain ? << Click Here >> for more details...
How Calculate TOTALS,SUBTOTALS in ALV Reporting?
- 7 Answers
- 54494 Views
- HP, Satyam, I also Faced
- E-Mail Answers
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
What is a data class? : abap data dictionary
Work most on which module: name a few tables?
What is smart forms? : abap hr
We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???
how 2 create the normal form by using functional module
How will you insert record in a sorted table
How do you get the number of lines in an internal table?
SAP Script for Billing in which Billing document number was displayed as header, Bill Type, Bill Category, Bill Item, Cost, Base Unit of Measurement and Material number were categorically displayed for each billing document number. plz mention the detail coding Tahnks, Rahul
Explain the disadvantages of abap query tool?
What is the maximum number of structures that can be included in a table or structure : abap data dictionary
What are the different functions used in sap script? What are the parameters used in each function?
In order to upload purchase order details, how you handle multiple values for a single field?
How can end-of-selection be used?
Explain the relationship between a functional area, user group, and query when developing queries using the sap query tool?
What is the maximum number of match code id's that can be defined for one match code object? : abap data dictionary
