Interested to Buy Any Domain ? << Click Here >> for more details...
How Calculate TOTALS,SUBTOTALS in ALV Reporting?
- 7 Answers
- 54731 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
How many types of size categories and data classes are there?
Final class
how to read the standard field value in your custom program.
Do we create table fields with out data elements and domains?
What is difference between float and packed data type?
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?
What is the difference between data elements and domains?
What is an “on input filed” statements?
What is personnel sub are
How do you write a function module in sap?
What are the main uses of the primary key?
Can we include customizing include or an append structure with pooled or cluster tables? : abap data dictionary
Difference between Field groups and internal tables?
What does the extract statement do in extract datasets?
Kindly help me to Know the process of mapping in EDI from R/3 to a convertor(third party which translates IDoc flatfile to EDIFACT /XML / FTP /HTTP ) ?
