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 |
What is dialog module?
What is the structure of bdcmsgcoll? : abap bdc
Reports: Event functionality.
What are the types of windows in sap script?
How many rediobutton groups can be there in a module pool program and in a report?
2 Answers BOC, BPCL Bharat Petroleum,
What is the difference between a structure and an append structure?
what is Delivery? In which tables delivery data will be stored?
What is the use of at new statement ?
What are the features of abap/4 dictionary? : abap data dictionary
IF transport where u can create req no for sctipts?
what is the model dialog box?
1 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
What are logical data bases used in hr module? : abap hr