How Calculate TOTALS,SUBTOTALS in ALV Reporting?
Answers were Sorted based on User's Feedback
Answer / siva
data: wa_fieldcat type slis_fieldcat_alv,
it_fieldcat type slis_t_fieldcat_alv.
data: wa_sort type slis_sortinfo_alv,
it_sort type slis_t_sortinfo_alv.
wa_fieldcat-do_sum = 'X'.
append wa_fieldcat to it_fieldcat.
wa_sort-fieldname = 'KUNNR'.
wa_sort-tabname = 'IT_FINAL'.
wa_sort-subtot = 'X'.
append wa_sort to it_sort.
Is This Answer Correct ? | 71 Yes | 7 No |
Answer / siva
data: wa_fieldcat type slis_fieldcat_alv,
it_fieldcat type slis_t_fieldcat_alv.
wa_fieldcat-do_sum = 'X'.
append wa_fieldcat to it_fieldcat.
Is This Answer Correct ? | 48 Yes | 9 No |
Answer / srinivasaai
data: wa_fieldcat type slis_fieldcat_alv,
it_fieldcat type slis_t_fieldcat_alv.
hi friend to calculate totals ,sub-totals we have to use
after declaring the fieldcat
for doing sum : wa_fieldcat-do_sum = 'X'.
fro caluculating subtotal : wa_sort-subtot = 'X'.
this have to be done when feildcatlog and suppliying the
sorting info.
I could make u to remind that this is the one of the
difference between a normal & alv report.
Is This Answer Correct ? | 40 Yes | 5 No |
Answer / 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 |
Answer / your friend
subtot(1) type c,
subtot_level(2) type n,
Same way we use for Currency conversion.
Means if you want currency in 3 decimal or country
specific, we can use slis structure fields
currency(5) type c,
cfieldname type slis_fieldname,
ctabname type slis_tabname, " and table
For quantity conversion:
quantity(3) type c,
qfieldname type slis_fieldname,
qtabname type slis_tabname, " and table
For justification & leading zeros
just(1) type c,
lzero(1) type c, " leading zero
Please check out SLIS type ... You can find many options.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / venumadhav
for which coloumn u want for subtotal in fieldcatalog give
sub-tot= 'X'.
Is This Answer Correct ? | 27 Yes | 35 No |
Answer / poorna
just call the function module reuse_alv_list_display in
that you will be having a parameter total and subtotals
Is This Answer Correct ? | 27 Yes | 44 No |
Can we use instance attributes inside a static attributes? say yes or no ?
1 Answers Accenture, Cognizant,
What are the types of search helps? : sap abap data dictionary
What are the sequences of event block?
Which table stores the programs created?
Explain the concept of clusters in payroll
What are internal tables? How do you get the number of lines in an internal table?
Reuse-ALV-grid control?
Can you call a bdc from a report program ?
How does the inventory get reduced after the delivery?
I have two structures s1 and s2 have same struture of five fields each how can u transfer data from s1 to s2
what is the difference detween EDI AND ALE?
In a transaction there are 5 screens (say) but while recording you could see only 3 screens.what will u do to avoid such situation?will u save it like that?