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 |
How table control cn be generated using bdc? : abap bdc
What is the process of project flow n sap?In context to project flow what are the role of an abapper?
How to write a code in tab control? : abap bdc
What is the function of a data element? : abap data dictionary
What is kernal badi? What is the difference between classic badi and kernal badi ? What is the advantages of kernal badi?
2 Answers Accenture, HBL Power Systems, IBM, Yash Technologies,
For particular transaction you want to upload the data using any of bdc method...if the transaction contains any of pop window functionaliy and having radio button in the window..Any one of the radio button must be selected then only the next data can be inserted how will you handle this scenario in your program
What are the ways you can do the tuning?
when do you need to create an internal table with header line ? and with out a header line?
What is the difference between report and script?
What are the payroll related Infotypes
which table contains the details of all Tcodes?
How do you set up background jobs in sap? What are the steps? What are the events driven batch jobs?