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 |
Some one is running a program in Foreground which has to be run in Back ground. How you are going to instruct to do in Back ground?
How will you define posting procedures?
What are uses of foreign key?
What is the keyword used to access a program from global memory?
what comes in Timkein written test I hope some body can tell me at this id plz tell it before 9 pm 19 march
what types of request are used to transport repository objects?
in bdc. i have created bdc prg and executed. i got output in system. same bdc prg again executed in other system but i dint get the o/p. both system r in n/w connection. wats the prob.plz help me to get o/p.
Which infotype records can not be deleted ? : abap hr
Difference between interactive and ALV Reports
19) How to create client dependent tables and client independent tables?
In which table the material master data is stored?
What is the difference between get and get late?